Changing Filters to Index Fields

[rstockton]

We are trying to change some Filters to Indexes on an old  large Application Group.  We tried using the Administrator client, but I think there were too many segments and the process failed.  We want our DBA to do this manually but he had the following question. 

Do we have to create single column indexes for each column separately or it?s composite?


Does anyone have any suggestions?



Thanks,

Russell

[Justin Derrick]

Hi Russell.

You can check to see if indexing was successful on the table segments by searching them for indexes:
   db2 describe indexes for table <segment-name> show detail

(Don't forget to connect to the database first with "db2 connect to <database>".)

-JD.

[rstockton]

Thanks Justin.