Creating a new database with the existing database with same structure

nandra · #1 (**permalink**) 12-16-04, 11:56

Hi DBA Guru's,

Iam using DB2 V8.1 fixpack 4 and solaris. Alloted space for the database is 100% full for the existing database and now i have to create a new database with the same structure in different place on the same box.Can anybody tell me the exact process so that i can create a new database with the same structure and data.

Thanks in advance
Nandra

przytula · #2 (**permalink**) 12-16-04, 13:18

take an offline backup
restore database with redirect as parameter
change all container paths
restore continue
see information center and restore command for all parameters
this should help
Best Regards, Guy Przytula

nandra · #3 (**permalink**) 12-16-04, 14:22

Quote:

Originally Posted by przytula

take an offline backup
restore database with redirect as parameter
change all container paths
restore continue
see information center and restore command for all parameters
this should help
Best Regards, Guy Przytula

Thanks very much.........

Internet Services

Web Development

Digital Marketing

Consumer Tech