54
« on: January 04, 2011, 11:16:07 AM »
There is a way that you can change the filter field to an index at the db2 level by modifying the ARSAGFLD table, then create the index. Bear in mind all the usual database backup precautions, etc and that this is not supported by IBM.
here is a quick rundown of the process from memory, you should verify in a test environment and confirm that all you are choosing the correct values, etc before boldly jumping in.
Ensure that DB2 has been stopped and started properly. Make sure the OnDemand application is not running during this process.
DB2 ?SELECT name,agid,agid_name FROM arsag?
DB2 ?UPDATE ARSAGFLD SET MASK=2 WHERE AGID=(application group id AND NAME=?? name of field to change to an index?
DB2 ?CREATE INDEX (table name index) on (table name) (name of field to change to an index)?
DB2 CONNECT RESET
DB2 TERMINATE
Once finished and OnDemand has started, run the database reorg ;
ARSDB ?m