IBM Support

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

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 LY27960300 which did not make V3 GA pubs.
    Continuation of Info. APAR II07451.
    5740XYR00 R310 DB2
    ================================================================
    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."
    ================================================================
    Version 3 Book Title: DB2 Diagnosis Guide and Reference
    Pages: 329, 330
    Change Description:
    
    Remove the two SYSUTIL fields at location 06 and 0A.
    Revise the field locations for all remaining fields.
    
    LOC   NAME
    ---   ----
    06    USUUID
    16    USUJOBNM
    1E    USUAUID
    26    USURDATE
    2A    USUREL
    2D    USUIRQD
    2E    *
    36    USUUTNAM
    3E    USUPHASE
    46    USUNDONE
    4A    USUSTATU
    4B    USUTREQ
    4C    USUFORCE
    4D    USURLOK
    4E    USUCMPOK
    4F    *
    52    USUPOS
    56    USUCKSUM
    5A    *
    62    USUPSID
    64    USUPSID
    66    USUPSDD
    68    USUDSNU
    6A    *
    6C    USUDBNAM
    74    USUSPNAM
    7C    *
    88    USUUDA
    11E   USUUSTRL
    120   USUUSTRT
    
    Add three SYSUTILX fields following PGSFLAGS and revise the
    remaining field locations.
    
    LOC   NAME
    ---   ----
    01    PGSLTH   CHAR(2)  Length of record, including
                            6-byte header
    03    PGSOBD   CHAR(2)  OBID (X'0051')
    05    PGSID    CHAR(1)  ID map entry that points to this
                            record
    06    UTILID
    16    SEQNO
    18    CHECKPOINT
    ================================================================
    Version 3 Book Title: Diagnosis Guide and Reference
    Pages: 536
    Change Description:
    
    Change the following 3 offsets listed under SPRM:
    
    Offset  Field
            Name
    
     174    SPRMABN
     175    *
     178    SPRMIFS
    
    to these offsets:
    
    Offset  Field
            Name
    
     174    SPRMIFS
     178    SPRMABN
     179    *
    
    Make the same corrections under the Cross Reference section.
    ================================================================
    Book Title: Diagnosis Guide and Reference
    Page Number: 572-574
    Change Description:
    
    Replace the hex offsets in the WAX control block listed as
    zeros with the following offsets:
    
    Hex       Field
    Offset    Name
    
    000000    WAX
    000000    WAXID
    000002    WAXLEN
    000004    WAXNAME
    000008    WAXSQL1
    00000C    WAXSQL2
    000010    WAXDLI
    000014    WAXPRHT
    000018    WAXLIPR
    00001C    WAXS00
    000020    WAXS01
    000024    WAXS14
    000028    WAXEEVP
    00002C    WAXEEVT
    000030    WAXCF
    000031    WAXDF
    000032    WAXSQ
    000034    WAXSSQ
    000036    WAXDSQ
    000038    WAXIMSP
    000038    WAXIMP
    000039    *
    00003C    WAXABEND
    000040    WAXECB
    000044    WAXSREL
    000044    *
    000048    *
    00004C    *
    000050    *
    000054    WAXSR1
    000058    WAXSADR
    00005C    WAXDREL
    00005C    *
    000060    *
    000064    *
    000068    *
    00006C    WAXDR1
    000070    WAXDADR
    000074    WAXI
    000074    WAXISSN
    000078    WAXRIDRO
    00007A    *
    00007C    WAXRT
    00007C    WAXIMS
    00007C    WAXIMSID
    000084    WAXRTA
    00008C    WAXSRTA
    000094    WAXIESMT
    00009C    WAXIRTT
    0000A4    WAXETYPE
    0000A5    WAXIERR
    0000A6    WAXICMD
    0000A7    *
    0000A8    WAXILIT
    0000B0    *
    0000B0    WAXPLAN
    0000B8    WAXPROG
    0000C0    WAXRCPGM
    0000C8    WAXIE
    0000C8    WAXPROGA
    0000CC    WAXAESMT
    0000D0    WAXWAL
    0000D4    WAXWALL
    0000D6    WAXWAUL
    0000D8    WAXWAU
    0000DC    WAXS1
    0000E0    WAXS2
    0000E4    WAXS3
    0000E8    WAXS4
    0000EC    WAXS5
    0000F0    WAXS6
    0000F4    WAXS7
    0000F8    WAXS8
    0000FC    WAXTBE
    000100    WAXTCE
    000104    WAXTEN
    000108    WAXTRACE
    000234    WAXTREND
    000240    *
    000240    WAXESTAA
    000244    WAXDCBOA
    000248    WAXDCBIA
    00024C    WAXESGM
    000250    WAXESRC
    000252    WAXEACNT
    000254    *
    000254    *
    000270    *
    000288    *
    000360    WAXPRGLD
    000361    *
    000364    WAXPCC50
    00036C    WAXPRADR
    000370    *
    000378    WAXVAR
    000378    WAXEND
    
    Cross Reference by Field Name
    
    WAXABEND        3C
    WAXAESMT        CC
    WAXCF           30
    WAXDADR         70
    WAXDCBIA       248
    WAXDCBIO       278
    WAXDCBOA       244
    WAXDF           31
    WAXDLI          10
    WAXDREL         5C
    WAXDR1          6C
    WAXDSQ          36
    WAXEACNT       252
    WAXECB          40
    WAXEEVP         28
    WAXEEVT         2C
    WAXEND         378
    WAXESGM        24C
    WAXESRC        250
    WAXESTAA       240
    WAXETYPE        A4
    WAXI            74
    WAXICMD         A6
    WAXID            0
    WAXIDEN        378
    WAXIE           C8
    WAXIERR         A5
    WAXIESMT        94
    WAXILIT         A8
    WAXIMP          38
    WAXIMS          7C
    WAXIMSID        7C
    WAXIMSP         38
    WAXIRTT         9C
    WAXISSN         74
    WAXLEN           2
    WAXLIPR         18
    WAXNAME          4
    WAXPCC50       364
    WAXPLAN         B0
    WAXPRADR       36C
    WAXPRGLD       360
    WAXPRHT         14
    WAXPROG         B8
    WAXPROGA        C8
    WAXRCPGM        C0
    WAXRIDRO        78
    WAXRT           7C
    WAXRTA          84
    WAXSADR         58
    WAXSQ           32
    WAXSQL1          8
    WAXSQL2          C
    WAXSREL         44
    WAXSRTA         8C
    WAXSR1          54
    WAXSSQ          34
    WAXS00          1C
    WAXS01          20
    WAXS1           DC
    WAXS14          24
    WAXS2           E0
    WAXS3           E4
    WAXS4           E8
    WAXS5           EC
    WAXS6           F0
    WAXS7           F4
    WAXS8           F8
    WAXTBE          FC
    WAXTCE         100
    WAXTEN         104
    WAXTRACE       108
    WAXTREND       234
    WAXVAR         378
    WAXWAL          D0
    WAXWALL         D4
    WAXWAU          D8
    WAXWAUL         D6
    ===============================================================
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    II07863

  • 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

    1994-05-06

  • 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