You can use DB2® row compression to save on storage requirement. You must run the DB2 row compression operation against a directory server instance with the instance owner credentials.
DB2 row compression uses a static dictionary-based compression algorithm to compress data by row. DB2 row compression can replace the repeating patterns that span multiple column values within a row with shorter symbol strings. The row compression on a table is applied by reconstructing the compression dictionary and compressing the information to eliminate fragmented data. Data compression reduces space that is required for the directory server, reduces I/O, and improves performance. When you run the idsdbmaint command to compress rows, the following operations are run:
To optimize the database, you can run the idsdbmaint command with the row compression parameter. For example:
idsdbmaint -I instance_name -r