PI58705: DB2 ADMIN TOOL INVALID SET PATH BEFORE CREATE TRIGGER IN ADMIN TOOL SETUP TASK

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Job ADBSETUP ends with error SQLCODE = -440 on CREATE TRIGGER
  ADB_MT_CHANGE_UPDATE, because no valid procedure ADBCRSU is
  found.
  
  Procedure ADBCRSU is created with Schema "ADB". Before the
  "Create Trigger-Statement" the PATH is:
     SET PATH = CURRENT PATH, "&CMOWN";
  Should be:
     SET PATH = CURRENT PATH, "&CMSCH";
  
  Job output shows:
      SET PATH = CURRENT PATH, "DB";.
  SQLWARNING ON SET       COMMAND, EXECUTE   FUNCTION.
    RESULT OF SQL STATEMENT:.
    DSNT404I SQLCODE = 585, WARNING:  THE COLLECTION DB APPEARS
             MORE THAN ONCE WHEN SETTING THE  SPECIAL REGISTER.
  

Local fix

• Change PATH before Create Trigger-Statement to use value of
  &CMSCH.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and the IBM Tools Customizer        *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When specifying a different Owner       *
  *                      and Schema for creating CM              *
  *                      Database objects during the IBM         *
  *                      Tools Customizer for z/OS               *
  *                      customization process, the              *
  *                      CREATE TRIGGER ADB_MT_CHANGE_UPDATE     *
  *                      statement under the category of         *
  *                      creating CM objects results in a        *
  *                      SQLCODE = -20100 / SQLCODEN20100        *
  *                      when submitting job template            *
  *                      ADBSETUP 'Admin Tool Setup              *
  *                      Task'.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When specifying a different Owner and Schema for
  creating CM Database objects during the IBM Tools
  Customizer for z/OS' customization process, the
  CREATE TRIGGER ADB_MT_CHANGE_UPDATE statement under
  the category of creating CM objects results in a
  SQLCODE = -20100 / SQLCODEN20100 when submitting
  job template ADBSETUP 'Admin Tool Setup Task':
  
  ***INPUT STATEMENT:
     CREATE TRIGGER >trigger_name<
  ...
         END ?
  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
  

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:

  UI37873 UI37874

Modules/Macros

•    ADBSETUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI37873

     UP16/05/19 P F605

• RB20 PSY UI37874

     UP16/05/19 P F605

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.