Created On:  25 February 2011


After running the restore indexes option on a DB2 repository for some time, the following message pops up:

There were errors during indexes restoration.
See the activity log for details.

In the activity log, the following is found:

Index_Name on Table - [IBM][CLI Driver][DB2/AIX64] SQL0968C The file system is full.  SQLSTATE=57011


The TEMP file space for the DB must be increased by the DBA.  Once this is done, drop the indexes.  Messages saying indexes don't exist will be OK, those are the ones that didn't get created before the DB ran out of space on the TEMP file space.  Run the restore indexes process again.
Incident #2482391