Oninit cdi / Archive
Talk to an expert →

Selecting DBSPACE when using DBEXPORT and DBIMPORT

Posted in 2007

Summary

Navaid Arif's dbimport after dbexport put the database in ROOTDBS instead of TTSDBS. Paul Watson, Marcus and H.G explained that dbimport defaults to rootdbs unless the -d option names a dbspace, and that dbexport -ss records dbspace info; ontape or onbar keep dbspace information for real backups. Navaid thanked everyone and migrated the data successfully. Solved.

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

Topics: Storage & Space Management, Migration, Import/Export & Data Conversion

Navaid Arif — — source: IIUG Forums & Mailing Lists

Hi All, I have two dbspaces ROOTDBS (COOKED FILE) and TTSDBS (RAW). Previously, I had my database on TTSDBS. But when I took database backup using command "dbexport mydb" and after executing "oninit -i". I tried to restore it on the same dbspace "dbimport mydb", database start using ROOTDBS instead of using TTSDBS. a.. Anyone have any idea, why it used ROOTDBS. b.. Secondly, if I want to move my data back from ROOTDBS to TTSDBS, what option do I have other than using manual scripts to LOAD and UNLOAD data DMPs. Regards, Navaid Arif

↪ replying to Navaid Arif
Paul Watson — — source: IIUG Forums & Mailing Lists

Try dbimport -d <myspace> mydb Navaid Arif wrote: > Hi All, > > I have two dbspaces ROOTDBS (COOKED FILE) and TTSDBS (RAW). Previously, I had > my database on TTSDBS. But when I took database backup using command "dbexport > mydb" and after executing "oninit -i". I tried to restore it on the same > dbspace "dbimport mydb", database start using ROOTDBS instead of using TTSDBS. > a.. Anyone have any idea, why it used ROOTDBS. > b.. Secondly, if I want to move my data back from ROOTDBS to TTSDBS, what > option do I have other than using manual scripts to LOAD and UNLOAD data DMPs. > > Regards, > Navaid Arif > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-400-2620 Mob: +1 913-387-7529 Web: www.oninit.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid.

↪ replying to Navaid Arif
Marcus — — source: IIUG Forums & Mailing Lists

Hi, Dbexport imports to rootdbs if you do not name a destination dbspace (Option -d). For Backup/Restore, you should use ontape/onbar ... These keep the dbspace information. If you want to reorganize your data using dbexport/dbimport, you should use the -d option. Marcus -----Original Message----- From: Navaid Arif [mailto:navaid.arif@access.net.pk] Sent: Saturday, December 01, 2007 10:51 AM To: ids@iiug.org Subject: Selecting DBSPACE when using DBEXPORT and DBIMPORT [10564] Hi All, I have two dbspaces ROOTDBS (COOKED FILE) and TTSDBS (RAW). Previously, I had my database on TTSDBS. But when I took database backup using command "dbexport mydb" and after executing "oninit -i". I tried to restore it on the same dbspace "dbimport mydb", database start using ROOTDBS instead of using TTSDBS. a.. Anyone have any idea, why it used ROOTDBS. b.. Secondly, if I want to move my data back from ROOTDBS to TTSDBS, what option do I have other than using manual scripts to LOAD and UNLOAD data DMPs. Regards, Navaid Arif ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Navaid Arif
H.G — — source: IIUG Forums & Mailing Lists

1. dbimport mydb -d TTSDBS should import in TTSDBS dbs 2, If you would have used dbexport mydbs -ss, mydbs.sql would have correct dbspace info. Cheers Navaid Arif <navaid.arif@access.net.pk> wrote: Hi All, I have two dbspaces ROOTDBS (COOKED FILE) and TTSDBS (RAW). Previously, I had my database on TTSDBS. But when I took database backup using command "dbexport mydb" and after executing "oninit -i". I tried to restore it on the same dbspace "dbimport mydb", database start using ROOTDBS instead of using TTSDBS. a.. Anyone have any idea, why it used ROOTDBS. b.. Secondly, if I want to move my data back from ROOTDBS to TTSDBS, what option do I have other than using manual scripts to LOAD and UNLOAD data DMPs. Regards, Navaid Arif ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.

↪ replying to Paul Watson
Navaid Arif — — source: IIUG Forums & Mailing Lists

Thanks all. I have migrated my data successfully. Regards, Navaid Arif

Glossary