How to access tomy db2 database Version 7.1 under windows

rudito · #1 (**permalink**) 02-08-09, 12:30

Hello,
I'm e newbee to db2.
I customer gave me via xcopy a DB2 Version 7.1 database:

The Folder Structure is:
SQL00001
DB2EVENT
SQLLOGDIR
SQLT0000.0
...
SQLTMPLK

I've installed DB2 v.8.1
Is it possible to migrate this database without a normal backup?

thanks id advance

przytula_guy · #2 (**permalink**) 02-09-09, 05:01

I don't think a filesystem copy can help you
I have never seen someone doing this
try list db directory on c: or the disk you copied the files
catalog db on c:
db2 migrate ....
try backup in v7 and restore in v8 would migrate the db

dr_te_z · #3 (**permalink**) 02-09-09, 05:17

Quote:

Originally Posted by przytula_guy

I don't think a filesystem copy can help you

I agree. Ask for
- a backup-image and/or
- the output of a "db2move db export" operation and/or
- all the tables in exported in "*.ixf" format and/or
- the DDL generated by db2look

those are usefull stuff for you to re-create the database (and we can help you).

n_i · #4 (**permalink**) 02-09-09, 06:37

Quote:

Originally Posted by rudito

I'm e newbee to db2.
I customer gave me via xcopy a DB2 Version 7.1 database:

The Folder Structure is:
SQL00001

Somehow questions like this make me think that the database may not have been "given by a customer", but, how do I put it, obtained by some other means...

Internet Services

Web Development

Digital Marketing

Consumer Tech