PH18225: NEW STORED PROCEDURE SYSPROC.ADMIN_INFO_IFCID

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New stored procedure SYSPROC.ADMIN_INFO_IFCID
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This PTF ships a new Db2-supplied                            *
  * stored  procedure                                            *
  * SYSPROC.ADMIN_INFO_IFCID.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  The SYSPROC.ADMIN_INFO_IFCID stored procedure returns the
  IFCID record requested.
  

Problem conclusion

Temporary fix

Comments

• The following changes are implemented in support of the new
  stored procedure SYSPROC.ADMIN_INFO_IFCID:
  1. Sample jobs
     a. DSNTIJRT (Install and configure Db2-supplied routines)
        The following statement for creating and configuring
        the new stored procedure SYSPROC.ADMIN_INFO_IFCID is
        added:
           SYSPROC.ADMIN_INFO_IFCID
             WLMENV(DSNWLM_GENERAL)
             GRANTTO(PUBLIC)
     b. DSNTESR (DDL and BIND statements used by job DSNTIJRT)
        The following DDL and BIND statements are added:
        -- DROP TABLE SYSIBM.IFIREC;
        -- DROP PROCEDURE SYSPROC.ADMIN_INFO_IFCID RESTRICT;
         CREATE GLOBAL TEMPORARY TABLE SYSIBM.IFIREC
           ( ROWNUM              INTEGER        NOT NULL
           , IFIREC              VARCHAR(32000) FOR BIT DATA
                                                NOT NULL
           )
           CCSID EBCDIC;
         CREATE PROCEDURE SYSPROC.ADMIN_INFO_IFCID
           ( IN    IFCID               INTEGER
           , IN    DB2_MEMBER          VARCHAR(8)
           , OUT   RETURN_CODE         INTEGER
           , OUT   MSG                 VARCHAR(1331)
           )
           PARAMETER CCSID EBCDIC
           EXTERNAL NAME DSNADMIF
           RESULT SETS 1
           LANGUAGE C
           PARAMETER STYLE GENERAL WITH NULLS
           COLLID DSNADM
           WLM ENVIRONMENT DSNWLM_GENERAL
           ASUTIME NO LIMIT
           STAY RESIDENT NO
           PROGRAM TYPE MAIN
           SECURITY DB2
           RUN OPTIONS 'TRAP(OFF),STACK(,,ANY,)'
           COMMIT ON RETURN NO ;
        -- BIND PACKAGE(DSNADM) MEMBER(DSNADMIF) +
        --       ACTION(REPLACE) ISOLATION(CS) +
        --       ENCODING(EBCDIC) +
        --       RELEASE(COMMIT) +
        --       LIBRARY('DSN!!0.SDSNDBRM')
        --
         GRANT ALL ON TABLE SYSIBM.IFIREC
           TO PUBLIC;
         GRANT EXECUTE ON PROCEDURE SYSPROC.ADMIN_INFO_IFCID
           TO PUBLIC;
         GRANT EXECUTE ON PACKAGE DSNADM.DSNADMIF
           TO PUBLIC;
  2. Installation panels
     a. DSNTIPRA (DB2 Routine Selection Panel) and
        DSNTIPRL (DB2 administration routines)
        New fields are added to these panels to store
        information about the new stored procedure
        SYSPROC.ADMIN_INFO_IFCID.
  3. CLIST input members
     a. DSNTIDXA and DSNTIDXB
        The following entries to store values entered into new
        fields on installation panel DSNTIPRL are added:
  RTL44ACL CHAR  M  NONE        NONE          PUBLIC
  RTL44PKO CHAR  M  NONE        NONE          NULL
  RTL44WLM CHAR  M  NONE        NONE          DSNWLM_GENERAL
     b. DSNTIDXC
        The following entries to store values entered into new
        fields on installation panel DSNTIPRL are added:
  RTL44ACL CHAR  M  NONE        NONE          PUBLIC
  RTL44PKO CHAR  M  NONE        NONE          NULL
  RTL44WLM CHAR  M  NONE        NONE          DY00WLM_GENERAL
  4. Db2 install CLIST is updated to support the new stored
     procedure.
  5. Db2-supplied z/OSMF files
     a. Variable input files DSNTIVIN, DSNTIVMN, and DSNTIVMS
        The following new z/OSMF variables are added:
        o RTL44ACL - ADMIN_INFO_IFCID GRANT EXECUTE
        o RTL44PKO - ADMIN_INFO_IFCID PACKAGE OWNER
        o RTL44WLM - ADMIN_INFO_IFCID WLM ENV NAME
     b. Workflow definition files DSNTIWIN, DSNTIWMN, and
        DSNTIWMS
        Variable definitions for the following new z/OSMF
        variables are added:
        o RTL44ACL - ADMIN_INFO_IFCID GRANT EXECUTE
        o RTL44PKO - ADMIN_INFO_IFCID PACKAGE OWNER
        o RTL44WLM - ADMIN_INFO_IFCID WLM ENV NAME
        i.   DSNTIWIN:
             o Step s00SETVP (Set Variables)
               - Add <setVariable> for RTL44WLM
             o Step step20b (DSNTIJRT)
               - Add <variableValue> for RTL44ACL, RTL44PKO,
                 and RTL44WLM
        ii.  DSNTIWMN:
             o Step step30 (DSNTIJRT)
               - Add <variableValue> for RTL44ACL, RTL44PKO,
                 and RTL44WLM
        iii. DSNTIWMS:
             o Step step23b (DSNTIJRT)
               - Add <variableValue> for RTL44ACL, RTL44PKO,
                 and RTL44WLM
  6. Sample Db2 software service template which rapidly
     provisions from scratch one or multiple standalone Db2
     subsystems, in IBM Cloud Provisioning and Management for
     z/OS (CP&M), is updated.
  More information about the stored procedure
  SYSPROC.ADMIN_INFO_IFCID is available in the IBM Knowledge
  Center:  https://www.ibm.com/support/knowledgecenter/
  SSEPEK_12.0.0/sqlref/src/tpc/db2z_sp_admininfoifcid.html
  

APAR Information

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

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

  UI66948

Modules/Macros

• DSNTIDXA DSNTINST DSNTIDXC DSNTIDXB DSNTINSV DSN@DMIF DSNTESR
  DSN@XAZP DSN@RVFY DSNTXAZP DSN@RIN  DSNTIPRL DSNTIJRT DSNTINS1
  DSNADMIF DSNTINM1 DSNTIVMN DSNTPNDX DSNTIWMN DSNTIVIN DSNTIWMS
  DSNTIVMS DSNTIWIN DSNTRVFY DSNTIPRA DSNTRIN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI66948

     UP19/12/21 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.