Direct links to fixes
APAR status
Closed as program error.
Error description
Customer Environment: Windows versions : Microsoft Windows Server 2008 R2 Enterprise SQL Server versions : Microsoft SQL Server 2008 R2 SQL Server Agent version : 06.30.02.00 Targeted SQL Server Agent version : 6.31.02.00 Problem Description: Select query on sysjobhistory from 'Log shipping Job Detail' attribute group is blocking or delaying execution of other queries/jobs customer is running on SQL server. Following is the reasons The problematic query is used to find job name from msdb.Sysjobhistory table by searching for the agent ID in the message column of Sysjobhistory. It is taking more time becuase msdb..sysjobhistory table contains millions of rows. Impact: Due to this jobs in customer enviornment which were taking 4 to 5 seconds before, taking longer time to execute. Detailed re-creation Procedure: 1) Create Log Shipping jobs on SQL Server such that msdb..sysjobhistory table should get filled up with millions of records. 3) Visit Log Shipping Job Details workspace on portal. 4) At same time execute SQL agent jobs. 5) When agent is collecting data for Log shipping job detail attrbute group, jobs executing on SQL Server get delayed. Related Files and Output: None.
Local fix
Problem summary
SELECT QUERY FROM 'LOG SHIPPING JOB DETAIL' ATTRIBUTE GROUP IS CAUSING SEVERE DELAY ON SQL AGENT JOBS
Problem conclusion
Fixed in 6.3.1.2-TIV-ITM_SQL-IF0001
Temporary fix
not provided
Comments
APAR Information
APAR number
IV70417
Reported component name
TIV MON MS SQL
Reported component ID
5724B96MO
Reported release
621
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-03-03
Closed date
2015-04-28
Last modified date
2015-04-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
TIV MON MS SQL
Fixed component ID
5724B96MO
Applicable component levels
R630 PSY
UP
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSDKXQ","label":"Tivoli Composite Application Manager for Microsoft Applications"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"621"}]
Document Information
Modified date:
02 October 2021