IBM Support

IV70417: SELECT QUERY FROM 'LOG SHIPPING JOB DETAIL' ATTRIBUTE GROUP IS CAUSING SEVERE DELAY ON SQL AGENT JOBS.

Subscribe

You can track all active APARs for this component.

 

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