Db2 for z/OS & Db2ZAI

Db2 for z/OS and its ecosystem

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 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


  • 3.  RE: DB2 utility DSN1PRNT output field explanation

    Posted 2 days ago

    All the fields were described in early Diagnosis Guide and Reference.  Does you site have any copies of the old manuals, CDs, or PDFs?  It was in Section 7, Physical Formats and Diagrams.  

    PGCOMB is a flag byte.  It's a bit pattern and indicates if the page was read with i/o error, modified by REPAIR, copied by DSN1COPY, etc. 
    PGLOGRBA is log RBA of the last page update. 
    PGLOGID id of log system. 
    PGNUMBER  page number in page set.  

    If the information is printed by DSN1PRNT, the information should be readily available.  Have you opened a ticket with IBM? 



    ------------------------------
    Linda Hagedorn
    ------------------------------



  • 4.  RE: DB2 utility DSN1PRNT output field explanation

    Posted 2 days ago

    You need an IMB iD.  And then:

    Db2 12 https://www.ibm.com/support/pages/node/6413411

    Db2 13 https://www.ibm.com/support/pages/node/6574111

    and then you need to request access.  



    ------------------------------
    James Campbell
    ------------------------------



  • 5.  RE: DB2 utility DSN1PRNT output field explanation

    Posted 2 days ago

    Because at some time someone might want the Db2 Vnext manual, I found those links from "    

    Db2 Diagnosis Guide and Reference: ...     The remaining information is available only for customers who have an Db2 13 for z/OS license associated with their IBMid. See

    https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=documentation-pdf-format-manuals



    ------------------------------
    James Campbell
    ------------------------------