2011年7月21日 星期四

Db2 Backup

You have to turn on Administration Server.

C:.../> DB2ADMN SETID [username] (Enter)
C:.../> DB2ADMIN START

Then go to edit window and do the backup.
OR
CONNECT TO [schema Name];
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE [schema Name]TO "C:\db2data" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO [schema Name];
UNQUIESCE DATABASE;
CONNECT RESET;

沒有留言:

張貼留言