PH06733: NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• NEW FUNCTION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of the Db2 12 for z/OS                             *
  * installation CLIST                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The following conditions are reported:                       *
  * 1. Installation job DSNTIJMJ requires                        *
  *    the user to edit it manually after                        *
  *    running the install CLIST.                                *
  * 2. Installation job DSNTIJMW requires                        *
  *    the user to edit the address space                        *
  *    startup JCL procedure for                                 *
  *    DSNWLM_JAVA in a 64-bit JVM                               *
  *    environment.                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  1. Installation job DSNTIJMJ defines and populates an LE
     run-time data set and two Java environment files for
     use by the DB2-supplied Java WLM environment,
     DSNWLM_JAVA. Currently, all the settings specified
     in the LE run-time data set and in the two Java
     environment files are hard-coded and must be manually
     specified by the user before running DSNTIJMJ.
  2. Installation job DSNTIJMW adds the startup procs for the
     Db2-supplied WLM environments to the system proclib.
     Currently, the address space startup JCL procedure for
     DSNWLM_JAVA must be manually configured for it to run
     in a 64-bit JVM environment.
  

Problem conclusion

Temporary fix

Comments

• This APAR enhances the Db2 installation CLIST to support
  the following:
  1. Edits the LE run-time data set and the two Java
     environment files in job DSNTIJMJ with the settings
     specified by the user in a new panel, DSNTIPX1
     (DBS JAVA PROPERTIES).
  2. Configures the address space startup JCL procedure
     for DSNWLM_JAVA in job DSNTIJMW, to enable it to run
     in either a 32-bit or 64-bit JVM environment.
  
  CLIST panel changes:
  ====================
  1. DSNTIPX1 (DB2 JAVA PROPERTIES)
     The entries on this new panel allow a user to specify
     local preferences for configuring JDBC and SQLJ and
     DSNWLMJ_JAVA. This panel appears after DSNTIPX and
     before DSNTIPR1.
  
  2. DSNTIPB  (SELECTION MENU)
     A new option (option 48) DB2 JAVA PROPERTIES is added to
     the selection menu, and the rest of the options are
     renumbered accordingly.
  
  For the new layouts of the panels, search for "DSNTIPX1"
  and "DSNTIPB" in IBM Knowledge Center:
  https://www.ibm.com/support/knowledgecenter/SSEPEK/
  db2z_prodhome.html
  
  DSNTIDXA and DSNTIDXB changes:
  ==============================
  These members contain, respectively, the Db2-supplied
  defaults and the SAP-supplied defaults for installing and
  migrating to Db2 12.  They are the basis of the user's
  DSNTIDxx member that will be generated by the CLIST and
  contain the site-specified settings.
  
  1. The following new entries are added to store the settings
     specified in the new panel DSNTIPX1:
       JAVAHOME ZFSP  G  /usr/lpp/java160/J6.0
       CLASPATH ZFSP  G  /usr/include/java_classes
       LIBPATH  ZFSP  G  /usr/lib/java_runtime
       JCCHOME  ZFSP  G  /usr/lpp/db2c10/jdbc
       JCCSID   CHARR G  $           Z9999999      SYSADM
       DB2BASE  ZFSP  G  /usr/lpp/db2c10/base
       JAVAENV  DSET  G  DSN1210.DSN1WLMJ.JAVAENV
       JAVAENVV ZFSP  G  /usr/lpp/db2c10/base/classes/
                         dsn1envfile.txt
       JVMPROPS ZFSP  G  /usr/lpp/java/properties/dsn1jvmsp
       JVMAMODE NUM   G  32          64            32
       JVMHEAP  CHAR  G  NONE        NONE          DEFAULT
       JVMAPPH  CHAR  G  NONE        NONE          DEFAULT
  
  Db2-supplied sample jobs (SDSNSAMP) changes:
  ============================================
  1. DSNTIJMJ: Creates the environment files for DSNWLM_JAVA
     Two new steps are added:
     a. DSNTIJCV - Executes a new Db2 REXX exec called DSNTJMJX
        to create the directory of the JAVAENVV (Java
        environment variable) file in HFS/zFS if it does not
        exist. The full-path name of the JAVAENVV is passed
        to DSNTJMJX.
     b. DSNTIJCP - Executes a new Db2 REXX exec called DSNTJMJX
        to create the directory of the JVMPROPS (JVM
        properties) file in HFS/zFS if it does not exist. The
        full-path name of the JVMPROPS is passed to DSNTJMJX.
  
  New REXX Program:
  =================
  1. DSNTJMJX
     Job DSNTIJMJ adds 2 job steps that call Db2 REXX exec
     DSNTJMJX, which accepts one mandatory parameter:
     o HFS/zFS full-path name
  
     DSNTJMJX checks if the HFS/zFS file passed to it exists or
     not.
     o If it does not exist, DSNTJMJX checks whether the
       directory where this file is located exists or not.
       o If the directory does not exist, DSNTJMJX creates the
         directory and returns message
           DSNT524I PATH path DOES NOT EXIST AND IS CREATED.
       o Otherwise, DSNTJMJX returns message
           DSNT524I PATH path ALREADY EXISTS. NO ATTEMPT IS
                    MADE TO CREATE DIRECTORY.
     o Otherwise, DSNTJMJX returns RC=12 and message
         DSNT523I FILE ERROR: file ALREADY EXISTS AS A FILE
                  OR DIRECTORY.
  
     At completion, the highest return code encountered by
     DSNTJMJX is also written out:
       *** DSNTJMJX End RC=rc
  
  Message changes:
  ================
  1. The following new messages are added:
     o DSNT523I File error: &MSGTOK.
     o DSNT524I Path &MSGTOK.
     o DSNT525I File already exists
     o DSNT529I Parameter error: &MSGTOK.
  
  For explanations of the new messages, see:
  www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/
  msgs/src/tpc/db2z_dsnt.html
  
  z/OSMF variable input files (DSNTIV*) and
  z/OSMF workflow definition files (DSNTIW*) changes:
  ===================================================
  1. The new z/OSMF variables listed in Table 1 are
     added to the following z/OSMF variable input files:
     - DSNTIVIN (For installing a subsystem or the first member
                 of a data sharing group)
     - DSNTIVMS (For migrating a subsystem or the first member
                 of a data sharing group)
  
     Table 1 also shows which field in panel DSNTIPX1 it is
     associated with.
  
     Table 1.
     --------------------------------------------------
     |   New     |        Panel DSNTIPX1              |
     |  z/OSMF   |------------------------------------|
     | Variable  |  Field   |         Field           |
     |           |  Number  |          Name           |
     |------------------------------------------------|
     | JAVAHOME  |    1     |  Z/OS SDK HOME DIR      |
     | CLASPATH  |    2     |  Z/OS USS JAVA CLASSES  |
     | LIBPATH   |    3     |  Z/OS USS JAVA RUNTIME  |
     | JCCHOME   |    4     |  JDBC/SQLJ ENV VAR DIR  |
     | JCCSID    |    5     |  JDBC/SQLJ INSTALL ID   |
     | DB2BASE   |    6     |  DB2 BASE JAVA DIR      |
     | JAVAENV   |    7     |  JAVA ENV DATA SET      |
     | JAVAENVV  |    8     |  JAVA ENV VAR FILE      |
     | JVMPROPS  |    9     |  JVM PROPERTIES FILE    |
     | JVMAMODE  |   10     |  JVM ADDRESSING MODE    |
     | JVMHEAP   |   11     |  INIT JAVA HEAP SIZE    |
     | JVMAPPH   |   12     |  MAX APPL HEAP SIZE     |
     --------------------------------------------------
  2. A variable definition element is added for each of the
     new z/OSMF variables listed above to the following z/OSMF
     workflow definition files:
     - DSNTIWIN (For installing a subsystem or the first member
                 of a data sharing group)
     - DSNTIWMS (For migrating a subsystem or the first member
                 of a data sharing group)
  3. The new z/OSMF variables are added to z/OSMF workflow
     definition file job steps listed in Table 2:
       Table 2.
       ---------------------------------------
       |  z/OSMF    | Job Step  |  z/OSMF    |
       | WORKFLOW   |           | Variable   |
       | DEFINITION |           |            |
       |   File     |           |            |
       ---------------------------------------
       | DSNTIWIN   | DSNTIJMW  | JAVAENV    |
       |   and      |           | JVMAMODE   |
       | DSNTIWMS   | DSNTIJMJ  | JAVAHOME   |
       |            |           | CLASPATH   |
       |            |           | LIBPATH    |
       |            |           | JCCHOME    |
       |            |           | DB2BASE    |
       |            |           | JAVAENV    |
       |            |           | JAVAENVV   |
       |            |           | JVMPROPS   |
       |            |           | JVMAMODE   |
       |            |           | JVMHEAP    |
       |            |           | JVMAPPH    |
       ---------------------------------------
  
  DSNTXAZP changes:
  =================
  DSNTXAZP, the DSNTIDxx member refresh tool, is modified to
  handle the new parameters described above.
  

APAR Information

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

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

  UI61217

Modules/Macros

• DSNTXAZP DSNTIDXA DSNTIPX1 DSNTIWIN DSNTIDXB DSNTIPB  DSNTINM1
  DSNTJMJX DSN@XAZP DSNTINSV DSNTIVIN DSNTIJMJ DSNT52   DSNTIWMS
  DSNTINS1 DSNTINST DSNTIVMS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI61217

     UP19/02/23 P F902

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.