473,324 Members | 2,196 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

backup compress in viper 2


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
4 2125
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
"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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Tim Gahnstrom | last post by:
rdiff-backup is aperently written in Python and when I run it in a special way I get some funy Python errors. Does anyone know if linux python have some issues with working with fat32 or usb...
6
by: Joachim Klassen | last post by:
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...
3
by: Stanley Sinclair | last post by:
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...
9
by: Stanley Sinclair | last post by:
I just brought a new small server online. It has two disks in RAID1 (mirrored) for the operating system and logs and DB2 DBMS. DB2 data on a separate RAID 5EE array on four disks. (IBM ServeRAID...
2
by: Jean-Marc Blaise | last post by:
Hi, I get a SQL2009C when using the 'compress' option for backup, but the util_heap_sz does not blow if I do not use the 'compress' option. What is the overhead induced by the compress option in...
4
by: uthuras | last post by:
Hi all, I have DB2ESE version 8.1 with FP 4 on AIX 5.2. My database used to be 1.1TB. When the DB size is 1.1TB, it takes approximately 7 hours to backup the entire database (online backup). The...
2
by: Joachim Klassen | last post by:
Hi all, Env: DB2 ESE/DPF 8.1.6 64 Bit on AIX 5.2.0 we recently had problems with an offline backup of a database with 5 partitions that fails with SQL0956 - Not enough storage in dbheap....
9
by: george.zhang | last post by:
Hi, Friends, I have oneconcern on my stragety on db2 backup. My db2 databse backup imdage with size 100G. On the server, it has two directories which I can use to backup: directory a with 30 G...
5
by: zgh1970 | last post by:
Hi, Friends, default DB2 compression library. I am wondering if this option will have any new restriction on RESTORE in the following. (Can I used that backup imsage for restore at the...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.