DASD MANAGER PLUS repositories management

DASD MANAGER PLUS uses Db2 tables to hold statistics and other functional data.

You can manage the size of these repositories by maintaining them on a regular basis. Following are some recommendations on how to manage these repositories.

BMCSTATS repositories

You can choose to purge the BMCSTATS repository either when you run BMCSTATS jobs, or on a more regular basis by using a batch program:

• If performance is not a consideration, you can set the DELETEAGE option (to delete statistics older than a specified age) when you run BMCSTATS jobs, or through the online interface. For more information on deleting individual statistics through the interface, see Deleting-BMC-Software-statistics
• If performance is a consideration, you can run a batch program that deletes statistics from the database on a regular basis. BMC provides sample SQL (ASURSDEL) in the .CNTL data set. You can modify this sample SQL for your environment. You can also use it as input to DSNTEP2 or a similar program. ASURSDEL deletes statistics by age and deletes statistics for objects that no longer exist in the Db2 catalog.

After purging data, consider running REORG, RUNSTATS, and rebinds on a regular basis. You should also examine the repository for extents.

Consider purging the data whenever the an object's structure changes. For example, if you change an object from nonpartitioned to partitioned, be sure to delete the old statistics for that object so that the statistics remain consistent.

BMCTRIG repositories

You can purge the BMCTRIG exceptions data either when you run BMCTRIG jobs or on a more regular basis.

We recommend adding the DELETEAGE option (to delete all exception rows older than a specified age) to one of the BMCTRIG worklists to purge the exceptions table automatically. The following example shows how you can include DELETEAGE in a worklist that deletes all exception rows older than 89 days:

You can run a batch program to select the rows for deletion and then delete them, which enables you to purge the BMCTRIG exceptions data on a regular basis. BMC provides sample SQL (ASURSSEL) in the .CNTL data set. This sample SQL, which you can modify for your environment, can be used as input to DSNTEP2 or a similar program. You can run ASURSDEL to delete rows older than a specified age.