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