Oninit cdi / Archive
Talk to an expert →

Re: redbrick backup

Posted in 2000

Topics: General Discussion

Frank Fudd — — source: Informix-list mailing list archive (1991-1998)

Hi, In the latest versions it is your choice. There are no utilities provided. All Redbrick data is stored in cooked files. Fudd. >From: Edward Rosenthal <edrosenthal@home.com> >Reply-To: Edward Rosenthal <edrosenthal@home.com> >To: informix-list@iiug.org >Subject: redbrick backup >Date: Tue, 24 Oct 2000 22:40:50 GMT > >This is a multi-part message in MIME format. >--------------69C31376448C7F8DB3C481C2 >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >anybody point out how redbrick is backed up? > > >--------------69C31376448C7F8DB3C481C2 >Content-Type: text/x-vcard; charset=us-ascii; > name="edrosenthal.vcf" >Content-Transfer-Encoding: 7bit >Content-Description: Card for Edward Rosenthal >Content-Disposition: attachment; > filename="edrosenthal.vcf" > >begin:vcard >n:rosenthal;edward >tel;pager:888 274 7679 >tel;cell:707 332 5558 >tel;fax:707 782 0766 call in advance >tel;home:707 782 0766 >tel;work:415 538 8996 >x-mozilla-html:FALSE >adr:;;;;;; >version:2.1 >email;internet:erosenth@cmpnet.com >fn:edward rosenthal >end:vcard > >--------------69C31376448C7F8DB3C481C2-- > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

↪ replying to Frank Fudd
Edward Rosenthal — — source: Informix-list mailing list archive (1991-1998)

if the main concern is corruption, and there is no archival process to get back the database in some known point in time when its 'clean', what should a dba do about that? are there some utilities to check for corruption in the load files, or some things to check the tables, indexes etc. Frank Fudd wrote: > Hi, > > In the latest versions it is your choice. There are no utilities provided. > All Redbrick data is stored in cooked files. > > Fudd. > > >From: Edward Rosenthal <edrosenthal@home.com> > >Reply-To: Edward Rosenthal <edrosenthal@home.com> > >To: informix-list@iiug.org > >Subject: redbrick backup > >Date: Tue, 24 Oct 2000 22:40:50 GMT > > > >This is a multi-part message in MIME format. > >--------------69C31376448C7F8DB3C481C2 > >Content-Type: text/plain; charset=us-ascii > >Content-Transfer-Encoding: 7bit > > > >anybody point out how redbrick is backed up? > > > > > >--------------69C31376448C7F8DB3C481C2 > >Content-Type: text/x-vcard; charset=us-ascii; > > name="edrosenthal.vcf" > >Content-Transfer-Encoding: 7bit > >Content-Description: Card for Edward Rosenthal > >Content-Disposition: attachment; > > filename="edrosenthal.vcf" > > > >begin:vcard > >n:rosenthal;edward > >tel;pager:888 274 7679 > >tel;cell:707 332 5558 > >tel;fax:707 782 0766 call in advance > >tel;home:707 782 0766 > >tel;work:415 538 8996 > >x-mozilla-html:FALSE > >adr:;;;;;; > >version:2.1 > >email;internet:erosenth@cmpnet.com > >fn:edward rosenthal > >end:vcard > > > >--------------69C31376448C7F8DB3C481C2-- > > > > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com.

↪ replying to Edward Rosenthal
Soren Archibald — — source: Informix-list mailing list archive (1991-1998)

Do you want to check for corruption in the load files or database files? Some utilities to check and fix corruption in database files: ALTER SEGMENT... VERIFY: checks the PSUs of the segment for read/write errors. REORG: can delete and write to a file all records that shouldn't be in the table either by corruption or whatever. (5.1) tblchk: A utility to update the number of rows in the segment's header with what is found in the segment. Replaced with CHECK TABLE... SQL command in version 6.0. (5.1) ixvalid: Checks index structure. Replaced with CHECK INDEX... SQL command in version 6.0. Soren Edward Rosenthal wrote: > > if the main concern is corruption, and there is no archival > process to get back the database in some known point in time > when its 'clean', what should a dba do about that? > are there some utilities to check for corruption in the load files, > or some things to check the tables, indexes etc. > > Frank Fudd wrote: > > > Hi, > > > > In the latest versions it is your choice. There are no utilities provided. > > All Redbrick data is stored in cooked files. > > > > Fudd. > > > > >From: Edward Rosenthal <edrosenthal@home.com> > > >Reply-To: Edward Rosenthal <edrosenthal@home.com> > > >To: informix-list@iiug.org > > >Subject: redbrick backup > > >Date: Tue, 24 Oct 2000 22:40:50 GMT > > > > > >This is a multi-part message in MIME format. > > >--------------69C31376448C7F8DB3C481C2 > > >Content-Type: text/plain; charset=us-ascii > > >Content-Transfer-Encoding: 7bit > > > > > >anybody point out how redbrick is backed up? > > > > > > > > >--------------69C31376448C7F8DB3C481C2 > > >Content-Type: text/x-vcard; charset=us-ascii; > > > name="edrosenthal.vcf" > > >Content-Transfer-Encoding: 7bit > > >Content-Description: Card for Edward Rosenthal > > >Content-Disposition: attachment; > > > filename="edrosenthal.vcf" > > > > > >begin:vcard > > >n:rosenthal;edward > > >tel;pager:888 274 7679 > > >tel;cell:707 332 5558 > > >tel;fax:707 782 0766 call in advance > > >tel;home:707 782 0766 > > >tel;work:415 538 8996 > > >x-mozilla-html:FALSE > > >adr:;;;;;; > > >version:2.1 > > >email;internet:erosenth@cmpnet.com > > >fn:edward rosenthal > > >end:vcard > > > > > >--------------69C31376448C7F8DB3C481C2-- > > > > > > > _________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > > > Share information about yourself, create your own public profile at > > http://profiles.msn.com.