PH12677: DOE FAILED TO PROVISION AN INSTANCE FOR JAVA STORED PROCEDURE WHICH HAS JAR OBJECT STORED IN THE DB2 CATALOG

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Register an application with the Java SP STPDGM.GETEMP, the
  stored procedure has external name defined with
  JARSCHEMA.JAR_ID:class.method style.
  When DOE provision a new instance of the application, it
  got -204 on missing <target schema>.GETEMP:getEmp.x_getEmp
  in creating the procedure.
  Db2 requires the JAR object to be stored in the SYSJAROBJECTS
  catalog table first before the ddl is issued.
  DOE users can NOT install the jar before provisioning the
  instance, because the JARSCHEMA (same as the schema of the SP)
  is dynamically generated by DOE at provision time, thus it is
  unknown to the users until then.
  DOE needs to handle the JAR object in provision/deprovision
  use-case.
  Here is the ddl for the Java SP in our environment, look at the
  "EXTERNAL NAME" field.
  --#SET TERMINATOR `
  SET CURRENT SQLID='SYSADM'`
  CREATE PROCEDURE STPDGM.GETEMP
  (IN DEPTNAME CHAR(4) FOR SBCS DATA CCSID EBCDIC )
  DYNAMIC RESULT SETS 1
  EXTERNAL NAME 'STPDGM.GETEMP:getEmp.x_getEmp'
  LANGUAGE JAVA PARAMETER CCSID EBCDIC PARAMETER STYLE JAVA
  NOT DETERMINISTIC FENCED CALLED ON NULL INPUT MODIFIES SQL DATA
  NO PACKAGE PATH NO DBINFO COLLID DSNJDBC
  WLM ENVIRONMENT WLMJAVA ASUTIME NO LIMIT STAY RESIDENT NO
  PROGRAM TYPE SUB SECURITY DB2 INHERIT SPECIAL REGISTERS
  STOP AFTER SYSTEM DEFAULT FAILURES COMMIT ON RETURN NO
  DISALLOW DEBUG MODE `
  COMMIT`
  --#SET TERMINATOR ;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Fixed: failing to provision an instance *
  *                      containing a Java stored procedure with *
  *                      a JAR object in the Db2 catalog         *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  Multiple issues resolved.
  

Problem conclusion

• Apply the PTF.
  

Temporary fix

Comments

• ×**** PE20/01/29 FIX IN ERROR. SEE APAR PH21588  FOR DESCRIPTION
  ×**** PE20/01/29 FIX IN ERROR. SEE APAR PH21588  FOR DESCRIPTION
  ×**** PE20/01/29 FIX IN ERROR. SEE APAR PH21588  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI66862

Modules/Macros

• ADB2000  ADB27AC  ADB27ACR ADB28MC  ADB2CIX  ADB2CMP  ADB2GDP
  ADB2GEN  ADB2RE   ADB2ZPV  ADB5000  ADB7000  ADB9000  ADBCDCX
  ADBCEXX  ADBCVEZ  ADBRPTL  ADBTEP2  ADBTEPX  ADBUPGRD DOEALA
  DOEALLOC DOEDSCVR DOESAMP  DOESERVE DOEUI    DOEZFS   GOC2DTC
  GOCCCM
  

Fix information

• Fixed component name

  DB2 DEVOPS EXPR

• Fixed component ID

  5698DEX00

Applicable component levels

• R110 PSY UI66862

     UP19/12/18 P F912

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.