The database manager controls operations for the database by running automatic tasks that can help keep the database in good condition.
The database manager controls the storage space for the database. The server can use all of the space that is available to the directories that you specify for the database. In V7, you do not manage individual volumes for the database, which was necessary in V5. When the database needs more space, instead of adding volumes and extending the database, you add more directories (preferably on different physical volumes) to the database space.
Database reorganization occurs automatically. Based on activity, the database manager program selects database tables to analyze, to determine when reorganization is needed for the tables. The database manager then runs reorganization while server operations continue.
As data is added to the server database, the database manager automatically checks data constraints and data types. The online integrity checks prevent problems for which offline audits were required in earlier releases.
Monitor the space that is used by the server and the space that is available in the file systems where the directories are located. Ensure that space is always available. You can obtain information about database space usage and recovery log usage by reviewing data in the Operations Center or by issuing administrative commands.
Tivoli® Storage Manager V7.1 is installed with the DB2® database application. Users who are experienced DB2 administrators can choose to perform advanced SQL queries and use DB2 tools to monitor the database. However, do not use DB2 tools to change DB2 configuration settings from those settings that are preset by Tivoli Storage Manager. Do not alter the DB2 environment for Tivoli Storage Manager in other ways, such as with other products. The Tivoli Storage Manager server was built and tested with the data definition language (DDL) and database configuration that Tivoli Storage Manager deploys.