Attach Databasefiles

[Mario Adelbrecht]

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\20050 419

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

Best greetings
Mario

[Phil Sherman]

Re: Attach Databasefiles

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:[color=blue]
> 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\20050 419
>
> Sorry, but I'm an absolute newbie in db2.
> For each hints, I would be very grateful.
>
> Best greetings
> Mario
>
>
>
>[/color]