Recovering tables from DB2 V2

[FearlessFerret]

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

[Joachim Klassen]

Re: Recovering tables from DB2 V2


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