The Database Journaling Summary section of the Component report provides information about the journal activity on the system.
This information is helpful in understanding the trade-offs between the following:
The Database Journaling section summarizes the journaling activity resulting from user-initiated activities and from system-managed access-path protection (SMAPP) support. This includes the following information:
The Extended Database Journaling Summary subsection shows information about counters in the QAPMJOBMI file during the specified collection interval.
Component Report 10/02/03 17:12:15 Database Journaling Summary Page 351 Perf data from 14:00 o 16:00 at 1 min Member . . . : Q275140000 Model/Serial . : 890/10-3907F Main storage . . : 56.4 GB Started . . . . : 10/02/03 14:00:00 Library . . : PTLIBV5R3 System name . . :ABSYSTEM Version/Release : 5/ 3.0 Stopped . . . . : 10/02/03 16:00:00 Partition ID : 003 Feature Code . :7427-2498-7427 Int Threshold . : .00 % Virtual Processors: 4 Processor Units : 4.0 ------- Journal Operations ------ --- Journal Deposits --- Bundle Bundle --Exposed AP -- --Est Exposr -- Itv User User System System User System System Writes Writes System Not Curr AP Not SMAPP End Starts Stops Starts Stops Total Total ToUser User System Jrnld Jrnld System Jrnld ReTune ----- ------ ------ ------ ------ -------- ------- ------- ------- -------- ------ ------ ------ ------ ------ 14:00 0 0 0 0 1143 179 168 176 0 6 52 57 4,372 0 14:01 11 1 0 0 1757 251 54 355 64 6 51 39 4,309 0 14:02 8 0 0 0 2418 217 57 426 52 9 57 57 6,193 0 14:03 1 1 0 0 2726 136 130 549 0 6 54 39 4,310 0 14:04 0 0 0 0 2346 425 353 325 20 10 57 57 6,799 0 14:05 6 0 0 0 534 197 6 67 56 10 57 57 6,799 0 14:06 3 2 2 0 579 231 60 98 38 8 52 27 4,310 1 14:07 7 0 0 0 1635 511 156 252 80 8 55 37 4,373 0 14:08 0 0 0 0 1161 252 70 233 28 8 55 27 4,310 0 14:09 8 1 0 0 3425 682 152 641 141 12 47 27 6,736 0 14:10 4 0 0 0 3861 329 73 697 42 12 50 37 6,799 0 14:11 1 0 0 0 5626 359 106 1017 42 8 50 37 4,373 1 14:12 0 1 0 0 3718 282 50 680 42 12 50 37 6,799 0 14:13 0 0 0 0 5590 296 59 980 44 8 47 27 4,310 0 14:14 0 0 0 0 4581 168 122 914 10 8 47 27 4,310 0 14:15 1 1 0 0 3320 162 161 549 0 12 50 37 6,799 0 14:16 0 0 0 0 5741 33 28 1743 0 12 64 37 6,800 0 14:17 1 1 0 0 6735 22 16 2565 0 8 50 27 4,310 0 Itv End -- Interval end time (hour and minute) User Starts -- Start journal operations initiated by user User Stops -- Stop journal operations initiated by user System Starts -- Start journal operations initiated by system System Stops -- Stop journal operations initiated by system User Total -- Journal deposits resulting from user journaled objects System Total -- Journal deposits resulting from system journaled objects (total) System ToUser -- Journal deposits resulting from system journaled objects to user created journals Bundle Writes User -- Bundle writes to user created journals Bundle Writes System -- Bundle writes to internal system journals Exposed AP System Jrnld -- Exposed access paths currently being journaled by the system Exposed AP Not Jrnld -- Exposed access paths currently not being journaled Est Exposr Curr System -- System estimated access path recovery time exposure in minutes Est Exposr AP Not Jrnld -- System estimated access path recovery time exposure in minutes if no access paths were being journaled by the system SMAPP ReTune -- System Managed Access Path Protection tuning adjustments . . . Component Report 10/02/03 17:12:15 Extended Database Journaling Summary Page 355 Perf data from 14:00 to 16:00 at 1 min Member . . . : Q275140000 Model/Serial . : 890/10-3907F Main storage . . : 56.4 GB Started . . . . : 10/02/03 14:00:00 Library . . : PTLIBV5R3 System name . . :ABSYSTEM Version/Release : 5/ 3.0 Stopped . . . . : 10/02/03 16:00:00 Partition ID : 003 Feature Code . :7427-2498-7427 Int Threshold . : .00 % Virtual Processors: 4 Processor Units : 4.0 --------- Journal Operations -------- ---------- Journal Deposits --------- Bundle Bundle Itv Commit Decommit Physical Non SMAPP SMAPP Perm Transient Wait Wait End Ops Ops Writes SMAPP User System Size Size Pct Count ----- ----------- ----------- ----------- ----------- ----------- ----------- ----------- ----------- ------ --------- 14:00 316 0 292 1142 168 11 5843 7971 .00 157 14:01 382 0 452 1757 54 197 4054 3120 .00 427 14:02 546 1 515 2418 57 160 5050 3436 .00 531 14:03 655 0 637 2726 130 6 7143 6626 .00 575 14:04 643 2 577 2346 353 72 8488 17153 .00 361 14:05 68 0 127 542 6 191 2872 719 .00 112 14:06 123 0 177 579 60 171 2656 2552 .00 127 Itv End -- Interval end time (hour and minute) Commit Ops -- Commit operations performed. Includes application and system-provided referential integrity commits Decommit Ops -- Decommit operations performed. Includes application and system-provided referential integrity decommits Physical Writes -- Physical journal write operations to disk Non SMAPP -- Journal deposits not directly related to SMAPP (System Managed Access Path Protection) SMAPP User -- SMAPP-induced journal entries deposited in user-provided journals SMAPP System -- SMAPP-induced journal entries deposited in system-provided (default) journals Perm Size -- Kilobytes placed within the permanent area; these are traditional journal entries which can be retrieved and displayed Transient Size -- Kilobytes placed within the journal transient area; these are hidden journal entries produced by the system Bundle Wait Pct -- Percentage of time (relative to the interval elapsed time) spent waiting for journal bundles to be written to disk Bundle Wait Count -- Total number of times the tasks and jobs waited for journal bundles to be written to disk