SELECT
        DBPARTITIONNUM,
        DATAPARTITIONID,
        INDSCHEMA,
        INDNAME,
        COMPRESS_ATTR,
        INDEX_COMPRESSED,
        INDEX_PARTITIONING,
        INDEX_REQUIRES_REBUILD,
        INDEX_OBJECT_L_SIZE,
        INDEX_OBJECT_P_SIZE,
        RECLAIMABLE_SPACE
      FROM TABLE( SYSPROC.ADMIN_GET_INDEX_INFO('T', 'TTT', 'QQQ') )
      ;
      SELECT 
        DBPARTITIONNUM,  
        TABSCHEMA,
        TABNAME,
        DATA_PARTITION_ID,
        DATA_OBJECT_L_SIZE,
        DATA_OBJECT_P_SIZE, 
        INDEX_OBJECT_L_SIZE,
        INDEX_OBJECT_P_SIZE,
        LONG_OBJECT_L_SIZE,
        LONG_OBJECT_P_SIZE,
        LOB_OBJECT_L_SIZE,
        LOB_OBJECT_P_SIZE,
        XML_OBJECT_L_SIZE,
        XML_OBJECT_P_SIZE,
        DICTIONARY_SIZE,
        RECLAIMABLE_SPACE,
        XML_DICTIONARY_SIZE
      FROM TABLE( SYSPROC.ADMIN_GET_TAB_INFO( 'TTT', 'QQQ' ))
      ORDER BY TABSCHEMA, TABNAME, DBPARTITIONNUM, DATA_PARTITION_ID;