PH38890: 4.3 UI00000 AUG 2021 ROLL UP APAR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This Roll Up APAR fixes the following issues:
  
  1) Panel HAA$UIMG: Potential S0C13 ABEND
  2) Admin Task Creator/Name wildcard values not processed
  3) When specifying DISCARD 'Y' on a REORG, the
  SYSPUNCH DD can contain an unnecessary VOLUME
  parameter - as well as a missing SPACE parameter -
  which will result in a JCL error.
  4) When specifying DISCARD 'Y' on a REORG for a DB.TS with XML,
  LOB or CLOB columns, DISCARD keywords can be included in the
  REORG syntax for both the base tablespace as well as the
  associated auxiliary spaces - which will cause a RC=8 and a DB2
  error message such as the one shown below:
  
  
  DSNU076I [...] DSNURFIT - KEYWORD=DISCARD INVALID FOR TABLE WITH
  XML COLUMNS.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: This Roll Up APAR fixes the following   *
  *                      issues:                                 *
  *                                                              *
  *                      1) Panel HAA$UIMG: Potential S0C13      *
  *                         ABEND                                *
  *                      2) Admin Task Creator/Name wildcard     *
  *                         values not processed correctly.      *
  *                      3) When specifying DISCARD 'Y' on a     *
  *                         REORG, the SYSPUNCH DD can contain   *
  *                         an unnecessary VOLUME parameter - as *
  *                         well as a missing SPACE parameter -  *
  *                         which will result in a JCL error.    *
  *                      4) When specifying DISCARD 'Y' on a     *
  *                         REORG for a DB.TS with XML, LOB or   *
  *                         CLOB columns, DISCARD keywords can   *
  *                         be included in the REORG syntax for  *
  *                         both the base tablespace as well as  *
  *                         the associated auxiliary spaces -    *
  *                         which will cause a RC=8 and a DB2    *
  *                         error message such as the one shown  *
  *                         below:                               *
  *                                                              *
  *                           DSNU076I {...} DSNURFIT -          *
  *                           KEYWORD=DISCARD INVALID FOR TABLE  *
  *                           WITH XML COLUMNS.                  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  .
  

Problem conclusion

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:

  UI76952

Modules/Macros

• HAA#SCHD HAA#UTED HAA#XMLC HAA$BMSG HAA$BUTR HAA$STPT HAA$TMPN
  HAACOPYC HAAHPUJ  HAARBLDC HAARBLDW HAAREOIC HAAREORC HAAREORD
  HAAUNLDJ
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R430 PSY UI76952

     UP21/09/01 P F108

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.