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;
沒有留言:
張貼留言