IBM Support

PI92357: REMOVE OBSOLETE ZPARMS IN DB2 12 FOR Z/OS. ALSO FIX PANELS HAVING TITLES TRUNCATED IN DB2 11 AND DB2 12

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Various zparms such as SQWIDSC are obsolete in Db2 12 and they
    will be removed.  This apar also fixes the Db2 11 and Db2 12
    migration/install panels that have title truncated.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of the Db2 11 for z/OS and                         *
    * Db2 12 for z/OS installation CLIST.                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The following errors occur:                                  *
    * (1) Db2 12 only:                                             *
    * (a) Db2 subsystem parameters that                            *
    * were removed from Db2 12 are                                 *
    * still found in Db2-supplied                                  *
    * sample z/OSMF variable input                                 *
    * files and z/OSMF workflow                                    *
    * definition files.                                            *
    * (b) The install CLIST ignores the                            *
    * library name specified in                                    *
    * HIGH LEVEL ASSEMBLER LIB on                                  *
    * panel DSNTIPU when editing                                   *
    * jobs that execute the z/OS                                   *
    * High Level Assembler                                         *
    * (PGM=ASMA90)                                                 *
    * (2) Db2 12 and Db2 11:                                       *
    * Install CLIST panels may display                             *
    * any one of the following anomalies                           *
    * in the title line:                                           *
    * o Title overlaid by panel ID                                 *
    * o Truncated title prefix                                     *
    * (Db2 12 ACTIVATE mode only)                                  *
    * o Missing title prefix                                       *
    * o Duplicate title (Db2 11 only)                              *
    * o Extra hyphen between title                                 *
    * prefix and title                                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available.                         *
    ****************************************************************
    The following errors occur:
    (1) Db2 12 only:
    (a) The following Db2 subsystem parameters were removed
    from Db2 12:
    o DSN6ARVP.ALCUNIT
    o DSN6SPRM.CACHE_DEP_TRACK_STOR_LIM
    o DSN6SPRM.CACHEDYN_FREELOCAL
    o DSN6ARVP.CATALOG
    o DSN6SPRM.CHECK_SETCHKP
    o DSN6SPRM.CONTSTOR
    o DSN6SPRM.DB2SORT
    o DSN6SPRM.EDMPOOL
    o DSN6SPRM.INDEX_IO_PARALLELISM
    o DSN6SPRM.LEMAX
    o DSN6SYSP.LOBVALA
    o DSN6SYSP.LOBVALS
    o DSN6SPRM.MINSTOR
    o DSN6SPRM.REORG_IGNORE_FREESPACE
    o DSN6SPRM.RRF
    o DSN6SPRM.SQWIDSC
    o DSN6SPRM.UTSORTAL
    o DSN6SYSP.XMLVALA
    o DSN6SYSP.XMLVALS
    
    However, the z/OSMF variables associated with these
    obsolete Db2 subsystem parameters are still found
    in the Db2-supplied DSNTIV* sample z/OSMF variable
    input files and in the Db2-supplied DSNTIW* sample
    z/OSMF workflow definition files. Although these
    extraneous entries do not affect installation or
    migration of Db2, they are potentially misleading and
    need to be cleaned up.
    
    Table 1 below lists the z/OSMF variables associated
    with the obsolete subsystem parameters.
    
    Table 1.
    -------------------------------------------------
    |  Db2 Subsystem Parameter       |   z/OSMF     |
    |                                |   Variable   |
    -------------------------------------------------
    |  ALCUNIT                       |  ARCHUNIT    |
    |  CACHE_DEP_TRACK_STOR_LIM      |  CDTSL       |
    |  CACHEDYN_FREELOCAL            |  CACHFRE     |
    |  CATALOG (in DSN6ARVP)         |  ARCHCTLG    |
    |  CHECK_SETCHKP                 |  CHKSCHKP    |
    |  CONTSTOR                      |  CONTSTOR    |
    |  DB2SORT                       |  DB2SORT     |
    |  EDMPOOL                       |  EDMPOOL     |
    |  INDEX_IO_PARALLELISM          |  IXIOPARA    |
    |  LEMAX                         |  LEMAX       |
    |  LOBVALA                       |  LOBVALA     |
    |  LOBVALS                       |  LOBVALS     |
    |  MINSTOR                       |  MINSTOR     |
    |  REORG_IGNORE_FREESPACE        |  RIFS        |
    |  RRF                           |  RRF         |
    |  SQWIDSC                       |  SQWIDSC     |
    |  UTSORTAL                      |  UTSORTAL    |
    |  XMLVALA                       |  XMLVALA     |
    |  XMLVALS                       |  XMLVALS     |
    -------------------------------------------------
    
    (b) The following problems are found in the panel title
    of these Db2 install CLIST panels:
    o Title overlaid by panel ID:
    - DSNTIPMA, DSNTIPMD, DSNTIPME, DSNTIPMF, DSNTIPMI
    DSNTIPMJ, DSNTIPMN, DSNTIPMS, DSNTIPMT, DSNTIPM4
    o Truncated title prefix (ACTIVATE mode):
    - DSNTIPC, DSNTIPM1, DSNTIPT
    o Missing title prefix:
    - DSNTIPM3, DSNTIPM4, DSNTIPM5, DSNTIP00
    o Extra hyphen between title prefix and title:
    - DSNTIPO4, DSNTIP7, DSNTIP71, DSNTIP72
    o Code cleanup:
    - DSNTIPA2, DSNTIPR1
    (c) Panel DSNTIPU: Install CLIST ignores the library
    name specified in HIGH LEVEL ASSEMBLER LIB because
    the ZVAR for this field is IASMLIB instead of ASMLIB.
    (2) Db2 11 only:
    The following problems are found in the panel header of
    these Db2 install CLIST panels:
    o Title overlaid by panel ID:
    - DSNTILMA, DSNTILMD, DSNTILME, DSNTILMI, DSNTILMN
    DSNTILMS, DSNTILM4
    o Missing title prefix:
    - DSNTILM3, DSNTILM4, DSNTILM5
    o Extra hyphen between title prefix and title:
    - DSNTIL7, DSNTIL71, DSNTIP7, DSNTIP71
    o Duplicate title:
    - DSNTIL41, DSNTIP41
    o Code cleanup:
    - DSNTILA2, DSNTILR1, DSNTIPA2, DSNTIPR1
    

Problem conclusion

  • The following CLIST, panels, sample z/OSMF variable input
    files, sample z/OSMF workflow definition files have been
    modified to correct the problems described in the
    Problem Description section:
    
    o Db2 12 only:
      o Db2 installation CLIST:
        - DSNTINST
    
      o Install CLIST panels:
        - DSNTIPA2, DSNTIPC,  DSNTIPMA, DSNTIPMD, DSNTIPME,
          DSNTIPMF, DSNTIPMI, DSNTIPMJ, DSNTIPMN, DSNTIPMS,
          DSNTIPMT, DSNTIPM1, DSNTIPM3, DSNTIPM4, DSNTIPM5,
          DSNTIPO4, DSNTIPR1, DSNTIPT,  DSNTIPU,  DSNTIP00,
          DSNTIP7,  DSNTIP71, DSNTIP72
    
      o Sample z/OSMF variable input files:
        - DSNTIVA*, DSNTIVI*, DSNTIVM*
    
      o Sample z/OSMF workflow definition files:
        - DSNTIWA*, DSNTIWI*, DSNTIWM*
    
    o Db2 11 only:
      o Install CLIST panels:
        - DSNTILA2, DSNTILMA, DSNTILMD, DSNTILME, DSNTILMI,
          DSNTILMN, DSNTILMS, DSNTILM3, DSNTILM4, DSNTILM5,
          DSNTILR1, DSNTIL41, DSNTIL7,  DSNTIL71, DSNTIPA2,
          DSNTIPR1, DSNTIP41, DSNTIP7,  DSNTIP71
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI92357

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-01-11

  • Closed date

    2018-04-02

  • Last modified date

    2018-05-01

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

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

    UI54932 UI54933

Modules/Macros

  • DSNTIPM1 DSNTILM5 DSNTIPM3 DSNTIPM4 DSNTIPM5 DSNTILA2 DSNTILMA
    DSNTIPA2 DSNTILMD DSNTIPMA DSNTILME DSNTIPMD DSNTIPME DSNTILMI
    DSNTIPMF DSNTILR1 DSNTIPMI DSNTIVMD DSNTIPMJ DSNTILMN DSNTIVIA
    DSNTIPR1 DSNTIPMN DSNTIVIE DSNTILMS DSNTIPMS DSNTIPMT DSNTIVMN
    DSNTIVAF DSNTIVIN DSNTIVMS DSNTIP7  DSNTIL7  DSNTIPO4 DSNTIPC
    DSNTIL71 DSNTIP71 DSNTIP72 DSNTIPT  DSNTIPU  DSNTIWMD DSNTINST
    DSNTIWIA DSNTIWIE DSNTIWMN DSNTIWIN DSNTIWAF DSNTIWMS DSNTIL41
    DSNTIP41 DSNTIP00 DSNTILM3 DSNTILM4
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI54932

       UP18/04/18 P F804

  • RB10 PSY UI54933

       UP18/04/18 P F804

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":"12.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":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 May 2018