Friday, January 30, 2015

Restore Database in DB2 to another instance


db2cmd -i -w db2clpsetcp
echo %DB2CLP%
db2
CONNECT TO MAXDB71 USER db2admin USING <db2admin’s password>
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
CONNECT RESET
force applications all
Restore DATABASE MAXDB71 USER db2admin USING <db2admin’s password> FROM “D:\TSRMBKPSCRIPT” WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING
CONNECT TO MAXDB71 USER db2admin USING <db2admin’s password>
UNQUIESCE DATABASE
CONNECT RESET

No comments:

Post a Comment