IBM Support

IV63044: UPGRADE TO 9.1 CAUSES SLOW FILLDB INSERTION RATES AND HIGH SQLSRV CPU USAGE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Upgrade to 9.1 causes slow FillDB insertion rates and high
    sqlsrv CPU usage.
    
    Symptoms: The sqlsrv process CPU usage hovers around 90 to 100%
    and FillDB insertion rates drop from 1000's to 100's of rows per
    second
    
    The cause in the performance degradation was due to a change in
    the database stored procedures' input parameter types (bigint
    from ROWVERSION type)
    

Local fix

  • To work around the issue, you will need to run a query to update
    the stored procedures.
    
    1. Backup the BFEnterprise database
    2. Backup all of the stored procedures in the database
    
    [dbo].[fetch_actionIDs]
    [dbo].[update_staleFixletResultsOnFullRefresh]
    [dbo].[fetch_actionResults]
    [dbo].[fetch_actions]
    [dbo].[fetch_computers]
    [dbo].[fetch_deletedObjects]
    [dbo].[fetch_fixletResults]
    [dbo].[fetch_local_objects]
    [dbo].[fetch_propertyResultsChanges]
    [dbo].[fetch_statisticalPropIds]
    [dbo].[getComputerSequences]
    
    3. Run the query to update the stored procedures.
    
    The query can be found here:
    https://www.ibm.com/developerworks/community/wikis/form/api/wiki
    /90553c0b-42eb-4df0-9556-d3c2e0ac4c52/page/e3ae8512-b5da-436f-95
    63-eee9199cbd4c/attachment/a93f4879-50f1-4cb4-a4ed-c31e4a79f0f8/
    media/All-fixed.sql
    

Problem summary

  • Fixed in IBM Endpoint Manager 9.1 (fixpack 5).
    
    
    General availability Q4 2014 (release schedule subject to
    change).
    

Problem conclusion

  • Fixed in IBM Endpoint Manager 9.1 (fixpack 5).
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV63044

  • Reported component name

    TIV EP MGR SERV

  • Reported component ID

    5725C43SV

  • Reported release

    91W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-07-29

  • Closed date

    2014-10-09

  • Last modified date

    2014-10-09

  • 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 EP MGR SERV

  • Fixed component ID

    5725C43SV

Applicable component levels

  • R91W PSY

       UP

[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SSBQVS","label":"Tivoli Endpoint Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"91W","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
09 October 2014