PH65208: ROLL UP APAR FOR INTERNAL FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This PTF addresses the following issues:
  1) Load Accelerator Utility can duplicate and/or omit objects
     from HAA@ULAT jobstep and from the resulting SYSOUT report
  2) TS REORG can result in INCLUDE statements appearing outside
     of a LAT jobstep and from the resulting SYSOUT report
     LISTDEF due to a Syntax Issue with Partition Range
  3) DAJ$MAIN: "Db2 Func Level" should be "Db2 Code Level"
  4) Job build for RECOVER of Db2 CATLG & DIR can result in "ALL"
     keyword in LISTDEF for DSNDB01 and DSNDB06 objects.
  5) TCz CLIST #2 Contains ",=" Instead of "="
  6) Improve a potentially long-running job build when a large
     volume of objects is specified while using a high number
     of catalog lookup parallel tasks.
  7) Batch Build SYSOUT: The nbr of Accepted/Rejected Object
     counts displayed can be incorrect when COPY NO Indexes
     are included.
  8) REORG: If OBJ profile contains Advanced SQL to select
     specific PARTS for TS and IX, the indexes to be REORGED can
     be duplicated.
  9) TS REORG: Potential syntax error in PARTLEVEL keyord when a
     TS containing a NPSI has > 50 parts being grouped
  10)Job Build Can Result in DSNT408I SQLCODE = -924 Db2
     Connection Internal Error
  11)Automatically turn on SYSPUNCH and SYSDISC DDs when
     REORG-ing a TS with a pending ALTER COLUMN SET command
  
  12)Eliminate a potential -407 SQLCODE when attempting to
     create a performance window
  13)Eliminate a potential S106 ABEND due to a memory leak during
     job build(s) of multiple LOB objects
  14)Eliminate a potential memory leak when requesting estimates
     to be provided for REORG TS job builds
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: This PTF addressed the following        *
  *                      issues:                                 *
  *                                                              *
  *                      01) Load Accelerator Utility can        *
  *                          duplicate and/or omit objects from  *
  *                          HAA@ULAT jobstep and from the       *
  *                          resulting SYSOUT report             *
  *                                                              *
  *                      02) TS REORG can result in INCLUDE      *
  *                          statements appearing outside of a   *
  *                          LISTDEF due to a Syntax Issue with  *
  *                          Partition Range Formatting          *
  *                                                              *
  *                      03) DAJ$MAIN: "Db2 Func Level" should   *
  *                          be "Db2 Code Level"                 *
  *                                                              *
  *                      04) Job build for RECOVER of Db2 CATLG  *
  *                          & DIR can result in "ALL" keyword   *
  *                          in LISTDEF for DSNDB01 and DSNDB06  *
  *                          objects.                            *
  *                                                              *
  *                      05) TCz CLIST #2 Contains ",=" Instead  *
  *                          of "not equal" (X'5F7E')            *
  *                                                              *
  *                      06) Implement a process improvement to  *
  *                          reduce a potentially long-running   *
  *                          job build when a large volume of    *
  *                          objects is specified while using a  *
  *                          high number of catalog lookup       *
  *                          parallel tasks.                     *
  *                                                              *
  *                      07) Batch Build SYSOUT: The nbr of      *
  *                          Accepted/Rejected Object counts     *
  *                          displayed can be incorrect when     *
  *                          COPY NO Indexes are included        *
  *                                                              *
  *                      08) REORG: If OBJ profile contains      *
  *                          Advanced SQL to select specific     *
  *                          PARTS for TS and IX, the indexes    *
  *                          to be REORGED can be duplicated     *
  *                                                              *
  *                      09) TS REORG: Potential syntax error    *
  *                          in PARTLEVEL keyord when a TS       *
  *                          containing a NPSI has > 50 parts    *
  *                          being grouped                       *
  *                                                              *
  *                      10) Job Build Can Result in DSNT408I    *
  *                          SQLCODE = -924 Db2 Connection       *
  *                          Internal Error                      *
  *                                                              *
  *                      11) Automatically turn on SYSPUNCH and  *
  *                          SYSDISC DDs when REORG-ing a TS     *
  *                          with a pending ALTER COLUMN SET     *
  *                          command                             *
  *                                                              *
  *                      12) Eliminate a potential -407 SQLCODE  *
  *                          when attempting to create a         *
  *                          performance window                  *
  *                                                              *
  *                      13) Eliminate a potential S106 ABEND    *
  *                          due to a memory leak during job     *
  *                          build(s) of multiple LOB objects    *
  *                                                              *
  *                      14) Eliminate a potential memory leak   *
  *                          when requesting estimates           *
  *                          to be provided for REORG TS job     *
  *                          builds                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Install 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:

  UO02350

Modules/Macros

• DAJ#AUTO DAJ#EIDA DAJ#IX12 DAJ#LOB8 DAJ#OBEX DAJ#UTED DAJ#UTOB
  DAJ$BMSG DAJ$BULJ DAJ$BUTL DAJ$BUTR DAJ$EXCP DAJ$MAIN DAJ$SV26
  DAJ$UESC DAJ@EMCQ DAJ@POBJ DAJV11C
  

Fix information

• Fixed component name

  AUTOMATION EXPE

• Fixed component ID

  5698DAE00

Applicable component levels

• R110 PSY UO02350

     UP25/03/11 P F503

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.