Looks like it is table 23 on partition 2, I think that the indexes will
be rebuilt on the next access of those indexes but if that fails you
will need to drop and recreate them.

Jeremy Schleicher
ERP Database Administrator
Florida State University

-----Original Message-----
From: Angel victoria
[mailto:db2udbdba-ezmlmshield-x20234090.[Email address protected]
Sent: Thursday, June 29, 2006 10:29 AM
To: LazyDBA Discussion
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


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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