There are three database update log acquisition methods:
There are two ways to specify the database update log acquisition method:
Table 7-2 Database update log acquisition method for user LOB RDAREAs depending on a specification in the client environment definition
Client environment definition PDDBLOG | RECOVERY operand value in CREATE TABLE | ||
---|---|---|---|
ALL | PARTIAL | NO | |
ALL | ALL | PARTIAL | NO |
NO | NO | NO | NO |
For example, if PARTIAL is specified in the RECOVERY operand of CREATE TABLE and the log acquisition method is set to NO in the client environment definition, then NO (no-log mode) is set for the user LOB RDAREAs.