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

backup compress in viper 2

P: n/a

I heard a rumor that compress is only availible in Enterprise Edition
in 9.5, can anyone confirm/reject this rumor?
/Lennart
Nov 15 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Ian
Lennart wrote:
I heard a rumor that compress is only availible in Enterprise Edition
in 9.5, can anyone confirm/reject this rumor?
Backup compression is part of the Storage Optimization Feature. And,
you heard correctly, this feature can only be added to ESE.

This packaging change was made in V9.1 (so it's not new to 9.5). And it
is completely obnoxious.

One thing that I am not sure about is whether you could write your own
compression library and use it without having to license the Storage
Optimization Feature.
Thanks,
Ian Bjorhovde
Nov 15 '07 #2

P: n/a
"Ian" <ia*****@mobileaudio.comwrote in message
news:42*******************@newsfe14.phx...
Backup compression is part of the Storage Optimization Feature. And,
you heard correctly, this feature can only be added to ESE.

This packaging change was made in V9.1 (so it's not new to 9.5). And it
is completely obnoxious.

One thing that I am not sure about is whether you could write your own
compression library and use it without having to license the Storage
Optimization Feature.
Ian Bjorhovde
That is nasty since it makes a DB2 command syntax not backward compatible. A
lot of scripts will no longer work. I doubt that even Enterprise customers
will get the Storage Optimization Feature unless they have a data warehouse.
Nov 15 '07 #3

P: n/a
On Nov 15, 8:24 pm, Ian <ianb...@mobileaudio.comwrote:
Lennart wrote:
I heard a rumor that compress is only availible in Enterprise Edition
in 9.5, can anyone confirm/reject this rumor?

Backup compression is part of the Storage Optimization Feature. And,
you heard correctly, this feature can only be added to ESE.

This packaging change was made in V9.1 (so it's not new to 9.5). And it
is completely obnoxious.
I'm getting confused because it works in my express-c installation at
home:

[db2inst1@53dbd181 ~]$ db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL09012"
with level identifier "01030107".
Informational tokens are "DB2 v9.1.0.2", "special_17369",
"MI00183_17369", and
Fix Pack "2".
Product is installed at "/opt/ibm/db2/V9.1".

[db2inst1@53dbd181 ~]$ db2 backup db sample compress

Backup successful. The timestamp for this backup image is :
20071116054029

Don't know whether it actually compresses anything, but it accepts the
syntax. Do you know whether this will work in 9.5 express-c as
well?
One thing that I am not sure about is whether you could write your own
compression library and use it without having to license the Storage
Optimization Feature.
Another part of my organization is evaluating different DBMS's for a
large project, and the compress thing is a serious drawback for db2.
Since it is the dbms I used the most (and like the best), I was kinda
hoping for good news. Anyhow, I would be great full for any pointers
or direct info regarding compress.
Thanks,

Ian Bjorhovde
Nov 16 '07 #4

P: n/a
On Nov 15, 11:31 pm, "Mark A" <nob...@nowhere.comwrote:
[...]
>
That is nasty since it makes a DB2 command syntax not backward compatible. A
lot of scripts will no longer work. I doubt that even Enterprise customers
will get the Storage Optimization Feature unless they have a data warehouse.
Yup, back in V7 I used to write the backups through a fifo so that I
could zip it . Compress in V8 was a huge relief, but if it is removed
in V9.x it will be an even greater disappointment.

/Lennart

Nov 16 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.