A fix is available
APAR status
Closed as fixed if next.
Error description
In a partitioned DB2 environment the following known issue exists- In DB2 the detach is asynchronous, it is needed to verify successful completion before creating the new partition, and before dropping the detached table. This is not done actually. The script keeps running before the new partition is created. It needs to Query the STATUS column of the SYSCAT.DATAPARTITIONS catalog view.
Local fix
Problem summary
********************** Problem Description: In DB2 partitioned table environment, data trimmer process may fail due to the reason that in DB2, detaching a partition is an asynchronous job, there is a background job does the detach work. So we need add checking to make sure the partition gets detached completely before creating a new partition using the same partition id. ********************** Recommendation: The fix will be in ITCAM for Application Diagnostics 7.1 FP4 (7.1.0.4). Apply ITCAM for AD 7.1.0.4 when it is available. Problem Summary: ********************** ********************** PROBLEM CONCLUSION: TEMPORARY FIX: Hot fixes have been provided to the customers. The workaround is to recreate partition tables and restart DB2 instance. COMMENTS: MODULES/MACROS: None SRLS: RTN CODES: APPLICABLE COMPONENT LEVEL/SU: R610 PSY UP CIRCUMVENTION: MESSAGE TO SUBMITTER: ERROR DESCRIPTION:
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PI20934
Reported component name
TCAM AD MAN SER
Reported component ID
5724Y92MS
Reported release
710
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-06-27
Closed date
2015-06-25
Last modified date
2015-06-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R710 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSDTFJ","label":"Tivoli Composite Application Manager for Application Diagnostics"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"710","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
27 July 2021