PM83305: ROLL-UP MAINTENANCE FOR DB2 11 EXPLOITATION SUPPORT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR will fix the following issues found during testing of
  DB2 11 exploitation support:
  1) RBALRSN_CONVERSION option should be available on TS Reorg and
     IX Reorg utilities on DB2 11 EN mode.
  
  2) Stored procedure 'HAA.ADMIN_UTL_MONITOR' should still be
     created when warning 'DSNT404I SQLCODE = 440, WARNING:  NO
     PROCEDURE BY THE NAME SYSPROC.ADMIN_UTL_MONITOR HAVING
     COMPATIBLE ARGUMENTS WAS FOUND' is produced.
  
  3) Message 'DSNT404I SQLCODE = 440, WARNING:  NO PROCEDURE BY
     THE NAME SYSPROC.ADMIN_UTL_MONITOR HAVING COMPATIBLE
     ARGUMENTS WAS FOUND' should be treated as a warning and
     remaining SQL should be processed.
  
  4) The Recovery utility sample profile contains invalid
     duplicate    REBUILD INDEX FREQVAL statistics options.
     If the REBUILD INDEX sample profile is included in the
     job profile, when the generated JCL is executed, the
     REBUILD INDEX step fails with RC=8 and error message
     'DSNU094I DSNUGPPK - KEYWORD IS DUPLICATED'
  
  5) On Reallocation utility panel HAA$UREA, options HASHSPACE
     and DATASIZE are unavailable.
  
  6) RBA/LRSN field on the Recover utility panel should have a
     20-digit field on DB2 11 EN mode.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR will fix the following        *
  *                      issues found during testing of          *
  *                      DB2 11 exploitation support:            *
  *                      1. RBALRSN_CONVERSION option should be  *
  *                       available on TS Reorg and IX Reorg     *
  *                       utilities on DB2 11 EN mode.           *
  *                      2. Stored procedure                     *
  *                       'HAA.ADMIN_UTL_MONITOR' should still   *
  *                       be created when warning 'DSNT404I      *
  *                       SQLCODE = 440, WARNING:  NO PROCEDURE  *
  *                       BY THE NAME SYSPROC.ADMIN_UTL_MONITOR  *
  *                       HAVING COMPATIBLE ARGUMENTS WAS        *
  *                       FOUND' is produced.                    *
  *                      3. Message 'DSNT404I SQLCODE = 440,     *
  *                       WARNING:  NO PROCEDURE BY THE NAME     *
  *                       SYSPROC.ADMIN_UTL_MONITOR HAVING       *
  *                       COMPATIBLE ARGUMENTS WAS FOUND'        *
  *                       should be treated as a warning and     *
  *                       remaining SQL should be processed.     *
  *                      4. The Recovery utility sample profile  *
  *                       contains invalid duplicate REBUILD     *
  *                       INDEX FREQVAL statistics options.      *
  *                       If the REBUILD INDEX sample profile    *
  *                       is included in the job profile, when   *
  *                       the generated JCL is executed, the     *
  *                       REBUILD INDEX step fails with RC=8     *
  *                       and error message 'DSNU094I DSNUGPPK   *
  *                       - KEYWORD IS DUPLICATED'               *
  *                      5. On Reallocation utility panel        *
  *                       HAA$UREA, options HASHSPACE and        *
  *                       DATASIZE are unavailable.              *
  *                      6. RBA/LRSN field on the Recover        *
  *                       utility panel should have a 20-digit   *
  *                       field on DB2 11 EN mode.               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK92137

Modules/Macros

• HAA$BUTX HAA$IMPF HAA$PITS HAA$URBO HAA$URCL
  HAA$URCV HAA$UREA HAA$UREO HAA$UREX HAA#BSQL HAA#PITS HAA#SCPY
  HAA#UPRI HAAHUREO HAAHVREO HAARBLDC HAAREOIC HAAREORC HAASAMPP
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R410 PSY UK92137

     UP13/03/09 P F303

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.