RE: Table Level Restore Example?
A user on IDS 10.00.FC7 wanted to use archecker table-level restore to pull a table out of a production ontape archive into a different instance/database (test), and kept getting errors such as "Tables not located on archive... produced 0 rows". Replies first pointed to IBM docs, tech notes and a developerWorks article on table-level restore. John Miller then clarified that the restore output can target a remote/distributed database on another instance, but archecker itself must run on a machine of the same type and version as the archive source (same limits as ontape), giving a sample schema file that inserts into target_db@rem_srv.target_tab from the source table. No follow-up confirming the user's success is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
To complement what Fernando sent you from the Informix Backup and Restore Guide, here are a few more links you might want to check:
Restoring to a different table in a different database using point-in-time table-level restore
http://www-1.ibm.com/support/docview.wss?uid=swg21216345
Running Archecker Table-Level Restore in Stages
http://www-1.ibm.com/support/docview.wss?uid=swg21188867
IDS Experts Blog - Table Level Restore
http://www-128.ibm.com/developerworks/blogs/page/gbowerman?entry=table_level_restore_developerworks_article&ca=drs-bl
... which points you to this article at IBM DeveloperWorks, among other info:
Data archiving with Informix Dynamic Server table-level restore
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0704fraenkle/index.html
Regards,
Veronica.
> From: natebsi@gmail.com
> Subject: Table Level Restore Example?
> Date: Sun, 8 Jun 2008 19:46:15 -0700
> To: informix-list@iiug.org
>
> Hi all,
>
> I'm doing a restore in the test instance using the production tape,
> and I can't make it work. I get various errors depending on how the
> schema file looks. Both instances are 10.00.FC7.
>
> For the sake of argument:
>
> The production instance:
> INFORMIXSERVER=prod_tcp> Database = prod
>
> Test instance:
> INFORMIXSERVER=test_tcp> Database = test
>
> Can someone give me an example of how the schema file and archecker
> command would look like? Or is it even possible?
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
_________________________________________________________________
Get your fix of news, sports, entertainment and more on MSN Mobile
http://www.msnmobilefix.com/Default.aspx
On Jun 9, 5:28 am, Veronica Gomes <vgom...@hotmail.com> wrote:
> Hi,
>
> To complement what Fernando sent you from the Informix Backup and Restore Guide, here are a few more links you might want to check:
>
> Restoring to a different table in a different database using point-in-time table-level restorehttp://www-1.ibm.com/support/docview.wss?uid=swg21216345
>
> Running Archecker Table-Level Restore in Stageshttp://www-1.ibm.com/support/docview.wss?uid=swg21188867
>
> IDS Experts Blog - Table Level Restorehttp://www-128.ibm.com/developerworks/blogs/page/gbowerman?entry=tabl...
>
> ... which points you to this article at IBM DeveloperWorks, among other info:
>
> Data archiving with Informix Dynamic Server table-level restorehttp://www.ibm.com/developerworks/db2/library/techarticle/dm-0704frae...
>
> Regards,
> Veronica.
>
>
>
>
>
> > From: nate...@gmail.com
> > Subject: Table Level Restore Example?
> > Date: Sun, 8 Jun 2008 19:46:15 -0700
> > To: informix-l...@iiug.org
>
> > Hi all,
>
> > I'm doing a restore in the test instance using the production tape,
> > and I can't make it work. I get various errors depending on how the
> > schema file looks. Both instances are 10.00.FC7.
>
> > For the sake of argument:
>
> > The production instance:
> > INFORMIXSERVER=prod_tcp> > Database = prod
>
> > Test instance:
> > INFORMIXSERVER=test_tcp> > Database = test
>
> > Can someone give me an example of how the schema file and archecker
> > command would look like? Or is it even possible?
>
> > _______________________________________________
> > Informix-list mailing list
> > Informix-l...@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
>
> _________________________________________________________________
> Get your fix of news, sports, entertainment and more on MSN Mobilehttp://www.msnmobilefix.com/Default.aspx- Hide quoted text -
>
> - Show quoted text -
Sorry, I was a bit tired when I wrote this and should have given more
info. I've been through the doc and there is no mention anywhere of
restoring data from a tape that was not taken from the instance you
are restoring to. Where the INFORMIXSERVER and database names are
different. It seems like it should work, and some of the examples are
close, but not exact.
Should it work? If someone can give me a quick example of what the
schema file and command line should look like, I can try it and report
back.
Thanks for the replies, btw!
I did try someone similiar to this:
database demo1;
create table customer
(
customer_num serial not null ,
fname char(15),
lname char(15),
company char(20),
address1 char(20),
address2 char(20),
city char(15),
state char(2),
zipcode char(5),
phone char(18),
primary key (customer_num)
) in dbspace2;
database demo2;
create table customer_tlr
(
customer_num serial not null ,
fname char(15),
lname char(15),
company char(20),
address1 char(20),
address2 char(20),
city char(15),
state char(2),
zipcode char(5),
phone char(18),
primary key (customer_num)
) in dbspace3;
insert into demo2:customer_tlr select * from demo1:customer;
restore to "2005-06-23 10:59:43";
Except the I didn't restore to a specific time. I did "restore to
current with no log;" . Do you have to restore to a point in time?
Using my method I get:
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: bcoetest:py_per_mstr produced 0 rows
On Jun 9, 5:28 am, Veronica Gomes <vgom...@hotmail.com> wrote:
> Hi,
>
> To complement what Fernando sent you from the Informix Backup and Restore Guide, here are a few more links you might want to check:
>
> Restoring to a different table in a different database using point-in-time table-level restorehttp://www-1.ibm.com/support/docview.wss?uid=swg21216345
>
> Running Archecker Table-Level Restore in Stageshttp://www-1.ibm.com/support/docview.wss?uid=swg21188867
>
> IDS Experts Blog - Table Level Restorehttp://www-128.ibm.com/developerworks/blogs/page/gbowerman?entry=tabl...
>
> ... which points you to this article at IBM DeveloperWorks, among other info:
>
> Data archiving with Informix Dynamic Server table-level restorehttp://www.ibm.com/developerworks/db2/library/techarticle/dm-0704frae...
>
> Regards,
> Veronica.
>
>
>
>
>
> > From: nate...@gmail.com
> > Subject: Table Level Restore Example?
> > Date: Sun, 8 Jun 2008 19:46:15 -0700
> > To: informix-l...@iiug.org
>
> > Hi all,
>
> > I'm doing a restore in the test instance using the production tape,
> > and I can't make it work. I get various errors depending on how the
> > schema file looks. Both instances are 10.00.FC7.
>
> > For the sake of argument:
>
> > The production instance:
> > INFORMIXSERVER=prod_tcp> > Database = prod
>
> > Test instance:
> > INFORMIXSERVER=test_tcp> > Database = test
>
> > Can someone give me an example of how the schema file and archecker
> > command would look like? Or is it even possible?
>
> > _______________________________________________
> > Informix-list mailing list
> > Informix-l...@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
>
> _________________________________________________________________
> Get your fix of news, sports, entertainment and more on MSN Mobilehttp://www.msnmobilefix.com/Default.aspx- Hide quoted text -
>
> - Show quoted text -
Wow, I really thought this would be an easy answer. :)
Can someone just tell me if its possible to use archecker to restore a
table from an ontape that is from a different instance? Has anyone
done it before? I spoke with Informix, and I got the "I'll have to
research and get back to you" answer.
natebsi@gmail.com wrote:
> Wow, I really thought this would be an easy answer. :)
>
> Can someone just tell me if its possible to use archecker to restore a
> table from an ontape that is from a different instance? Has anyone
> done it before? I spoke with Informix, and I got the "I'll have to
> research and get back to you" answer.
The output of table level restore can be a distributed/remote database
on a different computer/instance, but the computer which you execute
archecker must be of the same type and version (i.e. the same
limitations as ontape)
EXAMPLE OF A DISTRIBUTED RESTORE
================================
database test;
create table source_tab
( columns ) in dbspace1;
database target_dbs@rem_srv;
create table target_tab
( columns );
insert into
target_dbs@rem_srv.target_tab
select * from source_tab
natebsi@gmail.com wrote:
> Wow, I really thought this would be an easy answer. :)
>
> Can someone just tell me if its possible to use archecker to restore a
> table from an ontape that is from a different instance? Has anyone
> done it before? I spoke with Informix, and I got the "I'll have to
> research and get back to you" answer.
The output of table level restore can be a distributed/remote database
on a different computer/instance, but the computer which you execute
archecker must be of the same type and version (i.e. the same
limitations as ontape)
EXAMPLE OF A DISTRIBUTED RESTORE
================================
database test;
create table source_tab
( columns ) in dbspace1;
database target_dbs@rem_srv;
create table target_tab
( columns );
insert into
target_dbs@rem_srv.target_tab
select * from source_tab
natebsi@gmail.com wrote:
> Wow, I really thought this would be an easy answer. :)
>
> Can someone just tell me if its possible to use archecker to restore a
> table from an ontape that is from a different instance? Has anyone
> done it before? I spoke with Informix, and I got the "I'll have to
> research and get back to you" answer.
The output of table level restore can be a distributed/remote database
on a different computer/instance, but the computer which you execute
archecker must be of the same type and version (i.e. the same
limitations as ontape)
EXAMPLE OF A DISTRIBUTED RESTORE
================================
database test;
create table source_tab
( columns ) in dbspace1;
database target_dbs@rem_srv;
create table target_tab
( columns );
insert into
target_dbs@rem_srv.target_tab
select * from source_tab