restore a single table from tape
Andrew Pistocchi asked whether a single table can be restored from a full Informix 10 archive tape. Art Kagel and H.G. said yes, using the archecker utility, with H.G. citing developerWorks articles. Sunil Thakkar added to consider referential constraints and data consistency, and to back up the current table first. Answered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Can you restore a single table from a full Informix Archive tape? We are running Informix 10. I have a scheduled backup every evening that backups the entire dbspaces. I have dbs0, dbs1 and dbs2 along with temp and root dbspaces. Our live database is in dbs0, train in dbs1 and dev in dbs2. Can I restore a single table from one of my databases from this full archive tape? Andy P.
Yes. You can restore a single table or any part thereof (ie filtered records) using the archecker utility. Art S. Kagel ----- Original Message ----- From: Andrew Pistocchi <ids@iiug.org> To: ids@iiug.org At: 10/08 15:29:22 Can you restore a single table from a full Informix Archive tape? We are running Informix 10. I have a scheduled backup every evening that backups the entire dbspaces. I have dbs0, dbs1 and dbs2 along with temp and root dbspaces. Our live database is in dbs0, train in dbs1 and dev in dbs2. Can I restore a single table from one of my databases from this full archive tape? Andy P. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Yes, you can restore a single table EASILY with archecker. Easy to use and no impact or damage to current table/data . There are many good articles on single table restore using archecker e.g http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0608kim/ http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0704fraenkle/in dex.html?ca=drs-&ca=dkw-informix Cheers. ANDREW PISTOCCHI <APISTOCCHI@UT.EDU> wrote: Can you restore a single table from a full Informix Archive tape? We are running Informix 10. I have a scheduled backup every evening that backups the entire dbspaces. I have dbs0, dbs1 and dbs2 along with temp and root dbspaces. Our live database is in dbs0, train in dbs1 and dev in dbs2. Can I restore a single table from one of my databases from this full archive tape? Andy P. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Need a vacation? Get great deals to amazing places on Yahoo! Travel.
Everything should work fine. However, make sure that you are taking into consideration the referencial constraints and the data consistency when before you try to do a single table import. Make a backup of your current table if you are not sure. Sunil. ________________________________ From: ids-bounces@iiug.org on behalf of H.G Sent: Mon 10/8/2007 9:40 PM To: ids@iiug.org Subject: Re: restore a single table from tape [10067] Yes, you can restore a single table EASILY with archecker. Easy to use and no impact or damage to current table/data . There are many good articles on single table restore using archecker e.g http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0608kim/ http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0704fraenkle/in dex.html?ca=drs-&ca=dkw-informix Cheers. ANDREW PISTOCCHI <APISTOCCHI@UT.EDU> wrote: Can you restore a single table from a full Informix Archive tape? We are running Informix 10. I have a scheduled backup every evening that backups the entire dbspaces. I have dbs0, dbs1 and dbs2 along with temp and root dbspaces. Our live database is in dbs0, train in dbs1 and dev in dbs2. Can I restore a single table from one of my databases from this full archive tape? Andy P. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Need a vacation? Get great deals to amazing places on Yahoo! Travel. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************** ******************* The information in this email is confidential and may be legally privileged. Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system. ******************************************************************************** *******************
Related threads
- Column name length in Informix
- Caching Data to Buffers
- Checkpoint Duration
- dbaccess standalone.
- Getting executable name.