UPDATE DATABASE MANAGER CONFIGURATION USING MAX_QUERYDEGREE 4 ;

UPDATE DATABASE MANAGER CONFIGURATION USING NUM_POOLAGENTS 100 AUTOMATIC;

UPDATE DATABASE MANAGER CONFIGURATION USING NUM_INITAGENTS 0 ;

UPDATE DATABASE MANAGER CONFIGURATION USING RQRIOBLK 32767 ;

UPDATE DATABASE MANAGER CONFIGURATION USING SHEAPTHRES 0 ;

CONNECT TO SAMPLE;

ALTER BUFFERPOOL IBMDEFAULTBP SIZE 665664 ;

SET CURRENT QUERY OPTIMIZATION = 5;

COMMIT;

CONNECT RESET;

CONNECT TO SAMPLE;

QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;

UNQUIESCE DATABASE;

CONNECT RESET;

UPDATE DB CFG FOR SAMPLE USING logarchmeth1 LOGRETAIN logprimary 3 logsecond 2 logfilsiz 1000;

BACKUP DATABASE SAMPLE TO "C:\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING;

CONNECT TO SAMPLE;

QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;

UNQUIESCE DATABASE;

CONNECT RESET;

UPDATE DB CFG FOR SAMPLE USING logarchmeth1 LOGRETAIN logprimary 100 logsecond 6 logfilsiz 1024;

BACKUP DATABASE SAMPLE TO "C:\db2samplelog" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING;

CONNECT TO XJM;

QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;

UNQUIESCE DATABASE;

CONNECT RESET;

UPDATE DB CFG FOR XJM USING logarchmeth1 LOGRETAIN logprimary 13 logsecond 4 logfilsiz 1024;

BACKUP DATABASE XJM TO "C:\db2data_xjm" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING;

作者 jaminwm