Re: SQL Indexes

On 7/25/2018 2:42 PM, Don Wereschuk wrote:

I have in my library of data files some SQL indexes on some physical file that are named using the first 5 characters of the Physical file and then a sequential number starting with 00001. For example ABCDE00001, ABCDE00002 where the Physical file name is ABCDEFGHI. Does anyone know where or how or why these Indexes are created.

Object auditing will tell you who created them, and when. But it can't
go into the past; that only helps going forward.

Names like this are how Db2 conflates a long name like
'ABCDEFGHI_KEYED_BY_CUSTOMER_NAME' into a 10 character long 'system
name', so it might be useful to look at them from an SQL perspective.
Yes, you can do a CREATE INDEX ABCDEFGHI_keyed_by_customer_name and it's
a perfectly legitimate table name, if a bit whimsical :-/

Fire up Web Navigator http://my.ibmi.tld:2001 and drill down through
Databases > system > Schemas > library > Indexes. If your library isn't
in the list of schemas displayed, click Schemas, then click the drop
down 'Actions' and choose Select Schemas to display.