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

DB2 V8.1.4 and backup compression

P: n/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 ?

TIA
Joachim
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/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
Nov 12 '05 #2

P: n/a
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


Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

P: n/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.
Nov 12 '05 #5

P: n/a
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

Nov 12 '05 #6

P: n/a
<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

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.