This report identifies files with the most active records. These tables are the likely candidates for data purging/archiving, query optimization, or access path analysis (to eliminate unused logical files since they are most expensive to maintain for these files).
     
     
LIBRARY FILE MEMBER RECORDS
TPCH      LINEITEM  LINEITEM  6,001,226
ISTEST    DSPFDMBR  DSPFDMBR  1,123,710
ISTEMP    DSPFD1    DSPFD     248,864
ISTEMP    DSPFD     DSPFD     247,833
TPCH      CUSTOMER  CUSTOMER  149,935
ISTEST    TMP       TMP       128,942
ISTEMP    DSPFDMBR  DSPFDMBR  62,669
ISTEMP    DSPFD4    DSPFD     4,640
ISTEMP    DSPFD3    DSPFD     4,583
ISTEMP    TEMP      TEMP      2,143
ISTEST    DSPOBJAUT XCEAUTBA  353
ISDEV     DSPFDMBR  DSPFDMBR  330
ISTEST    DSPFDACC  XCEACCBA  213
ISTEST    IDX_DATE  IDX_DATE  181
ISTEMP    IDX_M00004 IDX_M00004 169
TPCH      QSQLSRC   CRTTBLS   154
ISTEMP    IDX_MBRTIM IDX_MBRTIM 151
ISTEMP    DSPFD5    DSPFD     140
ISTEMP    IDX_J00001 IDX_J00001 139
ISTEMP    DSPFD6    DSPFD     132