idsdbmaint
Use the idsdbmaint command to do database maintenance activities for a directory server instance.
Description
The idsdbmaint command runs DB2® maintenance activities on the database that is associated with a directory server instance. The DB2 maintenance activities include DB2 index reorganization, DB2 row compression on tables, and DB2 table space conversion.
Note:
- The directory server instance must be in stopped state before you run the idsdbmaint command.
- The idsdbmaint command can be run only by a root user on AIX®, Linux®, and Solaris systems.
Synopsis
idsdbmaint [-I instance_name [-b outputfile] [-d debuglevel]] |
[ -i ] | [ -r ] | -h | -?Options
The idsdbmaint command takes the following parameters.- -b outputfile
- Specifies the full path of a file to redirect output. If debug mode is set, the debug output is sent to this file.
- -d debuglevel
- Sets the debug level to debuglevel. The ldtrc command must be running, when you use this parameter.
- -I instance_name
- Specifies the directory server instance name.
- -i
- Specifies to run index reorganization on the database that is associated with the directory server instance.
- -r
- Specifies to run row compression on the database that is associated with the directory server instance.
- -h | -?
- Specifies to show the usage.
Examples
- Example 1:
- To do index reorganization, run the idsdbmaint command
with the following parameters:
idsdbmaint –I instance_name -i - Example 2:
- To inspect the tables and to run row compression, run the idsdbmaint command
with the following parameters:
The command does row compression only if the compression would result in more than 30% space benefit.idsdbmaint –I instance_name -r