Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see REORG PLUS for DB2 13.1.

Recoverability of the reorganized table space

If you specify COPY NO (or do not specify a COPY option), you must take some action to ensure that Db2 can recover the table space, if necessary, after the reorganization.

For example, you can

  • Create an image copy by running COPY PLUS or the IBM Db2 COPY utility.
  • Execute DSN1COPY or any other suitable substitute that your system provides.

If you use the table space as a read-only table space, specify COPY NO or specify COPY YES REGISTER NONE and DD DUMMY for the copy data sets.

Related topics

Recoverability of the reorganized table space 

Operational-considerations

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

REORG PLUS for DB2 11.2