Db2 for z/OS & Db2ZAI

 View Only
Expand all | Collapse all

DB2 utility DSN1PRNT output field explanation

  • 1.  DB2 utility DSN1PRNT output field explanation

    Posted Thu December 16, 2021 03:23 AM

    Can there any book to look up about the DSN1PRNT output about the header page or system page field name ? Or can anyone give an explanation about them ?

    for example:

    PAGE: # 00000000 -----------------------------------------------------------------------------------

    HEADER PAGE: PGCOMB='10'X PGBIGRBA='00DAC4A6507FF6006400'X PGNUM='00000000'X PGFLAGS='38'X

    HPGOBID='01090043'X HPGHPREF='000000B4'X HPGCATRL='00'X HPGREL='D7'X HPGZLD='00'X

    HPGCATV='00'X HPGTORBA='000000000000'X HPGTSTMP='20190131135916454505'X

    HPGSSNM='DBP1' HPGFOID='0042'X HPGPGSZ='1000'X HPGSGSZ='0020'X HPGPARTN='0001'X

    HPGZ3PNO='000000'X HPGZNUMP='00'X HPGTBLC='0001'X HPGROID='0044'X

    HPGZ4PNO='00000000'X HPGMAXL='00B6'X HPGNUMCO='0004'X HPGFLAGS='010A'X

    HPGFLAGS2='00'X HPGFLAGS3='80'X HPGCONTM='20211216101951294360'X

    HPGSGNAM='DSN8G110' HPGVCATN='DSNDB1P ' HPGRBRBA='000000000000'X

    HPGLEVEL='000000000000'X HPGPLEVL='000000000000'X HPGCLRSN='000000000000'X

    HPGSCCSI='3344'X HPGDCCSI='1345'X HPGMCCSI='056C'X HPGDSSZ='00400000'X

    HPGFLAG2='00'X HPGEPOCH='0000'X HPGRBLP='000000000000'X

    HPGMASSDELETETIMESTAMP='000000000000'X HPGDNUMB='01'X HPGDNUMC='0100'X

    HPGDFSG='00000001'X HPGDLSG='00000001'X HPGSISP='00000000'X

    HPGBIGTORBA='00000000000000000000'X HPGBIGRBRBA='00DAC4A6963F711F4C00'X

    HPGBIGLEVEL='00DAC4A6963F711F4C00'X HPGBIGPLEVL='00DAC4A5D94BFAFC5600'X

    HPGBIGCLRSN='00DAC4A5778955AF0200'X HPGBIGRBLP='00000000000000000000'X

    HPGBIGMASSDELETETIMESTAMP='00000000000000000000'X FOEND='52'X

    DVI HASH BUCKET: HPGDBKT#='01'X HPG1BEYE='4E'X

    HPGDCOLL#='0100'X HPG1OBID='0044'X HPG1V='00'X HPG1RID='0000000201'X

    SI HASH BUCKET: HPGDBKT#='01'X HPGS1BEYE='E2'X HPGS1OBI='0044'X HPGS1FSG='00000002'X

    HPGS1CSG='00000002'X HPGS1LSG='00000002'X





    #Db2forz/OS
    #Support
    #SupportMigration


  • 2.  RE: DB2 utility DSN1PRNT output field explanation

    Posted Mon December 27, 2021 08:09 AM

    currently, I only found some explaination in admin guide:

    1. HPGOBID:1). The first two bytes of the 4-byte field HPGOBID in the header page contain the DBID for the database. 2). The last two bytes of field HPGOBID in the header page contain the PSID for the table space.
    2. SEGOBID: Field SEGOBID in the space map page for the table space contains the OBIDs for each table in the table space.
    3. HPGROID: For universal (UTS), partitioned (non-UTS), or LOB table spaces, the HPGROID field of the header page contains the OBID for the single table in the table space.

    can anyone give some official explaination about the others ?





    #Db2forz/OS
    #Support
    #SupportMigration