LOB Recovery
There are special recovery considerations for LOBs due to the way LOBs (Large Objects) are stored and are maintained.
Logging
There is an option of whether or not to log changes to LOB columns. This option is specified on the creation of the LOB table space by using the LOG option (LOG YES is the default). LOBs that are larger than 1GB cannot be logged. If you have a LOB defined as LOG NO and then decided to ALTER it to be LOG YES, then the LOB will be placed in Copy Pending status. For LOBs that are defined as LOG NO, the force-at-commit protocol will ensure that the LOB values persist once committed. Even with LOG NO, the changes to the system pages and the auxiliary indexes are logged.
Point-in-Time Recovery
Even though there ...
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.
