What are the Archive Manager's DDMDB Performance Improvements in Spectrum 10.3?

book

Article ID: 131028

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

DDMDB Performance Improvements 

Problem: 
======= 
- Due to landscape data consolidation with Spectrum 10.x, DDMDB database is growing in size. 
- Data retrieval is slow and OneClick console /Archive manager hang on selecting event tab 
- Before 10.3 , DDMDB database uses MyISAM engine for data storage 
 

What are the DDMDB Performance Improvements in Spectrum 10.3?

Environment

CA Spectrum 10.3.x

Resolution

Solution: 
======= 
- All the tables are converted from MyISAM to high performance engine InnoDB. 
- Event table is partitioned to speed up the data retrieval. 



Archive Manager Database Changes 

- For Fresh Install: All the DDMDB tables will be in InnoDB by default 
- Upgrade and Migrations: After Installation, to convert the tables run the below script 
./convert_current_myisam_to_innodb.pl 
- It is recommended to run the above script after upgrade 
- Save the DDMDB database before running to avoid any potential data loss 

Note: If customer initializes the ddm database after upgrade to 10.3 then all the database tables will have InnoDB Engine. 

-------------------------------------------------- 

Conversion Script 

Prerequisite: 
- Free disk space should be greater than 3 times the size of event table 
- Navigate to the location: $SPECROOT\SS\DDM\scripts 
- Run the script ./convert_current_myisam_to_innodb.pl 
- After the tables conversion user is prompted whether to start the Archive Manager 

Note:Archive Manager is stopped and user should not start until the script execution is complete 

------------------------------------------------- 

Event Table Partitioning 

- Each partition of the event table contains one day of data 
- The number of partitions will be equal to Archive Manager event retention period + 1(future date) 
- In case of fresh install you will see the 2 partitions – one partition for installation date and another for future date 
- Each day depending upon retention period Archive Manager 
-- Creates a new partition 
-- Deletes the oldest partition during the events purge 

------------------------------------------------ 

DDM Utilities 

- ddmsave and ddmload utilities supports InnodB database 
- If the Archive Manager database is InnoDB 
-- ddmload will not allow you to load the MyISAM database file 
e.g: database save file created in version less than 10.3 
- To load the old MyISAM database file, user need to convert the file to InnoDB database using the conversion script (convert_saved_myisam_to_innodb.pl) 


Converting old saved db to InnoDB: 
- Navigate to the location : $SPECROOT\SS\DDM\scripts 
- Run the script ./convert_saved_myisam_to_innodb.pl 
- Prerequisite: Free disk space should be greater than 3 times the size of event table 
- Script log files will be generated in location $SPECROOT\SS\DDM\scripts 
 

Additional Information

Post Upgrade Tasks 
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-3-2/installing-and-upgrading/upgrading.html

Known issues:

Failure in the mysqlbackup during the execution of post_olb_script does not generate event and alarm
https://knowledge.broadcom.com/external/article?articleId=206381

10.3 DDMDB convert_current_myisam_to_innodb.pl fails with ERROR 1086 
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=115500

Why does the post upgrade script convert_current_myisam_to_innodb.pl fail on line 16?
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=119925

Error when running the Spectrum post install script on Linux
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=122847

DISK SPACE CHECK BUG
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=125596