LOAD LOG on an XML table space

An XML table space that is defined with LOG YES or LOG NO affects logging during the load of an XML column.

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

Table 1. LOAD LOG impact for an XML table space
LOAD LOG keyword XML table space LOG attribute What is logged XML table space status after utility completes
LOG YES LOG YES Data No pending status
LOG YES LOG NO Nothing No pending status
LOG NO LOG YES Nothing COPY-Pending
LOG NO LOG NO Nothing ICOPY-Pending