SEO

#1 (**permalink**) 02-26-2008, 04:40 PM

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

#2 (**permalink**) 02-26-2008, 04:40 PM

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! =-----

#3 (**permalink**) 02-26-2008, 04:40 PM

> 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.

#4 (**permalink**) 02-26-2008, 04:41 PM

"Mark A" <ma@switchboard.net> wrote in message news:<Ut0Pb.1342$Mu.49430@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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode