15.17.1 Steps to take when the processing time for restarting the HADB server takes too long
This subsection describes what to do when the processing time for restarting the HADB server takes too long.
- ■ What to do while the HADB server is restarting
-
After the adbstart command is executed, if the processing for restarting the HADB server takes more time than you expected, check whether the KFAA81215-I message has been output. In the KFAA81215-I message, you can check the progress of database recovery processing.
Based on the information in the KFAA81215-I message, estimate the time required for database recovery processing to complete and subsequent processing to resume.
Note that the KFAA81215-I message is output at regular intervals, according to the value specified for the adb_log_rec_msg_interval operand in the server definition.
- ■ What to do after the processing for restarting the HADB server is complete
-
After the processing for restarting the HADB server is complete, check whether the KFAA81211-I message has been output. In the KFAA81211-I message, you can check the contents of transaction recovery processing.
Check the information output to the KFAA81211-I message and consider reducing the number of updates per transaction. For example, consider increasing the number of commits.
Note that the KFAA81211-I message is output if there is a transaction that took longer to recover than the value specified for the adb_log_rec_msg_interval operand in the server definition.
Based on the transaction ID that is output to the KFAA81211-I message, you can identify the SQL statement that was executed for the corresponding transaction. Use the transaction ID as the key, and check the value for tran_id that was output to the "SQL statement execution information" in the SQL trace information. The SQL statement whose tran_id matches the transaction ID is the SQL statement executed for the corresponding transaction. For details about the SQL statement execution information, see (2) SQL statement execution information in 10.11.2 Information that is output as SQL trace information.
For details about the adb_log_rec_msg_interval operand in the server definition, see the description of the adb_log_rec_msg_interval operand in 7.2.3 Operands related to system logs (set format).