DB2 V8.1.4 and backup compression

[Joachim Klassen]

Hi all,

DB2 V8 FP4 introduces a COMPRESS feature to the backup command. The
documentation in the relase notes is very short. Any sources to read
more about this new feature ? eg. Is it available with TSM Backup or
only with disk backup ?

TIA
Joachim

[Mark A]

"Joachim Klassen" <Jo*******@email.com> wrote in message
news:b5**************************@posting.google.c om...

Hi all,

DB2 V8 FP4 introduces a COMPRESS feature to the backup command. The
documentation in the relase notes is very short. Any sources to read
more about this new feature ? eg. Is it available with TSM Backup or
only with disk backup ?

TIA
Joachim

One thing I noticed is that the Control Center was not updated to do a
compressed backup.

There is updated documentation of the Command Reference at
http://publib.boulder.ibm.com/infoce...help/index.jsp

[Blair Adamache]

The Control Center support will come in fp7 or fp6.

Mark A wrote:

"Joachim Klassen" <Jo*******@email.com> wrote in message
news:b5**************************@posting.google.c om...

Hi all,

DB2 V8 FP4 introduces a COMPRESS feature to the backup command. The
documentation in the relase notes is very short. Any sources to read
more about this new feature ? eg. Is it available with TSM Backup or
only with disk backup ?

TIA
Joachim

One thing I noticed is that the Control Center was not updated to do a
compressed backup.

There is updated documentation of the Command Reference at
http://publib.boulder.ibm.com/infoce...help/index.jsp

[Joachim Banzhaf]

Hi Joachim,

Mark A wrote:

"Joachim Klassen" <Jo*******@email.com> wrote in message
news:b5**************************@posting.google.c om...

Hi all,

DB2 V8 FP4 introduces a COMPRESS feature to the backup command. The
documentation in the relase notes is very short. Any sources to read
more about this new feature ? eg. Is it available with TSM Backup or
only with disk backup ?

There is updated documentation of the Command Reference at
http://publib.boulder.ibm.com/infoce...help/index.jsp

updated - ok. But it does not mention a db2 backup compress option.
So it's try and error for now - if I only had a TSM box :-(

Greetings

Joachim

[Mark A]

> >> Hi all,

DB2 V8 FP4 introduces a COMPRESS feature to the backup command. The
documentation in the relase notes is very short. Any sources to read
more about this new feature ? eg. Is it available with TSM Backup or
only with disk backup ?

There is updated documentation of the Command Reference at
http://publib.boulder.ibm.com/infoce...help/index.jsp

updated - ok. But it does not mention a db2 backup compress option.
So it's try and error for now - if I only had a TSM box :-(

Greetings

Joachim

1. Go to http://publib.boulder.ibm.com/infoce...help/index.jsp
2. Do a search on compress (upper left of screen)
3. Select the second retrieval (93% Compressed backup)
4. Select BACKUP DATABASE

You will find what you want.

[Joachim Banzhaf]

Mark A wrote:

>> Hi all,
>>
>> DB2 V8 FP4 introduces a COMPRESS feature to the backup command. The
>> documentation in the relase notes is very short. Any sources to read
>> more about this new feature ? eg. Is it available with TSM Backup or
>> only with disk backup ?

> There is updated documentation of the Command Reference at
> http://publib.boulder.ibm.com/infoce...help/index.jsp

updated - ok. But it does not mention a db2 backup compress option.
So it's try and error for now - if I only had a TSM box :-(

Greetings

Joachim

1. Go to http://publib.boulder.ibm.com/infoce...help/index.jsp
2. Do a search on compress (upper left of screen)
3. Select the second retrieval (93% Compressed backup)
4. Select BACKUP DATABASE

You will find what you want.

Thanks for doublechecking!
Sorry, I just did what you said (again) and get this (brought to you by copy
and paste):

100% Komprimierung von Nullen und Standardwerten
41% SYSCAT.COLUMNS catalog view
27% SQL20100 - SQL20199
22% ALTER TABLE statement
13% DB2 UDB Log Records
11% CREATE TABLE statement
10% SQLSTATE-Nachrichten
10% SQL20000 - SQL20099

nothing more. I swear! 8-0

This is cut and paste of the url:
http://publib.boulder.ibm.com/infoce...help/index.jsp

And this from the search box:
compress

As I type, I see I get german results. Maybe that's the problem.
I recheck and get back with results...

Again: thanks.

Joachim Banzhaf

[Joachim Banzhaf]

<posted & mailed>

Joachim Banzhaf wrote:

Mark A wrote:

>> Hi all,
>>
>> DB2 V8 FP4 introduces a COMPRESS feature to the backup command. The
>> documentation in the relase notes is very short. Any sources to read
>> more about this new feature ? eg. Is it available with TSM Backup or
>> only with disk backup ?

> There is updated documentation of the Command Reference at
> http://publib.boulder.ibm.com/infoce...help/index.jsp

updated - ok. But it does not mention a db2 backup compress option.
So it's try and error for now - if I only had a TSM box :-(

Greetings

Joachim

1. Go to http://publib.boulder.ibm.com/infoce...help/index.jsp
2. Do a search on compress (upper left of screen)
3. Select the second retrieval (93% Compressed backup)
4. Select BACKUP DATABASE

You will find what you want.

Thanks for doublechecking!
Sorry, I just did what you said (again) and get this (brought to you by
copy and paste):

100% Komprimierung von Nullen und Standardwerten
41% SYSCAT.COLUMNS catalog view
27% SQL20100 - SQL20199
22% ALTER TABLE statement
13% DB2 UDB Log Records
11% CREATE TABLE statement
10% SQLSTATE-Nachrichten
10% SQL20000 - SQL20099

nothing more. I swear! 8-0

This is cut and paste of the url:
http://publib.boulder.ibm.com/infoce...help/index.jsp

And this from the search box:
compress

As I type, I see I get german results. Maybe that's the problem.
I recheck and get back with results...

Again: thanks.

Joachim Banzhaf

Hi,

Now that looks much better:

100% Compression of nulls and defaults
93% Compressed backup
36% Maintaining your replication environment
....

CU

Joachim Banzhaf