Windows DB2 Backup Commands

Offline Backup Commands:

CONNECT TO database-name

QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS

CONNECT RESET

BACKUP DATABASE database-name LOAD ‘C:\Program Files\BEX\bin\bexdb2.dll’ OPEN 1 SESSIONS WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING

CONNECT TO database-name

UNQUIESCE DATABASE

CONNECT RESET

Online Backup Commands:

BACKUP DATABASE database-name ONLINE LOAD ‘C:\Program Files\BEX\bin\bexdb2.dll’ OPEN 1 SESSIONS WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 INCLUDE LOGS WITHOUT PROMPTING