----- Original Message -----
From: Angel victoria
To: LazyDBA Discussion
Sent: Thursday, June 29, 2006 9:29 AM
Subject: How to interpret this message ?


Hi Listers,

I am getting the following messages in db2diag.log:

String Title:Failed to rebuild indexes PID:6176824 Node:002Table(23:4)=DB2SOR .TRFC_FCTD_CLNT
The above table is partitioned (4) and has 12 indexes. Does the above message
give a clue as to which index(es) need to be rebuilt or does it imply ALL
indexes to be rebuilt ? What does "Table(23:4)" indicate ? Table is huge with
486+ million rows, so I'd be glad if all indexes don't need to be rebuilt.
Luckily its in development.

Platform: UDB V7.2 AIX 5.1

Thanks,
Angel Victoria

DB2 & UDB email list listserv db2-l LazyDBA home page