This is on Version 8.1 and 8.2 (various fixlevels) on Sun Solaris …

I have this table with about 350 mil records and 3 mil records get LOADed every weekend. The indexing mode is INCREMENTAL.

If the LOAD fails in the BUILD phase (eg. Tempspace disk full) and then a LOAD TERMINATE is issued, what will the state of the indexes be? Will they be marked invalid - requiring a full rebuild on the next table access or will they go back to the original valid state?

I’m preparing a support document and want to make sure I cover this bit, so that the operators know what to expect after a LOAD TERMINATE.

For certain reasons, I do not want the load to be RESTARTed

Oh, BTW, how do you identify the state of the index when the database is still online?


Thanks in advance for any input

Sathyaram

After a LOAD TERMINATE, the indexes will be marked invalid.

Use INSPECT to identify the state of the index.
- db2 "inspect check table name <table_name> for error state all results keep inspect.out"
Format the out file (file will be in DIAGPATH)
- db2inspf inspect.out inspect.fmt
- Look for the lines
Warning: Object is known to be in error state x400.
Warning: Index object is in invalid state, requires index be re-built.

Renga

Thank You Renga ,,, Makes sense

Sathyaram