APAR status
Closed as fixed if next.
Error description
When processing a CA7 listing, it takes 30 minutes to remove the old data, 3.25 hours to process the 75,439 jobs (which is reasonable) then 5 hours performing some repository processing (two example SQL statements below). UPDATE CA7_JobsDependentOnJobs cjdj SET cjdj . DependentOn_JobID = ( SELECT cj1 . JobID FROM CA7_Jobs cj1 INNER JOIN CA7_Libraries cl1 ON cj1 . LibID = cl1 . LibID where cl1 . RootID = cjdj . RootID AND UPPER ( cj1 . JOB_NAME ) = UPPER ( cjdj . DependentOn_JobName ) FETCH FIRST ROWS ONLY ) WHERE EXISTS ( SELECT 1 FROM CA7_Jobs cj2 INNER JOIN CA7_Libraries cl2 ON cj2 . LibID = cl2 . LibID where cl2 . RootID = cjdj . RootID AND UPPER ( cj2 . JOB_NAME ) = UPPER ( cjdj . DependentOn_JobName ) ) UPDATE CA7_JobsTriggeredByJobs cjtj SET cjtj . TriggeredBy_JOBID = ( SELECT cj1 . JobID FROM CA7_Jobs cj1 INNER JOIN CA7_Libraries cl1 ON cj1 . LibID = cl1 . LibID WHERE cl1 . RootID = cjtj . RootID AND UPPER ( cj1 . JOB_NAME ) = UPPER ( cjtj . TriggeredBy_JobName ) FETCH FIRST ROWS ONLY ) WHERE EXISTS ( SELECT 1 FROM CA7_Jobs cj2 INNER JOIN CA7_Libraries cl2 ON cj2 . LibID = cl2 . LibID WHERE cl2 . RootID = cjtj . RootID AND UPPER ( cj2 . JOB_NAME ) = UPPER ( cjtj . TriggeredBy_JobName ) ) The first took more than 3 hours and the second more than 30 minutes.
Local fix
N/A
Problem summary
Problem summary: 'CA7 import' post-process takes too long to execute on DB2 on Z. Problem conclusion: UPDATE queries(which are executed during 'CA7 import' post-process) have been modified, eliminating calls to the UPPER function.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH36246
Reported component name
APPL DISCOVERY
Reported component ID
5737B1600
Reported release
510
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-04-13
Closed date
2021-06-22
Last modified date
2021-06-22
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
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSRR9Q","label":"IBM Application Discovery"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"510"}]
Document Information
Modified date:
23 June 2021