Pruning no longer taking place for the STATS, BL and RT tables in TrueSight Infrastructure Management (TSIM) which is causing the database to grow very large in size.

If there are a large number of records in the STATS_ERRORS and ITEMCFG_DTLSLOG tables then it can cause pruning to hang.
 
The count on those tables should be verified by running the following steps:

*note : This required 15-20 minutes downtime.

1. Login to dbisql editor using dba user only in case of Sybase DB.

*note : If Oracle DB, login to SQL prompt using TSIM user.

2. Verify count of the tables:

select count(*) from ITEMCFG_DTLSLOG

select count(*) from STATS_ERRORS

If the counts are high then proceed with remaining steps, otherwise contact BMC Customer Support.

3. Stop TSIM using command 'pw sys stop'
 
4. Start only DB using command 'pw p s dbsrv' only in case of Sybase DB.

5. The pruning period of those tables should be changed by running the following:
 
update prune_cntl SET DELTAHOURS=48 where TABLENAME='ITEMCFG_DTLSLOG'

update prune_cntl SET DELTAHOURS=72 where TABLENAME='STATS_ERRORS'

commit;

6. Truncate the tables:

truncate table ITEMCFG_DTLSLOG

truncate table STATS_ERRORS

7. Verify the counts again to ensure they are 0:

select count(*) from ITEMCFG_DTLSLOG

select count(*) from STATS_ERRORS

8. Start TSIM using command 'pw sys start'

9. Verify pruner.log to ensure pruning taking place.

10. If there are unwanted partitions due to no pruning, the attached contains a procedure for removing them.

*** These steps only work for windows, If you need to run in Linux/Unix follow Linux-Connect-Sybase.doc attached before them.

If the pruner has any issues, check ST_Views output and verify if the data is beyond the configuration period which is 3 days.
Ex: Few views
_PATROL__NT_CPU_ST_VIEW & _PATROL__NT_HEALTH_ST_VIEW & _PATROL__NUK_CPU_ST_VIEW & _PATROL__NUK_MEMORY_ST_VIEW & _PATROL__NUK_FILESYSTEM_ST_VIEW
These views extract data from STATS tables and store the data.

Note: Increasing the STATS data retention period may result in the performance of the TSIM Server.


Refer to the below doc link for more about "Data retention".
https://docs.bmc.com/docs/TSOperations/11304/best-practices-and-configuration-guidelines-for-performance-and-scalability-937357308.html

Refer to the below knowledge article for the data retention period.
https://community.bmc.com/s/article/TrueSight-Infrastructure-Management-TSIM-How-to-check-the-default-retention-period-of-raw-condensed-baseline-event-data-and-how-to-reset-them