Oh yeah I am off. Aman is driving me nuts with all of his oracle stuff.
Jeremy Schleicher
ERP Database Administrator
Florida State University
-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x88016346.[Email address protected]
Sent: Wednesday, November 22, 2006 8:44 AM
To: LazyDBA Discussion
Subject: RE: What are these indexes?
Well, well, well!
It's Jeremy! Hehe. How have you been? Are you off tomorrow and
Friday! I am! BTW, what is Aman doing these days? Hehe.
It's Fridayyyyyyyy! Partyyyyyyy!
Have a great Day, Thanksgiving Day, and Weekend!
Please take a few minutes to provide feedback on the quality of service
you received. The Department of Education values your feedback as a
customer. Commissioner John L. Winn is committed to continuously
assessing and improving the level and quality of services provided to
you by Department staff. Simply use the link below. Thank you in
advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Schleicher Jeremy D.
[mailto:db2udbdba-ezmlmshield-x57751711.[Email address protected]
Sent: Wednesday, November 22, 2006 8:42 AM
To: LazyDBA Discussion
Subject: RE: What are these indexes?
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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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