DATA_COMPRESSION_FACTOR table

Edit online

The DATA_COMPRESSION_FACTOR table contains the values used by IBM® i Migrate While Active for estimating compression of objects.

Authorization: None required.

The following table describes the columns in the table. The system name is COMP_FACT. The schema is SYSIBMADM.

Table 1. DATA_COMPRESSION_FACTOR table
Column Name System Column Name Data Type Description
COMPRESSION_TYPE COMP_TYPE VARCHAR(7) The type of compression.
*NO
No compression
*LOW
Low level of compression
*MEDIUM
Medium level of compression
*ZLIB
Compression using hardware acceleration
COMPRESSION_FACTOR COMP_FACT DECIMAL(3,2) The compression factor used for migrating library-based objects that are not part of the operating system.
IFS_COMPRESSION_FACTOR IFS_FACT DECIMAL(3,2) The compression factor used for migrating integrated file system (IFS) objects.
OS_COMPRESSION_FACTOR OS_FACT DECIMAL(3,2) The compression factor used for migrating objects that reside in system libraries. These are libraries that are considered to be part of a system save of the operating system.

Example

  • List the compression factors used for the different types of compression.
    SELECT * FROM SYSIBMADM.DATA_COMPRESSION_FACTOR;