Removing various pending states from LOB and XML table spaces

You can remove various pending states from a LOB table space or an XML table space by using a collection of utilities in a specific order.

To remove pending states from a LOB table space or an XML table space:

1. Use the REORG TABLESPACE utility to remove the REORP status.
2. If the table space status is auxiliary CHECK-pending status:
   1. Use CHECK LOB for all associated LOB table spaces.
   2. Use CHECK INDEX for all LOB indexes, as well as the document ID, node ID, and XML indexes.
3. Use the CHECK DATA utility to remove the CHECK-pending status.