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