Hi All

I am working as a support specialist for GRID MP for GSK.
We are taking up the backup of the database and writing it to a unix directory
using the following command:

su -l $INST -c "db2 backup db $DBNAME ONLINE to $ARCHIVE_PATH"

$INST : db2inst1 (databse schema name)
$DBNAME : UDDB (database name)
$ARCHIVE_PATH : /GWD/appbase/projects/GRIDDB/backup (PATH of directory)

Then we zip the database backup in the above path.
But due to lack of space in the above path,we are not able to do.

So thought of writing the backup in the compressed form directly to the above path i,e the /GWD/appbase/projects/GRIDDB/backup should conatin the zipped backup file.


I tried to use compress option of database backup command to write directly to the path but couldn't do it.

Please help me out with the proper syntax of the compress command.
It will be very helpful if someone will provide me with any example.

I went through the following link
http://www.dbforums.com/t995499.html
and found the syntax but couldn't use in the command .


Please help.


Thanks

Alpha

the command is just db2 backup db xx to yy compress or see this link
http://publib.boulder.ibm.com/infoce...c/r0001933.htm
what is the error you get ?

I gave the folowing command

db2 backup db UDDB ONLINE to /GWD/appbase/projects/GRIDDB/backup compress

But the database backup is getting written to the /GWD/appbase/projects/GRIDDB/backup path But I want the compressed backup to be written in the above path.

Please help

The DB2 backup compress option shrinks the backup (compared to not compressed) using a DB2 supplied compression routine. The name of a backup is the same whether it is compressed or uncompressed (using the compress option in the backup command).

Hi All

I am able to produce a compressed db2 backup by using the following command
db2 backup db xx to yy compress

The backup is now of 39 GB whereas the original backup was of 94 GB.
Thanks a lot to all of you for help.