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, according
to 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 that is 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 cannot
sort the data in memory. The database manager must use temporary space
to sort 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 that
is 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 that are 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.