473,805 Members | 2,119 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Data compression i DB2

Hi,

I have IBM DB2 UDB v7 installed on W2k.
Is it possible to compress tables with data.
I searched Internet and haven't found any solution.

Thanks in advance,
Michal Sierakowski
Nov 12 '05 #1
2 1909
Micha³ Sierakowski wrote:
Hi,

I have IBM DB2 UDB v7 installed on W2k.
Is it possible to compress tables with data.
I searched Internet and haven't found any solution.

Thanks in advance,
Michal Sierakowski


Not in V7 - btw V7 goes out of support in a few weeks (I believe at end
of August).

Db2 V8.2 will have table compression available - it should be released
this year.

On Windows you may consider CFS (Compressed File System) as an alternative.
Pozdrowienia,

Jan M. Nelken
Nov 12 '05 #2
Micha³ Sierakowski wrote:
I have IBM DB2 UDB v7 installed on W2k.
Is it possible to compress tables with data.
I searched Internet and haven't found any solution.


V7 is going out of support in a few weeks (end of August). V8 is
current one (A new version V8.2 a.k.a Stinger should be released this
year).
V8 gradually introduces several enhancements in compression of data
stored on disk, namely null and default compression, value compression.
Future enhancements may include table compression as well.
Viable alternative to be considered on Windows OS is to use CFS
(Compressed File System).
Pozdrowienia,

Jan M. Nelken
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
2487
by: Anurag | last post by:
Hi, I am told that Oracle has this "data compression" feature that allows you to store online data ina compressed format. This is different from archived data - you compress only that data which is infrequently accessed but is still available in the online database. I am interested in finding out an equivalent feature in DB2 UDB on LUW. If there exists one, how should I go about implementing this? If there is an alternative strategy to...
1
3724
by: rawCoder | last post by:
Hi, Please correct me if I am wrong but according to my assumption .NET does not provide any out of the box solution for compression of the data over socket or a network stream. If so, what are the best alternatives for a high speed text compression library which is ideally ubiquitous and free :-D Thank you in advance,
2
2548
by: Stefan L | last post by:
Hi Everybody, does anyone know if there is a good compression library available for the .NET-Framework? I want to compress a byte-Array (chunk from a file) for transmission over the internet to a client. On the client side I want to decompress the data and use it. Any recommendations for this sort of problem?
6
1477
by: Danny Tuppeny | last post by:
Hi all, I'm writing a news client (mainly to test out CAB & ClickOnce!), and trying to decide on what to use for the storage of messages etc.. SQL Express seems like overkill (and is a hefty download for a < 1MB app!). Also, since there could be thousands of messages (potentially binary), I'm not sure that serializing my classes to disk would perform at all well. What would other people use for a small app like this? And why?
2
2493
by: TerryStone | last post by:
Thanks to anyone who reads this. Below is some C# that compresses an array of bytes, and then decompresses, and compares the original data with the new. Firstly, the length of the decompressed data is shorter than the original. So some loss of data has occured. But the content up until the early truncation matches. So am I flushing correctly? This error only occurs for particular combinations of bytes in the original buffer.
8
9352
by: Frank Swarbrick | last post by:
My DBA says that a column defined, for instance, as DECIMAL(11,2) and containing a value of 1.00 takes up no more space on the database disk than a column defined as DECIMAL(7,2) and containing a value of 1.00. I am honestly having a hard time believing this, but I don't know where I can find the answer. Help? Thanks, Frank
10
2209
by: oktayarslan | last post by:
Hi all; I have a problem when inserting an element to a vector. All I want is reading some data from a file and putting them into a vector. But the program is crashing after pushing a data which has string value. I really do not understand why push_back() function is trying to remove previously inserted data. Thanks for any help
5
2950
by: DR | last post by:
Why is its substantialy slower to load 50GB of gzipped file (20GB gzipped file) then loading 50GB unzipped data? im using System.IO.Compression.GZipStream and its not maxing out the cpu while loading the gzip data! Im using the default buffer of the stream that i open on the 20GB gzipped file and pass it into the GZipStream ctor. then System.IO.Compression.GZipStream takes an hour! when just loading 50GB file of data takes a few minutes!
0
1272
by: ruthruth | last post by:
Wished to know in detail abt the below 1-what are the various compression strategies designed specifically for XML data.? 2- comparison between AXECHOP AND TREECHOP techniques to other XML compression schemes with respect to compression ratio and compression time in detail. 3-It is said that "XML's verbose nature tends to increase the size of a data file by as much as ten-fold" what is the reason for that ? what is this verbose...
0
9718
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9596
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10363
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10107
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6876
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5678
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4327
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3846
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3008
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.