DB2 9.5 on windows with compression

itsonlyme44 · #1 (**permalink**) 07-31-09, 08:18

DB2 V9.5 (FP2) on Windows. Can't figure out the sytax for the backup with Compression command.

Code:

DB2 BACKUP DATABASE UDBDWDUT TO i:\ WITH 2 BUF
FERS BUFFER 1024 COMPRESS INCLUDE LOGS PARALLELISM 1 WITHOUT PROMPTING

SQL0104N An unexpected token "PARALLELISM" was found following "LOGS".
Expected tokens may include: "END-OF-STATEMENT". SQLSTATE=42601

tonkuma · #2 (**permalink**) 07-31-09, 08:26

Sequence of options are fixed.
Please try to replace PARALLELISM.
BACKUP DATABASE UDBDWDUT TO i:\ WITH 2 BUF
FERS BUFFER 1024 PARALLELISM 1 COMPRESS INCLUDE LOGS WITHOUT PROMPTING

przytula_guy · #3 (**permalink**) 07-31-09, 08:27

if not specified, the backup is offline. with offline there is no need to include logs..

itsonlyme44 · #4 (**permalink**) 07-31-09, 08:54

Code:

db2 BACKUP DATABASE CVNREPO TO i:\ WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS INCLUDE LOGS WITHOUT PROMPTING

SQL2032N The "iOptions" parameter is not valid.

db2girl · #5 (**permalink**) 07-31-09, 09:04

remove "include logs"

itsonlyme44 · #6 (**permalink**) 07-31-09, 09:24

Thank you .. that worked great! If I want to insure that it is a Full OFFLINE backup so that no roll-forward is needed when restoring, would I simply quiesce the DB first or do I need to specify OFFLINE in the command???

Cougar8000 · #7 (**permalink**) 07-31-09, 09:46

Can I suggest you look into the manual! Those are very simple answers that you should be able to find there.

Internet Services

Web Development

Digital Marketing

Consumer Tech