Hitachi

Hitachi Advanced Database Messages


KFAA81211-I

Processing to recover transactions is complete. (transaction ID = aa....aa, recovered rows = {ins: bb....bb, upd: cc....cc, del: dd....dd}, buffer requests = ee....ee, pages read = {count: ff....ff, total size: gg....gg KB}, pages written = {count: hh....hh, total size: ii....ii KB}) (L+M)

Processing to recover the transaction has terminated.

aa....aa:

Transaction ID

bb....bb:

Number of rows inserted by the INSERT statement that was being executed by the transaction to be recovered#

cc....cc:

Number of rows updated by the UPDATE statement that was being executed by the transaction to be recovered#

dd....dd:

Number of rows deleted by the DELETE statement that was being executed by the transaction to be recovered#

ee....ee:

Number of page requests for the global buffer

ff....ff:

Number of times pages were read

gg....gg:

Total size of pages that were read (KB)

hh....hh:

Number of times data was written to pages

ii....ii:

Total size of pages to which data was written (KB)

#

This includes the number of rows processed by the HADB server for the dictionary table (base table), system table (base table), and location table.

S:

Continues processing.

Action:

This message is output if recovery processing of a transaction took more time than the value specified for the adb_log_rec_msg_interval operand in the server definition.

If processing to recover a transaction took a longer time than you expected, check the information output to this message. Then, consider reducing the amount of information updated in one transaction by, for example, increasing the number of times transactions are committed.