BACKUP DATABASE

[Stanley Sinclair]

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

[Ian]

Re: BACKUP DATABASE

Stanley Sinclair wrote:
[color=blue]
> 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[/color]

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

[Mark A]

Re: BACKUP DATABASE

> Stanley Sinclair wrote:[color=blue]
>[color=green]
> > 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[/color]
>
> 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.
>[/color]
Not yet supported by the Control Center (which can generate and submit
commands) but as mentioned, it does work in FP4.

[Tomas Hallin]

Re: BACKUP DATABASE

"Mark A" <ma@switchboard .net> wrote in message news:<Ut0Pb.134 2$Mu.49430@news .uswest.net>...[color=blue][color=green]
> > Stanley Sinclair wrote:
> >[color=darkred]
> > > 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[/color]
> >
> > 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.
> >[/color]
> Not yet supported by the Control Center (which can generate and submit
> commands) but as mentioned, it does work in FP4.[/color]

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