A fix is available
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
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