Making a table in no data movement mode fully accessible - IBM DB2 9.7 for Linux, UNIX, and Windows

Use the Set Integrity window to make a table in no data movement mode fully accessible.

Before you begin

To bring a table from no data movement mode to full access mode, you need the following authorities:

DBADM authority
CONTROL privilege on the tables that are moving from no data movement to full access

About this task

Note: Use these steps only if the table you are working with is in no data movement mode. If the table you are working with is in Set Integrity Pending state, you must turn on constraint checking. See Checking for constraint violations using SET INTEGRITY.

Procedure

To make a table in no data movement mode fully accessible using the Control Center:
1. Open the Set Integrity window: From the Control Center, expand the object tree until you find the Tables folder. Click the Tables folder. Any existing tables are displayed in the pane on the right side of the window. Right-click the table you want and select Set Integrity from the pop-up menu. The Set Integrity window opens.
2. Review the Current integrity status of the table you are working with.
3. Select the Full Access radio button.
To make a table in no data movement mode fully accessible using the command line, use the SET INTEGRITY statement.