DSNU342I csect-name ERROR LOADING INDEX, ERROR = Xreason-code, INDEX = index-name
Explanation
The LOAD, REORG or REBUILD INDEX utility encountered a processing error, which it could not correct, while extending the index identified by index-name.
System action
The building of index entries for the indicated index is not completed. An SVC dump of the database services address space is requested for diagnostic purposes. The extension of other indexes associated with the tables being loaded is attempted. Any subsequent attempt to use the index directly or indirectly will cause the invoker to abend.
Operator response
The table space in question might need to be stopped and started for utility-only processing to inhibit attempted application use of the defective index.
System programmer response
If the index is used by more than one application, applications that either insert rows into, or delete rows from, the indexed table or use the index to access rows must be inhibited from executing. One way to accomplish this is to place the table space in question under utility-only processing control by using the START DATABASE and STOP DATABASE commands until the REBUILD INDEX utility is executed.
Alternatively, the index can be dropped. Application execution can then proceed, and the index can be created again (unless the index was the partitioning index).
If you suspect an error in Db2, you might need to report the problem. For information about identifying and reporting the problem, see Collecting diagnostic data.
User response
If the indexed table is used by more than one application, the system programmer should be informed so that applications that insert rows into, or delete rows from, the table or use the index directly are inhibited until corrective action is taken.
Normal corrective action would be to use the REBUILD INDEX utility option to reconstruct the index after the processing problem identified by the reason code has been resolved. Alternatively, the index can be dropped and then created again, unless the index in question is the partitioning index.
Severity
8 (error)