Performance profile
You can purge your performance profiling data to restore free disk space and speed up database utilities.
If you encounter performance problems and are asked to activate profiling for determining your performance bottleneck, the profiling data that is written into specific database tables might become large over time. After you complete your performance analysis and deactivating profiling, you can delete the profiling data that you have collected to restore disk space.
Maintaining performance profile data
The IBM® MDMPIM Profile Data Maintenance Report is available to delete performance profile data based on the options provided in a lookup table. This report is created using the Product Master Scripts and can be scheduled to run on an appropriate maintenance window using the Product Master scheduler.
| Product Master Object Name | Product Master Object Type | Usage |
|---|---|---|
| IBM MDMPIM Profile Data Maintenance Script | Script file in docstore directory /scripts/reports/ | Script file that is used by IBM MDMPIM Profile Data Maintenance Report |
| DB Queries | Script file in docstore directory /scripts/IBM_MDMDocStore_Maintenance/ | Script file that is used by IBM MDMPIM Profile Data Maintenance Report |
| IBM MDMPIM Data Maintenance Lookup | Lookup Table | Input parameters that are used by IBM MDMPIM Profile Data Maintenance Report |
| IBM MDMPIM Data Maintenance Spec | Lookup Table Spec | Lookup Table Spec for IBM MDMPIM Data Maintenance Lookup table |
Sample IBM MDMPIM Profile Data Maintenance Report output
Profile Data Maintenance for ibm Company
Date: 2010-05-25 16:57:14
Delete Profile data older than 2010-05-24 16:57:14
| Profile Table Name | Rows deleted |
|---|---|
| TPFM_PSD_SCHEDULE_DETAIL | 5 |
| TPFM_PSI_PROFILE_SCHEDULE_INFO | 10 |
| TPFM_PPR_PROFILE | 107 |
| TPFM_PPI_PROFILE_INFO | 24 |
Profile Data Maintenance completed.