Log activity
DB2 logs changes made to data by the applications and other significant subsystem events, as they occur, to provide data recoverability. The characteristics of the workload have a direct effect on log write performance. Long-running tasks that commit infrequently incur a lot more data to write at commit than a typical transaction. These tasks can cause subsystem impact because of the excess storage consumption, locking contention, resources that may be consumed for a rollback, and longer commit times.
The cost of reading the log directly ...
Get Subsystem and Transaction Monitoring and Tuning with DB2 11 for z/OS now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
