Friday, December 12, 2014

DB2 Configure Database Logging Wizard

image

image

image

image

image

image

image

image

image

image

image

Scripts:

CONNECT TO SAMPLEDB
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
UNQUIESCE DATABASE
CONNECT RESET
UPDATE DB CFG FOR SAMPLEDB USING logarchmeth1 "DISK:D:\PrimaryLog" logprimary 13 logsecond 4 logfilsiz 2500 failarchpath "D:\SecondaryLog"
BACKUP DATABASE SAMPLEDB TO "D:\backup" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING