LOAD LOG on a LOB table space

A LOB table space that is defined with LOG YES or LOG NO affects logging during the load of a LOB column.

The following table shows the logging output and LOB table space effect, if any.

Table 1. LOAD LOG and REORG LOG impact for a LOB table space
LOAD LOG/ REORG LOG keyword LOB table space LOG attribute What is logged LOB table space status after utility completes
LOG YES LOG YES Control information and LOB data No pending status
LOG YES LOG NO Control information No pending status
LOG NO LOG YES Nothing COPY-Pending1
LOG NO LOG NO Nothing COPY-Pending1
Note:
  1. REORG LOG NO of a LOB table space requires SHRLEVEL REFERENCE, which requires that an inline copy be taken during the REORG. This means that you never set COPY-pending for REORG of LOB table spaces under any circumstances