A fix is available
APAR status
Closed as program error.
Error description
Code updates to fix various issues. 1. S0C4 Abend in ABPUSE15 offset 000010F8 if LOAD field specification column datatype overrides catalog definition. 2. Utility Enhancement Tool fails to compare TABLE rule parameter when UNLOAD TABLESPACE is run. 3. Utility Enhancement Tool fails to perform thread cancellation for object lists with more than 20 objects 4. Coding the group attach name as the operand to the DB2SSID parm in the batch interface causes RC=28 and message ABPB6205E Error connecting to DB2 with DB2 SSID= to be issued. 5. Interception may be denied if group attach name is used on DSNUTILB exec parameter. 6. EXCLUDE rules work incorrectly with double nodes names like database.tablespace 7. DSNUTILB returns an error parsing the SYSIN data set when template dataset names like utility command names. 8. The separate SHRLEVEL rule values are not compared to the actual utility values. DIAG message received 'INCLUDE SHRLEVEL RULE NUMBER: 00000003 NOMATCH INTERCEPT OFF P: REFERENCE' 9. A loop occurs while the ISPF interface is attempting to access the server and the DB2 needed to service the request is terminating. This occurs only when Utility Enhancement Tool is running on a single CPU system. 10. V9 CHECK and REBUILD INDEX SHRLEVEL REFERENCE get DSNU5901 error after Thread Blocker places objects into RO status. 11. A comma after the row specification in LOAD causes UTILITY ENHANCEMENT TOOL to discard some subsequent parameters. 12. REBUILD_INDEX parse does not recognize SHRLEVEL CHANGE in DB2 V9 utility syntax. 13. Policy check may skip a rule if previous rule matches 14. Multiple specifications of same rule within include/exclude group may incorrectly fail policy check. 15. EXEC SQL has problem parsing and executing ALTER VIEW, ALTER TABLE and DROP SYNONYM statements. 16. Thread blocker status messages are incorrectly reporting the initial saved settings after allow threads run. 17. Parsing error of LOAD INTO TABLE spec causes S04E abend with extended syntax. Additional message includes: UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X' 18. ISPF interface message cleanup of ABP013E 19. Intermittent ABEND0C4-11 in ABPGDYNA+09AE. The code is trying to copy the SAPI browse token from the JES2 storage area to local storage. 20. DSNUTILB intercept fails to perform ALLOW_THREADS and delete worklist after failed utility. 21. The user security exit with an option PERMIT SIGN ON turned off causes UTILITY ENHANCEMENT TOOL termination or hanging 22. abpcomx - comjobn field is incorrect on v1.1 control block display - COMX display shows garbled data. 23. ABPID must be 4 alphanumeric characters long. 24. Make ABP014E message more specific, changed to "ABP014E - Status information cannot be displayed before thread is cancel" 25. Message cleanup. 26. Message Formatter should provide leading zeros for hexadecimal values, previously leading blanks were being inserted incorrectly. 27. Incorrect parsing of LOAD statement when PART keyword is specified. 28. When any of the loadlib datasets in the started task STEPLIB/JOBLIB concatenation have the same dataset name as a dataset in the JOBLIB allocation in the DSNUTILB job an allocation failure occurs when dynamically creating the loadlib concatenation to be used by the DSNUTILB intercept. 29. ABPUMAIN diagnostic WTO messages replaced with formatted messages. 30. UTILITY ENHANCEMENT TOOL utility job return code 0 should be return code 4. Utility job consists of MODIFY RECOVERY and COPY statements. MODIFY RECOVERY return code is 4 and COPY return code is 0. When job is run without DUET contol the job return code is 4. When run with DUET control the return code is 0. 31. Duplicate SYSIN/SYSPRINT DD's cause allocation errors. The duplicate SYSIN is generated automatically when a comment statement exists in first SYSIN DD. 32. Report DB2 connection errors on panel ABPLPRF1. Example ABP033E - DB2 subystem unavailable. Authorization error 33. Modify ABPBCOMX utility to support V1.1 and V2.1
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users od Utility Enhancement Tool. * **************************************************************** * PROBLEM DESCRIPTION: Code updates to fix various issues. * * 1. S0C4 Abend in ABPUSE15 offset * * 000010F8 if LOAD field specification * * column datatype overrides catalog * * definition. * * * * 2. Utility Enhancement Tool fails to * * compare TABLE rule parameter when * * UNLOAD TABLESPACE is run. * * * * 3. Utility Enhancement Tool fails to * * perform thread cancellation for object * * lists with more than 20 objects * * * * 4. Coding the group attach name as the * * operand to the DB2SSID parm in the * * batch interface causes RC=28 and * * message ABPB6205E Error connecting to * * DB2 with DB2 SSID= to be issued. * * * * 5. Interception may be denied if group * * attach name is used on DSNUTILB exec * * parameter. * * * * 6. EXCLUDE rules work incorrectly with * * double nodes names like: * * database.tablespace * * * * 7. DSNUTILB returns an error parsing * * the SYSIN data set when template * * dataset names like utility command * * names. * * * * 8. The separate SHRLEVEL rule values * * are not compared to the actual utility * * values. DIAG message received 'INCLUDE * * SHRLEVEL RULE NUMBER: 00000003 NOMATCH * * INTERCEPT OFF P: REFERENCE' * * * * 9. A loop occurs while the ISPF * * interface is attempting to access the * * server and the DB2 needed to service * * the request is terminating. This occurs * * only when Utility Enhancement Tool is * * running on a single CPU system. * * * * 10. V9 CHECK and REBUILD INDEX SHRLEVEL * * REFERENCE get DSNU5901 error after * * Thread Blocker places objects into RO * * status. * * * * 11. A comma after the row specification * * in LOAD causes UTILITY ENHANCEMENT TOOL * * to discard some subsequent parameters. * * * * 12. REBUILD_INDEX parse does not * * recognize SHRLEVEL CHANGE in DB2 V9 * * utility syntax. * * * * 13. Policy check may skip a rule if * * previous rule matches * * * * 14. Multiple specifications of same * * rule within include/exclude group * * may incorrectly fail policy check. * * * * 15. EXEC SQL has problem parsing and * * executing ALTER VIEW, ALTER TABLE and * * DROP SYNONYM statements. * * * * 16. Thread blocker status messages are * * incorrectly reporting the initial saved * * settings after allow threads run. * * * * 17. Parsing error of LOAD INTO TABLE * * spec causes S04E abend with extended * * syntax. Additional message includes: * * UTILITY DATA BASE SERVICES MEMORY * * EXECUTION ABENDED, REASON=X' * * * * 18. ISPF interface message cleanup of * * ABP013E * * * * 19. Intermittent ABEND0C4-11 in * * ABPGDYNA+09AE. The code is trying to * * copy the SAPI browse token from the * * JES2 storage area to local storage. * * * * 20. DSNUTILB intercept fails to perform * * ALLOW_THREADS and delete worklist after * * failed utility. * * * * 21. The user security exit with an * * option PERMIT SIGN ON turned off causes * * UTILITY ENHANCEMENT TOOL termination or * * hanging. * * * * 22. abpcomx - comjobn field is * * incorrect on v1.1 control block display * * COMX display shows garbled data. * * * * 23. ABPID must be 4 alphanumeric * * characters long. * * * * 24. Make ABP014E message more specific, * * changed to "ABP014E - Status * * information cannot be displayed before * * thread is cancel" * * * * 25. Message cleanup. * * * * 26. Message Formatter should provide * * leading zeros for hexadecimal values, * * previously leading blanks were being * * inserted incorrectly. * * * * 27. Incorrect parsing of LOAD statement * * when PART keyword is specified. * * * * 28. When any of the loadlib datasets * * in the started task STEPLIB/JOBLIB * * concatenation have the same dataset * * name as a dataset in the JOBLIB * * allocation in the DSNUTILB job an * * allocation failure occurs when * * dynamically creating the loadlib * * concatenation to be used by the * * DSNUTILB intercept. * * * * 29. ABPUMAIN diagnostic WTO messages * * replaced with formatted messages. * * * * 30. UTILITY ENHANCEMENT TOOL utility * * job return code 0 should be return * * code 4. Utility job consists of * * MODIFY RECOVERY and COPY statements. * * MODIFY RECOVERY return code is 4 and * * COPY return code is 0. When job is * * run without DUET contol the job return * * code is 4. When run with DUET control * * the return code is 0. * * * * 31. Duplicate SYSIN/SYSPRINT DD's * * cause allocation errors. The duplicate * * SYSIN is generated automatically when * * a comment statement exists in first * * SYSIN DD. * * * * 32. Report DB2 connection errors on * * panel ABPLPRF1. Example ABP033E - * * DB2 subystem unavailable. * * Authorization error. * * * * 33. Modify ABPBCOMX utility to support * * V1.1 and V2.1 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
Apply the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK71015
Reported component name
DB2 UTIL ENHANC
Reported component ID
5655T5800
Reported release
210
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2008-08-22
Closed date
2008-12-02
Last modified date
2009-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK42116
Modules/Macros
ABPBCOMX ABPFADM0 ABPFADM1 ABPFADM2 ABPFADM3 ABPFAPI ABPFCTHD ABPFGABP ABPFGDB2 ABPFGSYS ABPFIAPI ABPFIPCV ABPFMAIN ABPFMSGL ABPFMSG1 ABPFOBJR ABPFPRF0 ABPFPRF1 ABPFPRF2 ABPFPRF3 ABPFRELR ABPFSABP ABPFSDB2 ABPFSESS ABPFSKL ABPFSSEC ABPFSSYS ABPFTAPI ABPFTHDD ABPFTHDL ABPFTHD1 ABPFTHD2 ABPFTHD3 ABPFTHD4 ABPFTHD5 ABPGDYNA ABPGMSGF ABPISPF ABPMSGEN ABPPANEL ABPPAPI ABPPBALC ABPPBATU ABPPBATX ABPPCHCK ABPPCOPY ABPPDITB ABPPDOBJ ABPPEXEC ABPPEXPR ABPPFILE ABPPFSPC ABPPINEX ABPPINIX ABPPIPCV ABPPLINE ABPPLIST ABPPLOAD ABPPMSG ABPPMSGI ABPPOPTS ABPPOSGS ABPPPDB2 ABPPPFLE ABPPPLCY ABPPPLYX ABPPPREL ABPPPRSE ABPPPSTR ABPPQUIS ABPPREBU ABPPRECO ABPPREOR ABPPROC ABPPSCNV ABPPSTMT ABPPSTRG ABPPTMPL ABPPUNLD ABPPUTLU ABPPUTLX ABPPXMLU ABPRBTHD ABPRDB2S ABPRDFLT ABPRDOBJ ABPRSFLT ABPRSOBJ ABPRUSQL ABPSBTHD ABPSDB2I ABPSDB2S ABPSDFLT ABPSDOBJ ABPSSFLT ABPSSOBJ ABPSTDB2 ABPSTSES ABPSTSRV ABPSUSQL ABPUFSPC ABPUMAIN ABPUSTUB ABP01 ABP03 ABP04
Fix information
Fixed component name
DB2 UTIL ENHANC
Fixed component ID
5655T5800
Applicable component levels
R210 PSY UK42116
UP08/12/06 P F812
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0"}]
Document Information
Modified date:
12 February 2021