Oninit cdi / Archive
Talk to an expert →

archecker redux.....no P word

Posted in 2006

Topics: Backup & Restore, Storage & Space Management, Connectivity: ESQL/C, 4GL & Embedded SQL, Data Types & Schema Design, Platform-Specific Issues

Tam O'Shanter — — source: Usenet: comp.databases.informix

Okay, Here is a copy of the command used, the schema file used and the outup when I last ran archecker. The frustrating bit is this: Table extraction commands 1 Tables found on archive 0 Tables not located on archive 1 I know the table is on this backup. Any thoughts? This is really strange and quite frustrating. I'm hoping it's something stupid I'm doing. ---------------------------------- Command: date archecker -Xtvs -lphys date ----------------------------------- Schema File: database my_qa_db; create table book_history ( book_no INT not null, crea_date_time CHAR(19) not null, hist_seqn_no SMALLINT not null, history_code CHAR(3) not null, tran_type CHAR(2) not null, item_seqn_no SMALLINT not null, item_text VARCHAR(255), received_from VARCHAR(60), processing_flg CHAR(1), duty_code CHAR(5) not null, branch_code CHAR(12) not null, crea_user_code CHAR(5) not null, crea_dest_id CHAR(8) not null ) in dbs4 ; insert into book_history Select * from book_history Where book_no > 10131825; restore to current with no log; ------------------------------------------- Output: Tue Nov 14 16:50:00 EST 2006 IBM Informix Dynamic Server Version 10.00.UC4 Program Name: archecker Version: 8.0 Released: 2005-11-18 22:22:21 CSDK: IBM Informix CSDK Version 2.90 ESQL: IBM Informix-ESQL Version 2.90.UC1 Compiled: 11/18/05 22:23 on Linux 2.4.21-27.0.2.ELsmp #1 SMP Wed Jan 12 2 3:35:44 EST 2005 Debug level set to LOW Debug Components set to 0xFFFFC Debugging for component parser - enabled Debugging for component sql - enabled Debugging for component sblob - enabled Debugging for component lowlevel - enabled Debugging for component partition - enabled Debugging for component acu - enabled Debugging for component chunk - enabled Debugging for component page - enabled Debugging for component ipa - enabled Debugging for component eval - enabled Debugging for component onbar - enabled Debugging for component ontape - enabled Debugging for component log - enabled Debugging for component apply - enabled Debugging for component stager - enabled Debugging for component other - enabled AC_STORAGE /tmp AC_MSGPATH /opt/informix/my_web/ac_chk.log AC_VERBOSE on AC_TAPEDEV /dev/st0 AC_TAPEBLOCK 512 KB AC_LTAPEDEV /dev/null AC_LTAPEBLOCK 256 KB Command line is overriding command file RESTORE option Extracting table my_qa_db:book_history into my_qa_db:book_history Please put in Phys Tape 1. Type <return> or 0 to end: Tape type: Archive Backup Tape OnLine version: IBM Informix Dynamic Server Version 10.00.UC4 Archive date: Tue Nov 14 00:01:02 2006 Archive level: 0 Tape blocksize: 524288 Tape size: 0 Tape number in series: 1 ........................................ ........................................ ........................................ <snip> ........................................ ........................................ ........................................ ................... Scan PASSED Control page checks PASSED Table checks PASSED Table extraction commands 1 Tables found on archive 0 Tables not located on archive 1 LOADED: my_qa_db:book_history produced 0 rows Tue Nov 14 18:24:54 EST 2006

↪ replying to Tam O'Shanter
Superboer — — source: Usenet: comp.databases.informix

i would restore the backup to a test box and check if it is there including checking if > Select * from book_history> > Where book_no > 10131825; returns any rows. Superboer. Tam O'Shanter schreef: > Okay, > > Here is a copy of the command used, the schema file used and the outup when > I last ran archecker. > > The frustrating bit is this: > > Table extraction commands 1 > > Tables found on archive 0 > > Tables not located on archive 1 > > I know the table is on this backup. > > Any thoughts? > > This is really strange and quite frustrating. > > I'm hoping it's something stupid I'm doing. > > ---------------------------------- > Command: > date > > archecker -Xtvs -lphys > > date > > ----------------------------------- > Schema File: > > database my_qa_db; > create table book_history (> > book_no INT not null, > > crea_date_time CHAR(19) not null, > > hist_seqn_no SMALLINT not null, > > history_code CHAR(3) not null, > > tran_type CHAR(2) not null, > > item_seqn_no SMALLINT not null, > > item_text VARCHAR(255), > > received_from VARCHAR(60), > > processing_flg CHAR(1), > > duty_code CHAR(5) not null, > > branch_code CHAR(12) not null, > > crea_user_code CHAR(5) not null, > > crea_dest_id CHAR(8) not null > > ) in dbs4 ; > > insert into book_history> > Select * from book_history> > Where book_no > 10131825; > > restore to current with no log; > > > ------------------------------------------- > Output: > > > > Tue Nov 14 16:50:00 EST 2006 > > IBM Informix Dynamic Server Version 10.00.UC4 > > Program Name: archecker > > Version: 8.0 > > Released: 2005-11-18 22:22:21 > > CSDK: IBM Informix CSDK Version 2.90 > > ESQL: IBM Informix-ESQL Version 2.90.UC1 > > Compiled: 11/18/05 22:23 on Linux 2.4.21-27.0.2.ELsmp #1 SMP Wed Jan > 12 2 > > 3:35:44 EST 2005 > > > > Debug level set to LOW > > Debug Components set to 0xFFFFC > > Debugging for component parser - enabled > > Debugging for component sql - enabled > > Debugging for component sblob - enabled > > Debugging for component lowlevel - enabled > > Debugging for component partition - enabled > > Debugging for component acu - enabled > > Debugging for component chunk - enabled > > Debugging for component page - enabled > > Debugging for component ipa - enabled > > Debugging for component eval - enabled > > Debugging for component onbar - enabled > > Debugging for component ontape - enabled > > Debugging for component log - enabled > > Debugging for component apply - enabled > > Debugging for component stager - enabled > > Debugging for component other - enabled > > AC_STORAGE /tmp > > AC_MSGPATH /opt/informix/my_web/ac_chk.log > > AC_VERBOSE on > > AC_TAPEDEV /dev/st0 > > AC_TAPEBLOCK 512 KB > > AC_LTAPEDEV /dev/null > > AC_LTAPEBLOCK 256 KB > > Command line is overriding command file RESTORE option > > Extracting table my_qa_db:book_history into my_qa_db:book_history > > > > Please put in Phys Tape 1. > > Type <return> or 0 to end: > > > > Tape type: Archive Backup Tape > > OnLine version: IBM Informix Dynamic Server Version 10.00.UC4 > > Archive date: Tue Nov 14 00:01:02 2006 > > Archive level: 0 > > Tape blocksize: 524288 > > Tape size: 0 > > Tape number in series: 1 > > ........................................ > > ........................................ > > ........................................ > > <snip> > > ........................................ > > ........................................ > > ........................................ > > ................... > > Scan PASSED > > Control page checks PASSED > > Table checks PASSED > > Table extraction commands 1 > > Tables found on archive 0 > > Tables not located on archive 1 > > LOADED: my_qa_db:book_history produced 0 rows > > Tue Nov 14 18:24:54 EST 2006

↪ replying to Superboer
Tam O'Shanter — — source: Usenet: comp.databases.informix

Yes. It does. Any other suggestions? Tam. "Superboer" <superboer7@t-online.de> wrote in message news:1163588676.389674.158600@i42g2000cwa.googlegroups.com... >i would restore the backup to a test box and check if it is there > including > checking if > >> Select * from book_history>> >> Where book_no > 10131825; > > returns any rows. > > > Superboer. > > > Tam O'Shanter schreef: > >> Okay, >> >> Here is a copy of the command used, the schema file used and the outup >> when >> I last ran archecker. >> >> The frustrating bit is this: >> >> Table extraction commands 1 >> >> Tables found on archive 0 >> >> Tables not located on archive 1 >> >> I know the table is on this backup. >> >> Any thoughts? >> >> This is really strange and quite frustrating. >> >> I'm hoping it's something stupid I'm doing. >> >> ---------------------------------- >> Command: >> date >> >> archecker -Xtvs -lphys >> >> date >> >> ----------------------------------- >> Schema File: >> >> database my_qa_db; >> create table book_history (>> >> book_no INT not null, >> >> crea_date_time CHAR(19) not null, >> >> hist_seqn_no SMALLINT not null, >> >> history_code CHAR(3) not null, >> >> tran_type CHAR(2) not null, >> >> item_seqn_no SMALLINT not null, >> >> item_text VARCHAR(255), >> >> received_from VARCHAR(60), >> >> processing_flg CHAR(1), >> >> duty_code CHAR(5) not null, >> >> branch_code CHAR(12) not null, >> >> crea_user_code CHAR(5) not null, >> >> crea_dest_id CHAR(8) not null >> >> ) in dbs4 ; >> >> insert into book_history>> >> Select * from book_history>> >> Where book_no > 10131825; >> >> restore to current with no log; >> >> >> ------------------------------------------- >> Output: >> >> >> >> Tue Nov 14 16:50:00 EST 2006 >> >> IBM Informix Dynamic Server Version 10.00.UC4 >> >> Program Name: archecker >> >> Version: 8.0 >> >> Released: 2005-11-18 22:22:21 >> >> CSDK: IBM Informix CSDK Version 2.90 >> >> ESQL: IBM Informix-ESQL Version 2.90.UC1 >> >> Compiled: 11/18/05 22:23 on Linux 2.4.21-27.0.2.ELsmp #1 SMP Wed >> Jan >> 12 2 >> >> 3:35:44 EST 2005 >> >> >> >> Debug level set to LOW >> >> Debug Components set to 0xFFFFC >> >> Debugging for component parser - enabled >> >> Debugging for component sql - enabled >> >> Debugging for component sblob - enabled >> >> Debugging for component lowlevel - enabled >> >> Debugging for component partition - enabled >> >> Debugging for component acu - enabled >> >> Debugging for component chunk - enabled >> >> Debugging for component page - enabled >> >> Debugging for component ipa - enabled >> >> Debugging for component eval - enabled >> >> Debugging for component onbar - enabled >> >> Debugging for component ontape - enabled >> >> Debugging for component log - enabled >> >> Debugging for component apply - enabled >> >> Debugging for component stager - enabled >> >> Debugging for component other - enabled >> >> AC_STORAGE /tmp >> >> AC_MSGPATH /opt/informix/my_web/ac_chk.log >> >> AC_VERBOSE on >> >> AC_TAPEDEV /dev/st0 >> >> AC_TAPEBLOCK 512 KB >> >> AC_LTAPEDEV /dev/null >> >> AC_LTAPEBLOCK 256 KB >> >> Command line is overriding command file RESTORE option >> >> Extracting table my_qa_db:book_history into my_qa_db:book_history >> >> >> >> Please put in Phys Tape 1. >> >> Type <return> or 0 to end: >> >> >> >> Tape type: Archive Backup Tape >> >> OnLine version: IBM Informix Dynamic Server Version 10.00.UC4 >> >> Archive date: Tue Nov 14 00:01:02 2006 >> >> Archive level: 0 >> >> Tape blocksize: 524288 >> >> Tape size: 0 >> >> Tape number in series: 1 >> >> ........................................ >> >> ........................................ >> >> ........................................ >> >> <snip> >> >> ........................................ >> >> ........................................ >> >> ........................................ >> >> ................... >> >> Scan PASSED >> >> Control page checks PASSED >> >> Table checks PASSED >> >> Table extraction commands 1 >> >> Tables found on archive 0 >> >> Tables not located on archive 1 >> >> LOADED: my_qa_db:book_history produced 0 rows >> >> Tue Nov 14 18:24:54 EST 2006 >

Glossary