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