A fix is available
APAR status
Closed as program error.
Error description
MISCELLANEOUS DB2 11 AND 12 INSTALL FIXES (1) Db2 11 and 12: . In sample job DSNTEJTR, The bind package statement for . DSNTEP2 currently specifies MEMBER(DSNTEP2). It should . specify DSN@EP2L, the Db2-supplied DBRM for DSNTEP2 and . the DSNTEJTR prolog should advertise this for benefit . of customers who prefer to use their own DSNTEP2 DBRM. (2) Db2 12 only: . The PRIMARY QUANTITY field on panel DSNTIPA allows a . maximum entry of 4369 (cylinders) but DSN6ARVP.PRIQTY . is not restricted. Modify DSNTIPA to accept more than . 4369 but display a warning message that an environment . for allocating LARGE or EXTENDED archive log data sets . is required. (3) Db2 12 only: . Job DSNTIJVC terminates because of return code 8 from . any job step JCVCVTxx (REORG). The following messages are . seen: . DSNU1015I nnn hh:mm:ss.nn DSNUGDYN - ERROR ALLOCATING . DATA SET DSN=image-copy-data-set-name . CODE=X'57080000' . DSNU1042I nnn hh:mm:ss.nn DSNUGDYN - START OF IDCAMS . MESSAGES . IKJ56229I DATA SET image-copy-data-set-name . NOT ALLOCATED, CATALOG ERROR+ . IKJ56229I DATA SET NAME CONFLICTS WITH EXISTING DATA SET . NAME OR USER IS NOT AUTHORIZED TO PERFORM THE OPERATION. . DSNU1043I nnn hh:mm:ss.nn DSNUGDYN - END OF IDCAMS . MESSAGES . DSNU012I nnn hh:mm:ss.nn DSNUGBAC - UTILITY EXECUTION . TERMINATED, HIGHEST RETURN CODE=8 (4) Db2 11 and 12: . DSNTIJPC (Db2 11 only) and DSNTIJPM (Db2 12 only) job . step DSNTJU04 fails because the space allocated to the . SYSPRINT DD (SPACE=(TRK,(1,1,1),RLSE) is too small. (5) Db2 11 and 12: . DSNTIJPC (Db2 11 only) and DSNTIJPM (Db2 12 only) job . step DSNTPMQ ends with return code 8 because one or more . of the active log data set names has a trailing blank. (6) Db2 12 only: The Db2 installation CLIST member DSNTINS1 . halts during editing of job DSNTIJMV after writing these . error messages: . EDITING 'prefix.SDSNSAMP(DSNTIJMV)', INSTALL JCL . SET &MVSASEQN = &SUBSTR(1:7,)1 . THIS STATEMENT HAS AN INVALID &SUBSTR RANGE OR EXIT . CODE EXPRESSION
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * - All Db2 12 for z/OS and Db2 11 for * * z/OS users of the following: * * o Installation CLIST * * o Sample job DSNTEJTR * * o Stored procedure * * SYSPROC.ADMIN_UPDATE_SYSPARM * * - All Db2 11 for z/OS users who are * * migrating to Db2 12 for z/OS * **************************************************************** * PROBLEM DESCRIPTION: * * This APAR addresses the following Db2 * * installation, migration, and * * provisioning concerns: * * (1) Db2 11 and 12: * * . o In sample job DSNTEJTR, the * * . BIND PACKAGE statement for * * . DSNTEP2 currently specifies * * . MEMBER(DSNTEP2). It should * * . specify DSN@EP2L, the * * . Db2-supplied DBRM for DSNTEP2. * * . o DSNTIJPC (Db2 11 only) and * * . DSNTIJPM (Db2 12 only) job * * . step DSNTJU04 may fail when * * . the space allocated to the * * . SYSPRINT DD is too small. * * . o DSNTIJPC (Db2 11 only) and * * . DSNTIJPM (Db2 12 only) job * * . step DSNTPMQ ends with return * * . code 8 from a LISTCAT error. * * . o CLIST-generated jobs DSNTIJPC * * . (Db2 11 only) and DSNTIJPM * * . (Db2 12 only) prologs contain * * . undeleted manual tailoring * * . steps, and the strings * * . DSN!!0.SDSNEXIT and !BSDSNAME! * * . are not substituted with their * * . respective values. * * (2) Db2 12 only: * * . o On panel DSNTIPA, the PRIMARY * * . QUANTITY and SECONDARY QTY. * * . fields allow a maximum entry * * . of 4369 (cylinders) but * * . DSN6ARVP.PRIQTY and * * . DSN6ARVP.SECQTY are not * * . restricted. * * . o Job DSNTIJCV terminates because * * . of return code 8 from any job * * . step JCVCVTxx (REORG). The * * . following messages are seen: * * . DSNU1015I nnn hh:mm:ss.nn * * . DSNUGDYN - ERROR ALLOCATING * * . DATA SET DSN=image-copy-dsn * * . CODE=X'57080000' * * . DSNU1042I nnn hh:mm:ss.nn * * . DSNUGDYN - START OF IDCAMS * * . MESSAGES * * . IKJ56229I DATA SET * * . image-copy-dsn NOT * * . ALLOCATED, CATALOG ERROR+ * * . IKJ56229I DATA SET NAME * * . CONFLICTS WITH EXISTING DATA * * . SET NAME OR USER IS NOT * * . AUTHORIZED TO PERFORM THE * * . OPERATION. * * . DSNU1043I nnn hh:mm:ss.nn * * . DSNUGDYN - END OF IDCAMS * * . MESSAGES * * . DSNU012I nnn hh:mm:ss.nn * * . DSNUGBAC - UTILITY EXECUTION * * . TERMINATED, HIGHEST RETURN * * . CODE=8 * * . o Db2 installation CLIST halts * * . during editing of job DSNTIJMV * * . after writing these error * * . messages: * * . EDITING 'prefix.SDSNSAMP * * . (DSNTIJMV)', INSTALL JCL * * . SET &MVSASEQN = &SUBSTR(1:7,)1 * * . THIS STATEMENT HAS AN INVALID * * . &SUBSTR RANGE OR EXIT CODE * * . EXPRESSION * * This APAR also addresses the * * following Db2-supplied stored * * procedure concerns: * * (1) Db2 11 and 12: * * . o SYSPROC.ADMIN_UPDATE_SYSPARM * * . terminates with return * * . code 12 and the following * * . message when the input parameter * * . DB2_MEMBER is specified: * * . DSNA601I DSNADMIZ THE * * . PARAMETER DB2_MEMBER IS NOT * * . VALID. INVALID REASON * * . CODE=1 * * Additional Keywords: * * DB2MIGV12/K * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** This APAR addresses the following Db2 installation, migration, and provisioning concerns: (1) Db2 11 and 12: o In sample job DSNTEJTR, the BIND PACKAGE statement for DSNTEP2 currently specifies MEMBER(DSNTEP2). It should specify DSN@EP2L, the Db2-supplied DBRM for DSNTEP2. o Pre-migration checkout jobs DSNTIJPC (Db2 11 only) and DSNTIJPM (Db2 12 only): o Step DSNTJU04 may fail when the space allocated to the SYSPRINT DD is too small. o Step DSNTPMQ ends with return code 8 when it cannot determine the size of an active log data set because of an error when running LISTCAT or the data set HI-A-RBA cannot be located in the LISTCAT output. o Db2 installation CLIST-generated pre-migration checkout jobs DSNTIJPC (Db2 11 only) and DSNTIJPM (Db2 12 only) prologs contain undeleted manual tailoring steps, and the strings DSN!!0.SDSNEXIT and !BSDSNAME! are not substituted with their respective values. (2) Db2 12 only: o On Db2 installation CLIST panel DSNTIPA, the PRIMARY QUANTITY and SECONDARY QTY. fields allow a maximum entry of 4369 (cylinders) but their corresponding zparms DSN6ARVP.PRIQTY and DSN6ARVP.SECQTY are not restricted. o Job DSNTIJCV terminates because of return code 8 from any job step JCVCVTxx (REORG). The following messages are seen: DSNU1015I nnn hh:mm:ss.nn DSNUGDYN - ERROR ALLOCATING DATA SET DSN=image-copy-data-set-name CODE=X'57080000' DSNU1042I nnn hh:mm:ss.nn DSNUGDYN - START OF IDCAMS MESSAGES IKJ56229I DATA SET image-copy-data-set-name NOT ALLOCATED, CATALOG ERROR+ IKJ56229I DATA SET NAME CONFLICTS WITH EXISTING DATA SET NAME OR USER IS NOT AUTHORIZED TO PERFORM THE OPERATION. DSNU1043I nnn hh:mm:ss.nn DSNUGDYN - END OF IDCAMS MESSAGES DSNU012I nnn hh:mm:ss.nn DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8 This failure is caused by a duplicate COPY data set name. DSNTIJCV has a series of job step pairs of which the first step COPYs one or more table spaces and the second step REORGs them. The REORG step fails because TEMPLATE generates the same data set name as the COPY step. The &TI. (HHMMSS) variable in the TEMPLATE SYSCOPY HLQ.&DB..&SN..&IC..D&JU..T&TI. is not granular enough to guarantee the uniqueness of a data set name. o Db2 installation CLIST halts during editing of job DSNTIJMV after writing these error messages: EDITING 'prefix.SDSNSAMP(DSNTIJMV)', INSTALL JCL SET &MVSASEQN = &SUBSTR(1:7,)1 THIS STATEMENT HAS AN INVALID &SUBSTR RANGE OR EXIT CODE EXPRESSION This APAR also addresses the following Db2-supplied stored procedure concerns: (1) Db2 11 and 12: o SYSPROC.ADMIN_UPDATE_SYSPARM terminates with return code 12 and the following message when the input parameter DB2_MEMBER is specified: DSNA601I DSNADMIZ THE PARAMETER DB2_MEMBER IS NOT VALID. INVALID REASON CODE=1
Problem conclusion
In response, this APAR makes the following modifications: (1) Db2 11 and 12: o In sample job DSNTEJTR, the following changes are implemented: o Job prolog: o Note added indicating the this job binds and frees a package for DSNTEP2 from the Db2-supplied DBRM (DSN@EP2L). o Step DSNTRS01: o DSN@EP2L, the Db2-supplied DBRM for DSNTEP2, is specified in the DSNTEP2 BIND PACKAGE statement, instead of DSNTEP2. o DSN!!0.SDSNSAMP target library, where the DBRM DSN@EP2L is located, is specified in the DBRMLIB DD, instead of DSN!!0.DBRMLIB.DATA. o Step DSNTRS14: o DSN@EP2L, the Db2-supplied DBRM for DSNTEP2, is specified in the DSNTEP2 FREE PACKAGE statement, instead of DSNTEP2. o In pre-migration checkout jobs DSNTIJPC (Db2 11 only) and DSNTIJPM (Db2 12 only), the following changes are implemented: o Space allocated to the SYSPRINT DD in step DSNTJU04 is increased from SPACE=(TRK,(1,1,1),RLSE), to SPACE=(TRK,(25,5,5),RLSE). The job prolog is also updated to instruct the user to check this SPACE allocation before executing the job. o Active log data set names derived from the DSNJU004 output are stripped of any trailing blanks before a LISTCAT is performed on the active log data set. o Step DSNTPMQ no longer ends with return code 8 when it cannot determine the size of an active log data set because of an error when running LISTCAT or the data set HI-A-RBA cannot be located in the LISTCAT output. Currently, REPORT24 lists only active log data sets greater than 4 GB in size. This report is enhanced to also list any active log data set on which LISTCAT was not able to complete successfully, or when the HI-A-RBA setting of the active log data set was not found in the LISTCAT output. A new report column LISTCAT_RESULT is added to display the LISTCAT return code. If an active log data set is greater than 4 GB in size, the LISTCAT_RESULT column will have the value "RC=0, Greater than 4GB". o When editing jobs DSNTIJPC (Db2 11 only) and DSNTIJPM (Db2 12 only), the Db2 installation CLIST is modified to delete all the manual tailoring steps in the job prolog and substitute the strings DSN!!0.SDSNEXIT and !BSDSNAME! with their respective values. o Stored procedure SYSPROC.ADMIN_UPDATE_SYSPARM is modified to call SYSPROC.ADMIN_INFO_SYSPARM with a valid DB2_MEMBER parameter. (2) Db2 12 only: o Db2 installation CLIST panel DSNTIPA is modified to allow fields PRIMARY QUANTITY and SECONDARY QTY. to accept more than 4369 (cylinders), up to 999999. When the value specified for PRIMARY QUANTITY or SECONDARY QTY. exceeds 4369, a new warning message (DSNT580I) is displayed indicating that an environment for allocating LARGE or EXTENDED-FORMAT archive log data sets is required. o To address the duplicate COPY data set allocated by the TEMPLATE SYSCOPY utility statement in job DSNTIJCV, the Db2 TEMPLATE utility expression for allocating image copy data sets created by Db2 installation jobs is changed from: DSNC!!0.&DB..&SN..&IC..D&JU..T&TI. to: DSNC!!0.&DB..&SN..&IC.&JU..&UQ. As a result of this change, all occurrences of the original image copy TEMPLATE expression in the following SDSNSAMP files are modified to reflect the new image copy TEMPLATE expression: o DSNTIDXA - parameter ICDSTPLT: from: ICDSTPLT TPLT G DSNCAT.&DB..&SN..&IC..D&JU..T&TI. to: ICDSTPLT TPLT G DSNCAT.&DB..&SN..&IC.&JU..&UQ. o DSNTIDXB - parameter ICDSTPLT: from: ICDSTPLT TPLT G DSNCAT.&DB..&SN..&IC..D&JU..T&TI. to: ICDSTPLT TPLT G DSNCAT.&DB..&SN..&IC.&JU..&UQ. o DSNTIDXC - parameter ICDSTPLT from: ICDSTPLT TPLT G DY00CP1.&DB..&SN..&IC..D&JU..T&TI. to: ICDSTPLT TPLT G DY00CP1.&DB..&SN..&IC.&JU..&UQ. o DSNTIJIC - TEMPLATE SYSCOPY DSN from: DSNC!!0.&DB..&SN..&IC..D&JU..T&TI. to: DSNC!!0.&DB..&SN..&IC.&JU..&UQ. o DSNTIJCV - TEMPLATE SYSCOPY DSN from: DSNC!!0.&DB..&SN..&IC..D&JU..T&TI. to: DSNC!!0.&DB..&SN..&IC.&JU..&UQ. o DSNTDJIC - from: TEMPLATE: HLQ.&DB..&SN..&IC..D&JU..T&TI to: TEMPLATE: HLQ.&DB..&SN..&IC.&JU..&UQ. and from: DELETE ${AGICHLQ}.*.*.*.*.* MASK to: DELETE ${AGICHLQ}.*.*.*.* MASK In addition, all occurrences of the original image copy TEMPLATE expression in the following SDSNIVPD (Db2 z/OSMF) files are modified to reflect the new image copy TEMPLATE expression: o DSNTIVIN - parameter AGICHLQ description: from: ssidCP1.&DB..&SN..&IC..D&JU..T&TI. to: ssidCP1.&DB..&SN..&IC.&JU..&UQ. o DSNTIWIN - step s00SETVP ICDSTPLT setting: from: <setVariable name="ICDSTPLT" scope="instance" substitution="true"> ${_workflow-softwareServiceInstanceName}CP1. &DB..&SN..&IC..D&JU..T&TI. </setVariable> to: <setVariable name="ICDSTPLT" scope="instance" substitution="true"> ${_workflow-softwareServiceInstanceName}CP1. &DB..&SN..&IC.&JU..&UQ. </setVariable> The Db2 installation CLIST is also modified use the new image copy TEMPLATE expression. o When editing job DSNTIJMV, the Db2 installation CLIST is modified to fix the hang error that occurs while migrating the originating data sharing group member where the AUTH SEQUENCE field in installation panel DSNTIPM (MVS PARMLIB UPDATES) is assigned a value that is less than 8 digits. o New message DSNT580I: DSNT580I WARNING: A &field-name OF MORE THAN 4369 CYLINDERS REQUIRES AN ENVIRONMENT FOR LARGE OR EXTENDED-FORMAT ARCHIVE LOG DATA SETS Explanation: The CLIST displays this warning when the PRIMARY QUANTITY or SECONDARY QTY. field on panel DSNTIPA specifies 4370 or more cylinders as the primary or secondary space allocation for Db2 archive log data sets. Data sets of this size must reside on SMS-managed storage and belong to a SMS data class that is defined with the extended addressability attribute. o 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.
Temporary fix
Comments
APAR Information
APAR number
PH12364
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-05-21
Closed date
2019-12-19
Last modified date
2020-04-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI67135 UI67137
Modules/Macros
DSNTIJIC DSNTIJPM DSNTXAZP DSNT58 DSNTIDXA DSNTINS1 DSNTINST DSNTIDXC DSNTINS3 DSNTIDXB DSNTINM1 DSNADMUZ DSNTPNDX DSNTIVIN DSNTEJTR DSNTIJPC DSNTIJCV DSNTIPA DSNTIWIN DSNTDJIC DSN@XAZP
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
20 April 2020