13.5.5 Error recovery

Trigger source code is stored in a data dictionary RDAREA, and trigger SQL objects are stored in a data dictionary LOB RDAREA. The log collection mode for the data dictionary RDAREA is ALL, and the log collection mode for the data dictionary LOB RDAREA is PARTIAL. Therefore, if an error occurs, the source code can be recovered to its most recent status from the backup and the log. The SQL objects, however, can only be recovered to their status at the time of the most recent backup. Therefore, the following considerations are important: