Hi, I think your looking at your table id and partition number. Maybe
db2inspect to isolate the index. BOL

-----Original Message-----
From: Angel victoria
[mailto:db2udbdba-ezmlmshield-x89082222.[Email address protected]
Sent: Friday, June 30, 2006 11:47 AM
To: LazyDBA Discussion
Subject: Re: How to interpret this message ?


----- 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


---------------------------------------------------------------------
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