IBM Support

PH18225: NEW STORED PROCEDURE SYSPROC.ADMIN_INFO_IFCID

A fix is available

Subscribe

You can track all active APARs for this component.

 

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 number

    PH18225

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-10-17

  • Closed date

    2019-12-12

  • Last modified date

    2020-01-03

  • 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.

[{"Business Unit":{"code":"BU050","label":"BU NOT IDENTIFIED"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
03 January 2020