These check boxes display the LOB options currently
selected for the column of LOB data types. To change the LOB options,
select or clear the following check boxes:
- Logged
- Specifies that changes made to the column be written to the log.
The data in such columns is then recoverable with database utilities, such as
RESTORE DATABASE. The implication of not logging is that during a
roll-forward operation after a backup or load operation, the LOB values that
would have had log records replayed during the roll-forward are replaced by
zeroes. During crash recovery, all committed changes and changes rolled
back will reflect the expected results.
| Note: | LOBs greater than 1 GB cannot be logged, and LOBs greater than 10 MB should
not be logged.
|
- Compact
- Specifies that the values in the LOB column should take up minimal disk
space (free any extra disk pages in the last group used by the LOB value),
rather than leave any left-over space at the end of the LOB storage area that
might facilitate subsequent append operations.
| Note: | Storing data in this way can cause a performance penalty in any append
(length-increasing) operations on the column.
|
These check boxes are available only if you specified a data type of BLOB,
CLOB, DBCLOB, or a distinct type with any of these as source types in the
Data type box.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]