DB2 10.5 for Linux, UNIX, and Windows
DB2 10.5 for Linux, UNIX, and Windows
This parameter specifies the time, in minutes, within which all database partition servers must respond to a START DBM or a STOP DBM command. It is also used as the timeout value during ADD DBPARTITIONNUM and DROP DBPARTITIONNUM operations.
Member or nodes that do not respond to db2start or db2stop commands within the specified time will be killed and cleaned up automatically by db2start or db2stop in a multi member/node instance. The diagnostic messages are logged into the diagpath defined in the database manager configuration or at its default value (for example, sqllib/db2dump/ $m on UNIX operating systems).
If a db2start or db2stop operation in a multi-partition database is not completed within the value specified by the start_stop_time database manager configuration parameter, the database partitions that have timed out will be killed and cleaned up automatically. Environments with many database partitions with a low value for start_stop_time might experience this behavior. To resolve this behavior, increase the value of start_stop_time.
When adding a new database partition using one of the db2start, START DATABASE MANAGER, or ADD DBPARTITIONNUM commands, the add database partition operation must determine whether or not each database in the instance is enabled for automatic storage. This is done by communicating with the catalog partition for each database. If automatic storage is enabled, the storage path definitions are retrieved as part of that communication. Likewise, if system temporary table spaces are to be created with the database partitions, the operation might have to communicate with another database partition server to retrieve the table space definitions for the database partitions that reside on that server. These factors should be considered when determining the value of the start_stop_time parameter.