PI11201: DB2 ADMINISTRATION TOOL FOR Z/OS BATCH JOB FUNCTION MAY GENERATE ADB0351E RC08 ONCODE=520 AFTER APPLYING TH 14/02/06 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After applying the PTF for APAR PM90389, the DB2 Administration
  Tool for z/OS's Batch Job function may generate message
  ADB0351E ONCODE=520 ( ONCODE 520 ) if the DELTACHG file has a
  "ADMIN ALTER TABLESPACE" with a "CREATOR" statement.
    ADB0351E  Module : ADB2CID detected an ONCODE condition
                       520 At APPLY_MASKS
                       Name  . . : hlq.TGTVF
    ADB0006E ADBCCM - Error(s) found.  Please review output.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the Change                  *
  *                 Management Batch (CM Batch) function         *
  *                 to import a change with mask and the         *
  *                 change has the statement:                    *
  *                                                              *
  *                 'ADMIN ALTER TABLESPACE                      *
  *                 >db_name<.>ts_name< CREATOR                  *
  *                 >creator<' or 'ADMIN ALTER                   *
  *                 INDEX >index_schema<.>index_name<            *
  *                 OWNER >owner<'.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool for z/OS CM     *
  *                      Batch job generates an ADB0351E RC08    *
  *                      ONCODE=520 error when using mask to     *
  *                      import the delta change.  If the        *
  *                      DELTACHG file has a "ADMIN ALTER        *
  *                      TABLESPACE" with a "CREATOR"            *
  *                      statement, the error below is           *
  *                      observed:                               *
  *                                                              *
  *                      ADB0351E  Module : ADB2CID detected     *
  *                      an ONCODE condition 520                 *
  *                      At APPLY_MASKS.                         *
  *                      Name  . . : XXX.XXXXX.XXXX              *
  *                                                              *
  *                                                              *
  *                      IBM0421S  ONCODE=520  The               *
  *                      SUBSCRIPTRANGE condition                *
  *                      was raised.                             *
  *                      From entry point APPLY_MASKS            *
  *                      at statement 3319 at compile            *
  *                      unit offset +XXXXXXXX                   *
  *                      at entry                                *
  *                      offset +XXXXXXXX at                     *
  *                      address XXXXXXXX.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Importing a delta change which has a statement change with the
  statement 'ADMIN ALTER TABLESPACE >db_name<.>ts_name< CREATOR
  >creator<' with mask caused an Oncode=520 error.
  

Problem conclusion

• Problem has been resolved.
  

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:

Modules/Macros

• ADB2CID  ADB2CMF  ADB2MSQ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI16207

     UP14/03/22 P F403 {

• RA20 PSY UI16208

     UP14/03/22 P F403 {

• RB10 PSY UI16209

     UP14/03/22 P F403 {

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.