The Tivoli® Storage
Manager server
database manager manages and allocates system memory and disk space
for the database. The amount of database space you require depends
on the amount of system memory available and the server workload.
The database manager sorts data in a specific sequence, as per
the SQL statement that you issue to request the data. Depending on
the workload on the server, and if there is more data than the database
manager can manage, the data (that is ordered in sequence) is allocated
to temporary disk space. Data is allocated to temporary disk space
when there is a large result set. The database manager dynamically
manages the memory used when data is allocated to temporary disk space.
For example, expiration processing can produce a large result set.
If there is not enough system memory on the database to store the
result set, some of the data is allocated to temporary disk space.
During expiration processing, if a node or file space are selected
that are too large to process, the database manager does not have
enough memory to sort the data.
To run database operations, consider adding more database space
for the following scenarios:
- The database has a small amount of space and the server operation
that requires temporary space uses the remaining free space.
- The file spaces are large, or the file spaces has a policy assigned
to it which creates many file versions.
- The Tivoli Storage
Manager server
must run with limited memory. The database uses the Tivoli Storage
Manager server main
memory to run database operations. However, if there is insufficient
memory available, the Tivoli Storage
Manager server allocates
temporary space on disk to the database. For example, if 10G of memory
is available and database operations require 12G of memory, the database
uses temporary space.
- An out of database space error is displayed when
you deploy a Tivoli Storage
Manager V6
server. Monitor the server activity log for messages related to database
space.
Important: Do not change the DB2 software that is installed
with the Tivoli Storage
Manager installation
packages and fix packs. Do not install or upgrade to a different version,
release, or fix pack, of DB2 software to avoid damage to the database.