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

Attach Databasefiles

P: n/a
Hello

I have this test version of DB2 Universal Database (DB2 UDB) Enterprise
server Edition Version 8.2 on Windows Server 2003 installed, the Sample-DB
created and i can access it via ODBC.

I would like to insert existing databasefiles now, whose version I don't
know exactly. These are on the data base server, the path is
D:\DB2\NODE0000\CATN0000\20050419

Sorry, but I'm an absolute newbie in db2.
For each hints, I would be very grateful.

Best greetings
Mario


Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
THe directories you provided look like part of the structure what is
generated when a database is backed up. The database name should occur
before the "DB2" portion but appears to be missing in what you posted.
The file names should be nnnnnnnn.001, nnnnnnnn.002, etc where nnnnnnnn
is the time associated with the backup.

Assuming there are from a backup, you need to use the RESTORE DATABASE
command to rebuild the database. You didn't mantion logs so I'm assuming
you have an offline backup and you should specify the WITHOUT ROLLING
FORWARD clause in the RESTORE command.

Check the Command Reference manual for full details about BACKUP
DATABASE and RESTORE DATABASE.
Phil Sherman

Mario Adelbrecht wrote:
Hello

I have this test version of DB2 Universal Database (DB2 UDB) Enterprise
server Edition Version 8.2 on Windows Server 2003 installed, the Sample-DB
created and i can access it via ODBC.

I would like to insert existing databasefiles now, whose version I don't
know exactly. These are on the data base server, the path is
D:\DB2\NODE0000\CATN0000\20050419

Sorry, but I'm an absolute newbie in db2.
For each hints, I would be very grateful.

Best greetings
Mario

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.