Minimizing Outages

There is an option in DB2 that will issue a warning message when a unit of work has written more log records than a defined threshold without a commit. This will let you identify those applications that would require a long backout and/or recovery in case of system or application failure. This is set through the URCHKTH DSNZPARM. In order to minimize the amount of time it takes to recover from a system failure, we need to ensure that our applications are taking frequent commits.

Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide 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.