DB2 Cancun Release: New time-spent monitor elements provide more details for backup operations and index creation

You can use new time-spent monitor elements to monitor the time that the database manager spends on backup operations and index creation.

The time-spent monitor elements for backup times are reported in the system dimension. The time-spent monitor elements for index creation, which can occur during section execution, are reported in both the system and activity dimensions.

The total_backup_time element represents the total elapsed time that was spent doing online backups. The total_backup_proc_time element represents the total amount of non-wait processing time that was spent performing online backups. The parent element of the total_backup_time and total_backup_proc_time elements is the total_rqst_time element. The total_backups element represents the total number of online backups that were completed.

The total_index_build_time element represents the total elapsed time that was spent building indexes due to index creation, re-creation, or rebuild. In the system dimension, the parent element of the total_index_build_time element is the total_rqst_time element. In the activity dimension, the parent element of the total_index_build_time element is the stmt_exec_time element. The total_index_build_proc_time element represents the total amount of non-wait processing time that was spent rebuilding indexes due to index creation, re-creation, or rebuild. In the system dimension, the parent element of the total_index_build_proc_time element is the total_rqst_time element. In the activity dimension, the parent element of the total_index_build_proc_time element is the stmt_exec_time element. The total_indexes_built element represents the total number of indexes that were built.