By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,279 Members | 1,673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,279 IT Pros & Developers. It's quick & easy.

Recovering tables from DB2 V2

P: n/a
I have a database instance from DB2 V2 under AIX 3.2.5. I want to dump all the
tables in this database, but don't have a running DB2 V2 instance. Assume I
have access to any number of 'modern' DB2 installations on AIX, and I don't care
about metadata like indexes--I just want to see the contents of the tables.

What is the most direct way to export the database contents?

/ff
Oct 9 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

FearlessFerret schrieb:
I have a database instance from DB2 V2 under AIX 3.2.5. I want to dump all the
tables in this database, but don't have a running DB2 V2 instance. Assume I
have access to any number of 'modern' DB2 installations on AIX, and I don't care
about metadata like indexes--I just want to see the contents of the tables.

What is the most direct way to export the database contents?

/ff
Do you have an offline DB2 backup of your database ? If yes restore it
on a DB2 V5 or V6 system (not sure if V7 would also restore a V2
backup).

If there is no backup then you may want take a look at the db2dart tool
(not 100% sure if it was contained with DB2 V2).
Run "db2dart <dbname/DDEL". Next you'll have to enter tablespace id
and table name/id. db2dart then dumps the table data in DEL format into
a file. Note that LOB and LONG VARCHAR columns are not supported

HTH
Joachim

Oct 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.