DB2® Version 8: The Official Guide

Compression Example

To get a feel for how compression works, you can work through the example in this section.

First create a table using the following DDL:

						create table compression (groupid int not null, greeting varchar(200) not null, message
 varchar(200) compress system default, txid int not null) value compression
					

Now create a table that is the same as the COMPRESSION table you just created, but without the compression feature turned on by entering the following command:

						create table nocompression like compression
					

TIP

When creating a table using the LIKE function, the new table does not inherit the compression attributes of the original ...