ADMIN_GET_TAB_COMPRESS_INFO(tabschema, tabname, execmode)
  execmode
      REPORT
           Reports compression information at time table was compressed
      ESTIMATE
           Generates an estimate of new compression information based on current table data.
             • If execmode is empty ('') or NULL, the default value is 'REPORT'.

Example: using execmode ESTIMATE

db2 "select substr(TABNAME, 1, 10) as TAB_NAME,COMPRESS_ATTR,DICT_BUILDER,DICT_BUILD_TIMESTAMP,PAGES_SAVED_PERCENT \
from table( sysproc.admin_get_tab_compress_info('DB2INST1','', 'ESTIMATE')) as t"

TAB_NAME     COMPRESS_ATTR      DICT_BUILDER         DICT_BUILD_TIMESTAMP       PAGES_SAVED_PERCENT
-----------------------    --------------------- ------------------------------ -------------------------- -------------------
ACT                                   N             TABLE FUNCTION                 2009-02-17-10.35.54.000000                  27
ADEFUSR                        N             TABLE FUNCTION                 2009-02-17-10.35.54.000000                  14
CL_SCHED                     N             TABLE FUNCTION                 2009-02-17-10.35.54.000000                  21
CONVERT                       N             TABLE FUNCTION                 2009-02-17-10.35.54.000000                  41
DEPARTMENT               N             TABLE FUNCTION                 2009-02-17-10.35.54.000000                  50
EM2                                  N             TABLE FUNCTION                 2009-02-17-10.36.00.000000                  78
EMPLO                            N             TABLE FUNCTION                 2009-02-17-10.36.06.000000                  78
EMPLOYEE                    Y             TABLE FUNCTION                 2009-02-17-10.36.06.000000                  46
EMPMDC                        N             TABLE FUNCTION                 2009-02-17-10.36.07.000000                  34
EMPPROJACT               N             TABLE FUNCTION                 2009-02-17-10.36.07.000000                  49
EMP_PHOTO                 N             TABLE FUNCTION                 2009-02-17-10.36.07.000000                  55
EMP_RESUME              N             TABLE FUNCTION                 2009-02-17-10.36.07.000000                  57
FACT                                N             NOT BUILT                                                           -                                            0
HORA                              N             TABLE FUNCTION                 2009-02-17-10.36.07.000000                   7
IN_TRAY                          N            TABLE FUNCTION                 2009-02-17-10.36.07.000000                  51

Example: using execmode REPORT

db2 "select substr(TABNAME, 1, 10) as TAB_NAME,COMPRESS_ATTR,DICT_BUILDER,DICT_BUILD_TIMESTAMP,PAGES_SAVED_PERCENT \
from table( sysproc.admin_get_tab_compress_info('DB2INST1','', 'REPORT')) as t"

TAB_NAME                 COMPRESS_ATTR    DICT_BUILDER                   DICT_BUILD_TIMESTAMP       PAGES_SAVED_PERCENT
----------------------------- ---------------------------  ----------------------------------- -------------------------- -------------------
ACT                                     N                                 NOT BUILT                                                           -                                             0
ADEFUSR                          N                                NOT BUILT                                                            -                                             0
CL_SCHED                       N                                NOT BUILT                                                            -                                             0
CONVERT                         N                                NOT BUILT                                                            -                                             0
DEPARTMENT                 N                                NOT BUILT                                                            -                                             0
EM2                                    N                                 NOT BUILT                                                           -                                             0
EMPLO                              N                                NOT BUILT                                                            -                                              0
EMPLOYEE                      Y                                LOAD                                          2009-02-17-10.23.15.000000                   56
EMPMDC                          N                                NOT BUILT                                                             -                                             0
EMPPROJACT                 N                               NOT BUILT                                                              -                                             0
EMP_PHOTO                   N                               NOT BUILT                                                              -                                             0
EMP_RESUME                N                               NOT BUILT                                                              -                                             0
FACT                                  N                               NOT BUILT                                                              -                                             0
HORA                                N                                NOT BUILT                                                              -                                             0
IN_TRAY                           N                               NOT BUILT                                                               -                                             0