PI29909: SQLCODEN552 AND SQLCODEN553 AUTH SWITCH ENABLED ERRONEOUSLY.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' IVP for CM Batch, template
  ADBCMBIV 'Verify CM Batch JCL procedure' ends with return code
  0 / RC0 however the database was not created.
  Customers may also see SQLCODE -552 / SQLCODEN552 or SQLCODE
  -533 / SQLCODEN553 in the job output.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who apply a change by running an        *
  *                 APPLY job.  The change of the APPLY job      *
  *                 is analyzed and registered using the         *
  *                 Change Management Batch (CM Batch)           *
  *                 interface with authorization switching       *
  *                 ( auth-switching ) option enabled.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The auth-switching function in          *
  *                      ADBTEPA is enabled even though          *
  *                      a user specifies value '<NONE>'         *
  *                      for option 'Authorization Switch        *
  *                      ID' on panel ADB2CEX1 'Run a            *
  *                      Change' indicating the function         *
  *                      should be disabled.  As a result,       *
  *                      DDL statements are executed under       *
  *                      an invalid ID '<NONE>'.  The            *
  *                      execution of DDL statements             *
  *                      are reported as successful              *
  *                      executions in the SDSF output.          *
  *                      However, the executions actually        *
  *                      fail.  A SQLCODE=-553 /                 *
  *                      SQLCODEN553 and SQLCODE=-552 /          *
  *                      SQLCODEN552 are encountered             *
  *                      if 'Log DIAG' is set to 'YES'           *
  *                      on panel ADB2UPA 'Batch Job             *
  *                      Utility Parameters'.                    *
  *                                                              *
  *                      -553 authorization-id SPECIFIED         *
  *                      IS NOT ONE OF THE VALID                 *
  *                      AUTHORIZATION IDS FOR REQUESTED         *
  *                      OPERATION                               *
  *                                                              *
  *                      -552 authorization-id DOES NOT          *
  *                      HAVE THE PRIVILEGE TO PERFORM           *
  *                      OPERATION operation                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The auth-switching function in ADBTEPA is enabled even though
  a user specifies value '<NONE>' for option 'Authorization
  Switch ID' on panel ADB2CEX1 indicating the function should
  be disabled.  As a result, DDL statements are executed under
  an invalid ID '<NONE>'.  The execution of DDL statements are
  are reported as successful executions in the SDSF output.
  However, the executions actually fail.  A SQLCODE=-553 /
  SQLCODEN553 and SQLCODE=-552 / SQLCODEN552 are encountered if
  'Log DIAG' is set to 'YES' on panel ADB2UPA 'Batch Job Utility
  Parameters'.
  

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:

  UI24420 UI24421

Modules/Macros

•    ADB2TEP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI24420

     UP15/01/18 P F501

• RB10 PSY UI24421

     UP15/01/18 P F501

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.