The name is unique to your system. Their names are based on the time
the index was created. You will have to generate the ddl yourself to
determine what the columns are.

Jeremy Schleicher
ERP Database Administrator
Florida State University

-----Original Message-----
From: Andrew G Mclaughlin
[mailto:db2udbdba-ezmlmshield-x45581899.[Email address protected]
Sent: Wednesday, November 22, 2006 8:39 AM
To: LazyDBA Discussion
Subject: What are these indexes?


I am running DB2 V8 fp12 and I see indexes with names such as:
SQL050510111916340 in SYSCAT.INDEXES. I understand they must be system
generated, but can anyone tell me what they are and why they are
created?
I am trying to find an index to sort on for reorg, but it won't allow me
to
reorg on these indexes.

Thanks,
Andy



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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