Print Page - Changing Filters to Index Fields

Title: Changing Filters to Index Fields
Post by: rstockton on October 23, 2013, 04:38:30 PM

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

Title: Re: Changing Filters to Index Fields
Post by: Justin Derrick on October 23, 2013, 04:59:33 PM

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.

Title: Re: Changing Filters to Index Fields
Post by: rstockton on October 23, 2013, 07:55:54 PM

Thanks Justin.

OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: rstockton on October 23, 2013, 04:38:30 PM