DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 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 an ADD DBPARTITIONNUM operation.
Database partition servers that do not respond to a DB2START command within the specified time send a message to the db2start error log in the log subdirectory of the sqllib subdirectory of the home directory for the instance. You should issue a DB2STOP on these nodes before restarting them.
Database partition servers that do not respond to a DB2STOP command within the specified time send a message to the db2stop error log in the log subdirectory of the sqllib subdirectory of the home directory for the instance. You can either issue db2stop for each database partition server that does not respond, or for all of them. (Those that are already stopped will return stating that they are stopped.)
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 internally. 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.