DOMINO AND DB2

Controlling the NSF data in DB2
You can fine-tune the NSF data in IBM® DB2 Universal Database™ Enterprise Server Edition by reorganizing the data stored in tables in your NSF database. You can also run statistics to gather information about a database table so that the DB2 optimizer can make good decisions. The DB2 optimizer generates the Access Plan for resolving SQL statements.

Note Always coordinate with the Database Administrator as to when you should perform a REORG. REORGs are not typically done during business hours.

Reorganizing the data in a table

When you reorganize the data in a table, you are defragmenting that data.

1. Open the DB2 Control Center.

2. Click All Databases, and then locate the initial DB2 database you created. If you did not change the default database name, the name is DOMINO.

3. Open the database, and then click Tables.

4. Select the table you are going to reorganize, and then right click the mouse.

5. Click Reorganize. The Reorganize Table dialog box appears. Use this dialog box to schedule the reorganization.


6. For optimum performance, choose these settings: Note For information about the fields on the Reorganize Tables dialog box, see the DB2 Information Center at http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/db2idxA.htm.

7. Click OK.

See also