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.
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:
|