Usage

How to submit the BUILD statement

You submit the BUILD statement only through the batch command facility. You must run the batch command facility in local mode.

When to use BUILD

Use the BUILD utility after loading one or more tables using a phased or stepped LOAD.

You can also use the BUILD utility at any time to reorganize existing indexes on tables in an SQL-defined database.

When not to use BUILD

There is no need to run the BUILD utility if you loaded the table(s) with a complete LOAD. The indexes and constraints have already been built.

If the table is not part of an SQL-defined database, you cannot use the BUILD utility.

When to specify NO VALIDATE

The BUILD utility validates all referential constraints on the tables being worked on, not just the constraints currently being built. If all tables referenced by those specified by table-id have not yet been loaded, defer validation by specifying NO VALIDATE.

Note: For more information and help in deciding which options to specify, see the Database Administration Guide.

Sorting intermediate work files

If you run the load process in steps or phases, use the sort parameters in the SYSPCH file to sort the intermediate files.