A fix is available
APAR status
Closed as new function.
Error description
SQLJ integration in SYSIBM.SYSPACKAGE.HOSTLANG
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Distributed Data Facility (DDF) users. * **************************************************************** * PROBLEM DESCRIPTION: The HOSTLANG field of the * * SYSIBM.SYSPACKAGE catalog table * * contains the character "4" or a single * * blank for Java application packages. * * This causes confusion because it is * * indistinguishable from C++ and remotely * * bound non-Java packages which contain * * the same value of "4" or a single blank * * in the HOSTLANG field. * **************************************************************** * RECOMMENDATION: * **************************************************************** A method is needed to distinguish Java packages from C++ and remotely bound non-Java packages in order to simplify the maintenance of Java applications.
Problem conclusion
Temporary fix
Comments
This new function APAR sets the HOSTLANG field of SYSIBM.SYSPACKAGE to a value of "J" for Java applications. For objects created by Java applications, the HOST_LANGUAGE field of SYSIBM.SYSENVIRONMENT (environment variables catalog table) will contain a value of "JAVA". In addition to this APAR, this function requires an enhancement to the SQLJ customizer provided with DB2 for Linux UNIX and Windows 11.1.0, and is documented in the URL below. http://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0 /com.ibm.db2.luw.wn.doc/doc/c0051316.html Use one of the following methods to mark packages as originating from Java. 1. For SQLJ applications, the customizer options -genDBRM -hostLangJAVA is used to generate and mark a DBRM as originating from a serialized profile. Binding the resulting DBRM on DB2 will create a package in SYSIBM.SYSPACKAGE with a HOSTLANG field "J". 2. Alternatively for SQLJ, specify -bindoptions "LANGUAGE JAVA" on the SQLJ customize command when remotely binding a serialized profile on DB2. 3. For JDBC applications, use the DB2Binder utility with -bindoptions "LANGUAGE JAVA" to create the common driver packages associated with the IBM Data Server Driver for JDBC and SQLJ.
APAR Information
APAR number
PI67488
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2016-08-11
Closed date
2016-09-30
Last modified date
2016-11-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI41340 010PC2 010PC2
Modules/Macros
DSNHXLTR DSNLXRCM DSNLXRCS DSNLZS00 DSNTBAS DSNTBAS2 DSNXENVR
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI41340
UP16/10/18 P F610
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 November 2016