A fix is available
APAR status
Closed as program error.
Error description
This APAR distributes the following fixes: 1) LOAD utility job may hang upon restart if extended syntax is used 2) Failure to correctly block threads with REBUILD INDEX (ALL) TABLESPACE utility statement 3) When the required authority for UET STC ID is revoked while UET STC is running, a repetitive -904 SQL error message and excessive CSA memory consumption can occur 4) Suppress thread blocking for UET DB2 objects 5) UET STC terminates when TRACE_SIZE = 0 and "/F,DISPLAY TRACE" command entered 6) UET fails to select thread for non-partitioned objects if only DATABASE filter is specified 7) UET syntax parser fails to process POSITION(*+n:n) structure for LOAD utility 8) When the UET syntax parser encounters an extended syntax keyword immediately following a LOAD utility keyword that contains parentheses, unbalanced parentheses can result 9) UET STC can terminate when single-digit WTO ROUTCDE is entered via ISPF Dialog Option "Control Utilities Enhancement Tool System" 10) UET Extended Syntax VALUEIF (Load utility) may fail if column name specified in VALUEIF clause 11) Customization results in Policy member containing X'05' in leading bytes of indented lines 12) ABP-973 - Add APAR level to message ABPS0019I
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Utilities Enhancement Tool. * **************************************************************** * PROBLEM DESCRIPTION: This APAR distributes the following * * fixes: * * 1. LOAD utility job may hang upon * * restart if extended syntax is used * * 2. Failure to correctly block threads * * with REBUILD INDEX (ALL) TABLESPACE * * utility statement * * 3. When the required authority for UET * * STC ID is revoked while UET STC is * * running, a repetitive -904 SQL error * * message and excessive CSA memory * * consumption can occur * * 4. Suppress thread blocking for UET * * DB2 objects * * 5. UET STC terminates when TRACE_SIZE * * = 0 and "/F,DISPLAY TRACE" command * * entered * * 6. UET fails to select thread for * * non-partitioned objects if only * * DATABASE filter is specified * * 7. UET syntax parser fails to process * * POSITION(*+n:n) structure for LOAD * * utility * * 8. When the UET syntax parser * * encounters an extended syntax keyword * * immediately following a LOAD utility * * keyword that contains parentheses, * * unbalanced parentheses can result * * 9. UET STC can terminate when * * single-digit WTO ROUTCDE is entered via * * ISPF Dialog Option "Control Utilities * * Enhancement Tool System" * * 10. UET Extended Syntax VALUEIF (Load * * utility) may fail if column name * * specified in VALUEIF clause * * 11. Customization results in Policy * * member containing X'05' in leading * * bytes of indented lines * * 12. ABP-973 - Add APAR level to * * message ABPS0019I * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM11973
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
2010-04-09
Closed date
2010-05-20
Last modified date
2010-06-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK57125
Modules/Macros
ABPFCTHD ABPFGABP ABPFGDB2 ABPFGSYS ABPFIAPI ABPFIPCV ABPFMAIN ABPFMSGL ABPFOBJR ABPFRELR ABPFSABP ABPFSDB2 ABPFSESS ABPFSSEC ABPFSSYS ABPFTAPI ABPFTHDD ABPFTHDL ABPMSGEN ABPPLCY ABPPLOAD ABPPREBU ABPRBTHD ABPRDB2S ABPRSFLT ABPRUSQL ABPSBTHD ABPSDB2I ABPSDB2S ABPSINIT ABPSSFLT ABPSTCMD ABPSTDB2 ABPSTSRV ABPSUSQL ABPUMAIN ABPUSE15
Fix information
Fixed component name
DB2 UTIL ENHANC
Fixed component ID
5655T5800
Applicable component levels
R210 PSY UK57125
UP10/05/26 P F005
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