By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,993 Members | 1,898 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,993 IT Pros & Developers. It's quick & easy.

BACKUP DATABASE

P: n/a
For years I have been hoping for a native db2 solution which
compresses data on BACKUP DATABASE. (Using Windows.) I have heard
that it will happen, but has anyone enough chutzpa to say if it will
happen in my working lifetime (I'm 61 and live dangerously)?

Stan
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Ian
Stanley Sinclair wrote:
For years I have been hoping for a native db2 solution which
compresses data on BACKUP DATABASE. (Using Windows.) I have heard
that it will happen, but has anyone enough chutzpa to say if it will
happen in my working lifetime (I'm 61 and live dangerously)?

Stan


It was introduced in Fixpack 4. You can now say,

backup database sample to /tmp compress

Restore will automatically uncompress the backup if it was compressed
on backup.
This is documented in the Release Notes for FP4.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2

P: n/a
> Stanley Sinclair wrote:
For years I have been hoping for a native db2 solution which
compresses data on BACKUP DATABASE. (Using Windows.) I have heard
that it will happen, but has anyone enough chutzpa to say if it will
happen in my working lifetime (I'm 61 and live dangerously)?

Stan


It was introduced in Fixpack 4. You can now say,

backup database sample to /tmp compress

Restore will automatically uncompress the backup if it was compressed
on backup.
This is documented in the Release Notes for FP4.

Not yet supported by the Control Center (which can generate and submit
commands) but as mentioned, it does work in FP4.
Nov 12 '05 #3

P: n/a
"Mark A" <ma@switchboard.net> wrote in message news:<Ut*****************@news.uswest.net>...
Stanley Sinclair wrote:
For years I have been hoping for a native db2 solution which
compresses data on BACKUP DATABASE. (Using Windows.) I have heard
that it will happen, but has anyone enough chutzpa to say if it will
happen in my working lifetime (I'm 61 and live dangerously)?

Stan


It was introduced in Fixpack 4. You can now say,

backup database sample to /tmp compress

Restore will automatically uncompress the backup if it was compressed
on backup.
This is documented in the Release Notes for FP4.

Not yet supported by the Control Center (which can generate and submit
commands) but as mentioned, it does work in FP4.


Assuming you specify your own compress library. The manual states
that if you don't it will use DB2's library, but that doesn't always
work:

APAR= IY51590 SER=
LIBDB2COMPR.SO LIBRARY IS NOT INSTALLED WHEN APPLYING FP4 WHICH DOES
NOT
ALLOW THE COMPRESS OPTION TO WORK ON 64BIT INSTANCES

/T

Tomas Hallin
Robert Half International
Pleasanton, CA
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.