PI42942: ++HOLD FOR APAR PI19368'S PTF UI19186 INCORRECTLY IDENTIFIED A N EW ISPF TABLE SADBTLIB(ADBDIORD)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' APAR PI19368's PTF UI19186
  ++ HOLD incorrectly identifies a new ISPF table member ADBDIORD,
  the actual name was ADBIDORD.
  

Local fix

• SADBTLIB(ADBDIORD) should be SADBTLIB(ADBIDORD).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who applied PTF UI19186 and generate    *
  *                 new ISPF table SADBTLIB(ADBIDORD).           *
  ****************************************************************
  * PROBLEM DESCRIPTION: APAR PI19368 / PTF UI19186 ++HOLD       *
  *                      incorrectly documented the name of      *
  *                      the new ISPF table to be                *
  *                      SADBTLIB(ADBDIORD).  The typos in       *
  *                      sample job SADBSAMP(ADBSMORJ) are       *
  *                      also corrected.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  APAR PI19368 / PTF UI19186 incorrectly documented the name of
  the new ISPF table to be SADBTLIB(ADBDIORD).  The typos in
  sample job SADBSAMP(ADBSMORJ) are also corrected.
  

Problem conclusion

• Problem has been resolved.
  The correct name of the new ISPF table should be
  SADBTLIB(ADBIDORD).
  The typos in sample job SADBSAMP(ADBSMORJ) are also corrected.
  
  The ++HOLD for PTF UI19186 incorrectly identifies a new ISPF
  table member ADBDIORD, the actual name was ADBIDORD and should
  have read as follows:
  
  After applying this fix, the user should perform the following
  actions to recreate a sample default clauses ISPF table.  If
  the user does not want to apply default ORDER BY to the
  product, it is not necessary to follow the following steps:
  
  1. If any site default settings has already been defined,
  edit the SADBSAMP library sample member ADBSMORD to reflect
  site default settings.  This step is not necessary when no
  site default is applied.
  2. Delete any existing default ORDER BY clauses ISPF table
  SADBTLIB(ADBIDORD).
  3. Regenerate sample default clauses by running the
  SADBSAMP library sample member ADBSMORJ, which will create
  the default ORDER BY clauses ISPF table SADBTLIB(ADBIDORD).
  

Temporary fix

Comments

APAR Information

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

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

  UI28825

Modules/Macros

•    ADBSMORJ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI28825

     UP15/06/27 P F506

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.