A fix is available
APAR status
Closed as program error.
Error description
++HOLD INFO INCORRECT IN PM36340'S PTF UK69177/UK69178 WHICH STATES 'OPEN PARENTHESIS' WHEN IT SHOULD STATE 'CLOSED PARENTHESIS' Additional symptoms: IBM0142S ONCODE=42 The TRANSMIT condition was raised because of an uncorrectable error in input (FILE= ADBWSPR). From entry point READ_WRITE at statement 757 at compile unit offset +00000180 at entry offset +00000180 at address 1EE14D38. msgIBM0142S ONCODE42
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS Version 7.2 who use SAMP member * * ADB2UCU6 to update skeleton ADB2UCUS. * * Users of the DB2 Administration Tool for * * z/OS Version 10.1 who will need to use * * ADB2UCU4, which is provided via this * * APAR. * **************************************************************** * PROBLEM DESCRIPTION: In the DB2 Administration Tool for * * z/OS, while running a Work Statement * * List (WSL) using batch job, the * * SYSPRINT DSN for the ADBTEP2 step is * * missing and fails with the following * * JCL error: * * * * IEF648I INVALID DISP FIELD- PASS * * SUBSTITUTED * * * * and the ADBWSPR DSN is also missing * * and fails with the following error: * * * * IEF212I ADBWSPR - DATA SET NOT FOUND * * - STEP WAS NOT EXECUTED. * * * * As a result, the Load Summary Report * * step is not retrieved from the * * ADB2UCUS ISPF skeleton. The data * * sets are allocated using the TSO * * userid as the high level qualifier * * which might not be workable for the * * user. APAR PM08490 has already * * enabled retrieving customized * * SYSPRINT DSN from ADB2UCUS but * * missed the SAMPLE job and the * * ++HOLD DATA describing post-SMP/e * * customization steps. Also, the * * prefix of data sets from DB2 * * Object Compare/Change Management * * panel GOC5 'Generate Compare Jobs' * * and panel ADB2CEX1 'Run a Change' * * is not applied to WSL SYSPRINT * * DSN when the user choose to build * * the RUN WSL JCL during the COMPARE * * or ANALYZE change. * **************************************************************** * RECOMMENDATION: * **************************************************************** In the DB2 Administration Tool for z/OS, while running a Work Statement List (WSL) using batch job, the SYSPRINT DSN for the ADBTEP2 step is missing and fails with the following JCL error: IEF648I INVALID DISP FIELD- PASS SUBSTITUTED and the ADBWSPR DSN is also missing and fails with the following error: IEF212I ADBWSPR - DATA SET NOT FOUND - STEP WAS NOT EXECUTED. As a result, the Load Summary Report step is not retrieved from the ADB2UCUS ISPF skeleton. The data sets are allocated using the TSO userid as the high level qualifier which might not be workable for the user. APAR PM08490 has already enabled retrieving customized SYSPRINT DSN from ADB2UCUS but missed the SAMPLE job and the ++HOLD DATA describing post-SMP/e customization steps. Also, the prefix of data sets from DB2 Object Compare/Change Management panel GOC5 'Generate Compare Jobs' and panel ADB2CEX1 'Run a Change' is not applied to WSL SYSPRINT DSN when the user choose to build the RUN WSL JCL during the COMPARE or ANALYZE change.
Problem conclusion
Sample member ADB2UCU6 for DB2 Administration Tool for z/OS Version 7.2 and ADB2UCU4 for DB2 Administration Tool for z/OS Version 10.1 were added to provide the instructions on the post-SMP/e customization steps. Skeleton ADB2WL4 was modified by removing the building of the PRINTDSN value and let the value be retrieved from ADB2UCUS. This APAR also enables the prefix of data sets from DB2 Object Compare/Change Management panels GOC5 'Generate Compare Jobs' and panel ADB2CEX1 'Run a Change' to be applied to PRINTDSN when user choose to build the run WSL JCL during a COMPARE or ANALYZE change. After this APAR is applied, the user will have to perform the action in ++HOLD, otherwise, running WSL in batch mode may fail with a JCL error due to a missing value for SYSPRINT DSN.
Temporary fix
Comments
APAR Information
APAR number
PM59529
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-03-01
Closed date
2012-03-22
Last modified date
2012-06-22
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK77306 UK77307
Modules/Macros
ADB2UCU4 ADB2UCU6 ADB2WL4 ADB2W1
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
22 June 2012