IBM Support

II07451: CHANGES TO DB2 DIAGNOSIS GUIDE & REFERENCE LY27-9603-00 THAT DID NOT MAKE VERSION 3 GA PUBS - CONTINUED IN II07863.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • INTRAN

Error description

  • Do NOT CLOSE this APAR.  Leave it in INTRAN status.
    =====================================================
    This apar documents changes to the DB2 Diagnosis Guide &
    Reference LY27-9603-00 which did not make V3 GA pubs.
    Continued in Info. APAR II07863.
    5740XYR00 R310 DB2
    ==========================================================
    Book Title: Diagnosis Guide and Reference
    Page Number: title page
    Change Description:
    
    Replace the CD-ROM number listed as LK27-1233 with
    CD-ROM LK2T-1233.
    ============================================================
    Version 3 Book Title: DIAGNOSIS REFERENCE
    Pages: 131
    Change Description:
             8-byte CSECT maintenance level
    This line will replace:
             8-byte number of the last APAR applied to this CSECT
    ==============================================================
    Version 3 Book Title: DB2 Diagnosis Guide and Reference
    Pages: 148, 149
    Change Description:
    
    Add a description of the information that the VRA keys
    identify in Tables 15 through 22.
    (VRARK17 and VRARK18 will be added when the description
    is available)
    -----------------------------------------------------------
    Code       Key       Hex   Data Item
               Name      Value
    
    00E50013   VRAHEX    38    Hexadecimal information
    
               VRARRP    10    Hexadecimal recovery routine
                               parameter list, with 24 byte
                               maximum length if FRR.
                               Can be preceded by a VRAPLI or
                               VRACBM ID.
    -----------------------------------------------------------
    Trace      VRAPLI    20    EBCDIC data that identifies the
    Super                      parameter list in the next data
                               field.
               VRAPL     21    Variable length data that
                               contains the trace parameter
                               list.
    -----------------------------------------------------------
    00E60887   VRARRC    06    Abend reason code
    00E60888   VRARFP    20    Internal instrumentation
                               mapping macro
    ==============================================================
    Book Title: Diagnosis Guide and Reference
    Page Number: 264
    Change Description:
    
    In table 50 'Number of pages covered by segmented space
    map page', replace the seventh line describing the 4KB page:
      '28   165   4616  DA5'
    with:
      '28   165   4620  DA5'.
    ==============================================================
    Book Title: Diagnosis Guide and Reference
    Page Number: 266
    Change Description:
    
    Add a new section 'Zero Pages' in the first column preceding
    'Data Pages':
    
    Zero Pages
    
    A zero page is an empty page without a header or trailer.
    It can be a 4KB page full of zeroes or a 4KB page full of
    zeroes with only the parady bits on.
    
    Zero pages can exist in a segmented table space.
    For example, consider a segmented table space that contains
    four pages. The first page is full.  The second, third
    and fourth pages are zero pages.  When DB2 formats the table
    space, the entire segment is formatted with three of the
    four pages not in use.
    ===============================================================
    Version 3 Book Title: Diagnosis Guide and Reference
    Pages: 271
    Change Description:
    At the end of the second column under the heading
    'With a Clustering Index' change:
     "...the candidate page is the page containing the row
      with the next lower key or the last duplicate key of the
      key of the new row."
    to:
     "...the candidate page is the page containing the row
      with either the next lower key, the next higher key, or
      the last duplicate key of the key of the new row."
    ===============================================================
    Book Title: Diagnosis Guide and Reference
    Page Number: 311
    Change Description:
    
    In table 56 'File Page Set Header Page', replace the
    description of the HPGPGSZ bit in location 2E:
      'Page size in multiples of 4KB.  '=1' for 4K page size.
       '=8' for 32KB page size'
    with:
      'Page size in multiples of 4.  X'1000' for 4K page size.
       X'8000' for 32K page size'.
    ===============================================================
    Book Title: Diagnosis Guide and Reference
    Page Number: 312
    Change Description:
    
    In table 56 'File Page Set Header Page', remove the
    HPGUIDX bit from location 44.
    ================================================================
    Book Title: Diagnosis Guide and Reference
    Page Number: 316
    Change Description:
    
    In table 60 'Record/Overflow Record', replace the description
    of the third PGSFLAGS bit 'Yes, if entry points to overflow
    record' with 'Yes, if entry is an overflow record.'
    ================================================================
    DB2 Diagnosis Guide and Reference, LY27-9603-00
    Page 316 under Record/Overflow Record (Table 60)
    Should read:
    
     00     PGSFLAGS    Bit(8)      Flag byte.
    |                   ..1. ....   Yes, if overflow record.
                        .... .1..   Yes, if record is compressed.
                        .... ..1.   Record is possibly uncommitted
    ==============================================================
    Book Title: DB2 Diagnosis Guide and Reference
    Page 316  (Table 61)
    
    Change Description:
    In table 61, for PGSFLAGS, replace this line:
    
     SIZE      DESCRIPTION
     ----      -----------
     X'40'     Pointer record.
    
    with these lines:
    
    |00     PGSFLAGS    Bit(8)      Flag byte.
    |                   .1.. ....   Yes, if pointer record.
    |                   .... ..1.   Record is possibly uncommitted
    ==============================================================
    Version 3 Book Title:  Diagnosis Guide and Reference
    Pages: 317
    Change Description:
    
    Change the description of PGLZDMLL:
    
    LOC   NAME      SIZE       DESCRIPTION
    ---   ----      ----       -----------
    
     10   PGLZDMLL  FIXED(16)  Length (in bytes) of dictionary
                               entries on this page.
    
    Add 2 entries to the end of the table:
    
    FF8   PGLZDMI2  CHAR(6)    Integrity check field 2.
    
    FFE   PGLZDMFF  CHAR(2)    Standard page tail.
    ================================================================
    Book Title: Diagnosis Guide and Reference
    Page Number: 381
    Change Description:
    
    Add the following two missing entries to the DSNDB01 cross-
    reference table.
    
    OBID
    dec (hex)    Corresponding Object
    
    132(84)      Index page set DSNSPT01
    
    148(94)      Index page set DSNSPT02
    ==============================================================
    Book Title: Diagnosis Guide and Reference
    Page Number: 443
    Change Description:
    
    Replace the hex offsets in the CSUB control block listed as
    zeros with the following offsets:
    
    Hex       Field
    Offset    Name
    
    000000    CSUBSAVE
    000048    CSUBID
    00004F    CSUBCHAP
    000050    CSUBSON
    000058    CSUBSON2
    000060    CSUBXSAC
    000064    CSUBATOK
    00007A    CSUBRSOF
    00007B    CSUBSONS
    000083    CSUBPIID
    00008B    CSUBSN2S
    000094    CSUBPSBL
    000098    CSUBTCB
    00009C    CSUBRDYQ
    0000A0    CSUBFRB
    0000C0    CSUBCTYP
    0000C1    CSUBTTYP
    0000C2    CSUBCRNO
    0000C4    CSUBTRAN
    0000C8    CSUBCFIL
    0000D0    *
    0000D0    CSUBWORK
    00010C    CSUBNTID
    00011C    CSUBERRS
    000150    CSUBSRV
    000150    *
    0000D6    CSUBRELP
    
    Cross Reference by Field Name
    
    CSUBATOK        64
    CSUBCFIL        C8
    CSUBCHAP        4F
    CSUBCRNO        C2
    CSUBCTYP        C0
    CSUBERRS       11C
    CSUBFRB         A0
    CSUBID          48
    CSUBNTID       10C
    CSUBPIID         0
    CSUBPSBL        94
    CSUBRDYQ        9C
    CSUBRELP        D6
    CSUBRSOF        7A
    CSUBSAVE         0
    CSUBSN2S        8B
    CSUBSON         50
    CSUBSONS        7B
    CSUBSON2        58
    CSUBSRV        150
    CSUBTCB         98
    CSUBTRAN        C4
    CSUBTTYP         0
    CSUBWORK         0
    CSUBXSAC        60
    =============================================================
    
    This information is continued in Info. APAR II07863.
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    II07451

  • Reported component name

    PB LIB INFO ITE

  • Reported component ID

    INFOPBLIB

  • Reported release

    001

  • Status

    INTRAN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    1993-12-29

  • Closed date

  • Last modified date

    1998-06-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 December 2020