Considerations for monitoring the database

After the Sequential Subset Randomizer has been applied to your database, monitor the database like any other HDAM database. This topic provides tips for monitoring the database that has the Sequential Subset Randomizer applied.

An HDAM database randomized with the Sequential Subset Randomizer needs to be monitored like any other HDAM database. Database Tuning Statistics should be used to monitor periodically the quality of the randomizing and the need to reorganize a database. For example, if the Database Tuning Statistics for April show that the random retrieval of a database record requires as an average 1.23 I/Os and the Database Tuning Statistics from June of the same year show that this figure has increased to 1.89 I/Os, it would be time to reorganize.

As a part of this usual database monitoring, database administrators should observe how the space is occupied by the database records of each subset. This is done by activating the SS-STATS routine during the sequential processing or unloading of the whole database. If the Database Tuning Statistics show a need to reorganize a database, and a database administrator decides to do so, the SS-STATS statistics should be considered in deciding whether also to change the relative amount of space allocated to each subset and regenerate the Sequential Subset Randomizer.