PI22235: DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT SET PATH CORRECTLY IN ADBMCMA JOB TEMPLATE WHICH RESULTS IN SQLCODEN440 IN JOB RUN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS does not SET PATH correctly
  in ADBMCMA job template which results in SQLCODEN440 in job run
  

Local fix

• manually add
  SET PATH = CURRENT PATH, "schemaname";
  in order to get it to work as a workaround
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and IBM Tools Customizer for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Change Management database          *
  *                      template ADBMCMA 'Upgrade CM database   *
  *                      to current' job is missing the          *
  *                      following statement:                    *
  *                                                              *
  *                      SET PATH = CURRENT PATH, "&CMOWN";      *
  *                                                              *
  *                      Without it, an SQLCODE=-20100           *
  *                      SQLCODEN20100 can occur because         *
  *                      the procedure ADBCRSU 'Multi-target     *
  *                      status change stored procedure'         *
  *                      was not in the CURRENT PATH:            *
  *                                                              *
  *                      SQLERROR ON   CREATE                    *
  *                      COMMAND, EXECUTE   FUNCTION             *
  *                      RESULT OF SQL STATEMENT:                *
  *                      DSNT408I SQLCODE = -20100,              *
  *                      ERROR:  AN ERROR OCCURRED               *
  *                      WHEN BINDING A TRIGGERED SQL            *
  *                      STATEMENT.  INFORMATION                 *
  *                      RETURNED: SECTION                       *
  *                      NUMBER : 2 SQLCODE -440,                *
  *                      SQLSTATE 42884, AND MESSAGE             *
  *                      TOKENS PROCEDURE,ADBCRSU                *
  *                      DSNT418I SQLSTATE   = 56059             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The Change Management database template ADBMCMA 'Upgrade CM
  database to current' job is missing the following statement:
  
  SET PATH = CURRENT PATH, "&CMOWN";
  
  Without it, an SQLCODE=-20100 / SQLCODEN20100 can occur
  because the procedure ADBCRSU was not in the CURRENT PATH.
  

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:

  UI20550

Modules/Macros

•    ADBCHANG ADBMCMA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI20550

     UP14/08/20 P F408

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.