Windows DB2 Restore Commands

Offline Restore for Existing Database:

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

Offline Restore for New Database:

RESTORE DATABASE database-name LOAD ‘C:\Program Files\BEX\bin\bexdb2.dll’ OPEN 1 SESSIONS TAKEN AT backup-time-yyyymmddhhmmss TO database-restore-destination-volume INTO new-database-name WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING

Online Restore for Existing Database:

RESTORE DATABASE database-name LOAD ‘C:\Program Files\BEX\bin\bexdb2.dll’ OPEN 1 SESSIONS TAKEN AT backup-time-yyyymmddhhmmss LOGTARGET log-file-restore-destination-volume WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING

Online Restore for New Database:

RESTORE DATABASE database-name LOAD ‘C:\Program Files\BEX\bin\bexdb2.dll’ OPEN 1 SESSIONS TAKEN AT backup-time-yyyymmddhhmmss TO database-restore-destination-volume INTO new-database-name LOGTARGET log-file-restore-destination-volume WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING