Oninit cdi / Archive
Talk to an expert →

IDS 10 table-level restore

Posted in 2006

Summary

On IDS 10.00.UC4 (Red Hat AS3), the poster tried a single-table restore from an ontape level-0 archive using archecker with an AC_CONFIG file and schema command file. The run reported "Tables found on archive 0 / Tables not located on archive 1" and loaded 0 rows. Suggestions from others included ER/shadow-column issues and a stray semicolon after the database name. The poster resolved it himself: dropping the '-lphys' option (running 'archecker -tdvs' instead) made the table restore work, though he didn't know why, since the docs' examples used it.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Backup & Restore, Versions, Editions & End-of-Life

ROBERT ROUSSEY — — source: IIUG Forums & Mailing Lists

IDS 10.00.UC4, RedHat AS3 Trying to test single-table restore. Got a good backup and dropped a table. My restore command script has the following: =============================================== export AC_CONFIG=$INFORMIXDIR/etc/ac_config.tst archecker -D archecker -Xtvs -lphys =============================================== My $AC_CONFIG contains the following: =============================================== AC_DEBUG 1 AC_MSGPATH /opt/informix/spirit_web/ac_chk.log AC_SCHEMA /tmp/rest_test.sch AC_STORAGE /tmp AC_TAPEBLOCK 512 AC_TAPEDEV /dev/st0 AC_VERBOSE 1 =============================================== Schema file contains the following: =============================================== database spirit: create table bookings (< cols > ) in dbs4; insert into bookings select * from bookings where book_no > 1000000; restore to current with no log; =============================================== The result is: =============================================== STATUS: Control page checks PASSED STATUS: Table checks PASSED STATUS: Table extraction commands 1 STATUS: Tables found on archive 0 STATUS: Tables not located on archive 1 STATUS: LOADED: spirit_qa_db:bookings produced 0 rows =============================================== In other words, absolute failure. Anyone else successfully restored a full table from an ontape level-0 archive? What (obvious thing) am I missing? TIA Bob Roussey

↪ replying to ROBERT ROUSSEY
Madison Pruet — — source: IIUG Forums & Mailing Lists

Are(were) you replicating this table via ER? = "ROBERT ROUSSEY" = <robert.roussey@s = piritair.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect IDS 10 table-level restore [7816= ] 11/15/2006 03:39 = PM = = = Please respond to = ids@iiug.org = = = IDS 10.00.UC4, RedHat AS3 Trying to test single-table restore. Got a good backup and dropped a ta= ble. My restore command script has the following: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D export AC_CONFIG=3D$INFORMIXDIR/etc/ac_config.tst archecker -D archecker -Xtvs -lphys =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D My $AC_CONFIG contains the following: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D AC_DEBUG 1 AC_MSGPATH /opt/informix/spirit_web/ac_chk.log AC_SCHEMA /tmp/rest_test.sch AC_STORAGE /tmp AC_TAPEBLOCK 512 AC_TAPEDEV /dev/st0 AC_VERBOSE 1 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Schema file contains the following: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D database spirit: create table bookings (< cols > ) in dbs4; insert into bookings select * from bookings where book_no > 1000000; restore to current with no log; =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D The result is: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D STATUS: Control page checks PASSED STATUS: Table checks PASSED STATUS: Table extraction commands 1 STATUS: Tables found on archive 0 STATUS: Tables not located on archive 1 STATUS: LOADED: spirit_qa_db:bookings produced 0 rows =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D In other words, absolute failure. Anyone else successfully restored a f= ull table from an ontape level-0 archive? What (obvious thing) am I missing= ? TIA Bob Roussey ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to ROBERT ROUSSEY
Peter_Logan@spartanstores.com — — source: IIUG Forums & Mailing Lists

do you really have a ";" after the database name .... that might do it ... I have successfully done this with onbar .... you are on xc4 or higher right? "ROBERT ROUSSEY" <robert.roussey@spiritair.com> Sent by: ids-bounces@iiug.org 11/15/2006 04:39 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject IDS 10 table-level restore [7816] IDS 10.00.UC4, RedHat AS3 Trying to test single-table restore. Got a good backup and dropped a table. My restore command script has the following: =============================================== export AC_CONFIG=$INFORMIXDIR/etc/ac_config.tst archecker -D archecker -Xtvs -lphys =============================================== My $AC_CONFIG contains the following: =============================================== AC_DEBUG 1 AC_MSGPATH /opt/informix/spirit_web/ac_chk.log AC_SCHEMA /tmp/rest_test.sch AC_STORAGE /tmp AC_TAPEBLOCK 512 AC_TAPEDEV /dev/st0 AC_VERBOSE 1 =============================================== Schema file contains the following: =============================================== database spirit: create table bookings (< cols > ) in dbs4; insert into bookings select * from bookings where book_no > 1000000; restore to current with no log; =============================================== The result is: =============================================== STATUS: Control page checks PASSED STATUS: Table checks PASSED STATUS: Table extraction commands 1 STATUS: Tables found on archive 0 STATUS: Tables not located on archive 1 STATUS: LOADED: spirit_qa_db:bookings produced 0 rows =============================================== In other words, absolute failure. Anyone else successfully restored a full table from an ontape level-0 archive? What (obvious thing) am I missing? TIA Bob Roussey ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Madison Pruet
Robert Roussey\\\\(MIS\\\\) — — source: IIUG Forums & Mailing Lists

No HDR or ER running. Just a standalone QA database that was restored from a production (HDR primary) archive tape. Does HDR or ER impact table-level restores? Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: Madison Pruet [mailto:mpruet@us.ibm.com] Sent: Wednesday, November 15, 2006 5:08 PM To: Robert Roussey(MIS) Subject: Re: IDS 10 table-level restore [7817] Are(were) you replicating this table via ER? = "ROBERT ROUSSEY" = <robert.roussey@s = piritair.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect IDS 10 table-level restore [7816= ] 11/15/2006 03:39 = PM = = = Please respond to = ids@iiug.org = = = IDS 10.00.UC4, RedHat AS3 Trying to test single-table restore. Got a good backup and dropped a ta= ble. My restore command script has the following: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D export AC_CONFIG=3D$INFORMIXDIR/etc/ac_config.tst archecker -D archecker -Xtvs -lphys =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D My $AC_CONFIG contains the following: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D AC_DEBUG 1 AC_MSGPATH /opt/informix/spirit_web/ac_chk.log AC_SCHEMA /tmp/rest_test.sch AC_STORAGE /tmp AC_TAPEBLOCK 512 AC_TAPEDEV /dev/st0 AC_VERBOSE 1 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Schema file contains the following: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D database spirit: create table bookings (< cols > ) in dbs4; insert into bookings select * from bookings where book_no > 1000000; restore to current with no log; =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D The result is: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D STATUS: Control page checks PASSED STATUS: Table checks PASSED STATUS: Table extraction commands 1 STATUS: Tables found on archive 0 STATUS: Tables not located on archive 1 STATUS: LOADED: spirit_qa_db:bookings produced 0 rows =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D In other words, absolute failure. Anyone else successfully restored a f= ull table from an ontape level-0 archive? What (obvious thing) am I missing= ? TIA Bob Roussey ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. = ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Robert Roussey\\\\(MIS\\\\)
Madison Pruet — — source: IIUG Forums & Mailing Lists

I think that there might be an issue with the shadow columns. = "Robert = Roussey\\\\(MIS\\\\)" = <Robert.Roussey@S = To piritAir.com> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect RE: IDS 10 table-level restore = [7819] = 11/15/2006 04:13 = PM = = = Please respond to = ids@iiug.org = = = No HDR or ER running. Just a standalone QA database that was restored from a production (HDR primary) archive tape. Does HDR or ER impact table-level restores? Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: Madison Pruet [mailto:mpruet@us.ibm.com] Sent: Wednesday, November 15, 2006 5:08 PM To: Robert Roussey(MIS) Subject: Re: IDS 10 table-level restore [7817] Are(were) you replicating this table via ER? =3D "ROBERT ROUSSEY" =3D <robert.roussey@s =3D piritair.com> =3D To Sent by: ids@iiug.org =3D ids-bounces@iiug. =3D cc org =3D Subj=3D ect IDS 10 table-level restore [7816=3D ] 11/15/2006 03:39 =3D PM =3D =3D =3D Please respond to =3D ids@iiug.org =3D =3D =3D IDS 10.00.UC4, RedHat AS3 Trying to test single-table restore. Got a good backup and dropped a ta= =3D ble. My restore command script has the following: =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D =3D =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D export AC_CONFIG=3D3D$INFORMIXDIR/etc/ac_config.tst archecker -D archecker -Xtvs -lphys =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D =3D =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D My $AC_CONFIG contains the following: =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D =3D =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D AC_DEBUG 1 AC_MSGPATH /opt/informix/spirit_web/ac_chk.log AC_SCHEMA /tmp/rest_test.sch AC_STORAGE /tmp AC_TAPEBLOCK 512 AC_TAPEDEV /dev/st0 AC_VERBOSE 1 =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D =3D =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D Schema file contains the following: =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D =3D =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D database spirit: create table bookings (< cols > ) in dbs4; insert into bookings select * from bookings where book_no > 1000000; restore to current with no log; =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D =3D =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D The result is: =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D =3D =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D STATUS: Control page checks PASSED STATUS: Table checks PASSED STATUS: Table extraction commands 1 STATUS: Tables found on archive 0 STATUS: Tables not located on archive 1 STATUS: LOADED: spirit_qa_db:bookings produced 0 rows =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D =3D =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D In other words, absolute failure. Anyone else successfully restored a f= =3D ull table from an ontape level-0 archive? What (obvious thing) am I missing= =3D ? TIA Bob Roussey ***********************************************************************= =3D ******** Forum Note: Use "Reply" to post a response in the discussion forum. =3D ***********************************************************************= * ******* Forum Note: Use "Reply" to post a response in the discussion forum. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to Peter_Logan@spartanstores.com
Robert Roussey\\\\(MIS\\\\) — — source: IIUG Forums & Mailing Lists

It would appear that removing the '-lphys' part of the archecker command line solved the problem. Not sure why as the examples in the docs used it. New command line is: archecker -tdvs Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Peter_Logan@spartanstores.com Sent: Wednesday, November 15, 2006 5:09 PM To: ids@iiug.org Subject: Re: IDS 10 table-level restore [7818] do you really have a ";" after the database name .... that might do it ... I have successfully done this with onbar .... you are on xc4 or higher right? "ROBERT ROUSSEY" <robert.roussey@spiritair.com> Sent by: ids-bounces@iiug.org 11/15/2006 04:39 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject IDS 10 table-level restore [7816] IDS 10.00.UC4, RedHat AS3 Trying to test single-table restore. Got a good backup and dropped a table. My restore command script has the following: =============================================== export AC_CONFIG=$INFORMIXDIR/etc/ac_config.tst archecker -D archecker -Xtvs -lphys =============================================== My $AC_CONFIG contains the following: =============================================== AC_DEBUG 1 AC_MSGPATH /opt/informix/spirit_web/ac_chk.log AC_SCHEMA /tmp/rest_test.sch AC_STORAGE /tmp AC_TAPEBLOCK 512 AC_TAPEDEV /dev/st0 AC_VERBOSE 1 =============================================== Schema file contains the following: =============================================== database spirit: create table bookings (< cols > ) in dbs4; insert into bookings select * from bookings where book_no > 1000000; restore to current with no log; =============================================== The result is: =============================================== STATUS: Control page checks PASSED STATUS: Table checks PASSED STATUS: Table extraction commands 1 STATUS: Tables found on archive 0 STATUS: Tables not located on archive 1 STATUS: LOADED: spirit_qa_db:bookings produced 0 rows =============================================== In other words, absolute failure. Anyone else successfully restored a full table from an ontape level-0 archive? What (obvious thing) am I missing? TIA Bob Roussey ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary