PH35398: INCORRECT UTILITY SYNTAX POSSIBLE WHEN GENERATING REORG TS JOB THAT SPECIFIES DISCARD KEYWORD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When generating the job for a TS REORG utility that specifies
  the DISCARD keyword, the following errors are possible:
  
  1) Setup and utility template DD not being generated correctly
  for DISCARDDDN
  2) When multiple objects are specified for a TS REORG, the
  DISCARD text specified in DISCARD_FROM_TABLE(S)_SQL_TEXT edit
  panel can be generated incorrectly.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When generating the job for a TS REORG  *
  *                      utility that specifies the DISCARD      *
  *                      keyword, the following errors are       *
  *                      possible:                               *
  *                                                              *
  *                      1) Setup and utility template DD not    *
  *                         being generated correctly for        *
  *                         DISCARDDDN                           *
  *                                                              *
  *                      2) When multiple objects are specified  *
  *                         for a TS REORG, the DISCARD text     *
  *                         specified in                         *
  *                         DISCARD_FROM_TABLE(S)_SQL_TEXT edit  *
  *                         panel can be generated incorrectly.  *
  *                                                              *
  ****************************************************************
  * 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:

  UI75589

Modules/Macros

• HAA#EXCS HAA#JPRI HAA$BUTR HAA$CALL HAA$ISQL HAA$TSQL HAA@BULD
  HAAREORC
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R430 PSY UI75589

     UP21/05/28 P F105

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.