analytics/configuration/schemas/logging/informix/LS_dbCleanIndexes_informix.sql

-- Licensed Materials - Property of IBM
-- IBM Cognos Products: ccllogging
-- (C) Copyright IBM Corp. 2005, 2014
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 

-- Need to replace the "IPFSCRIPTIDX" with what you have specified in Cognos Configuration advanced property parameter. 

drop index IPFSCRIPTIDX_COGIPF_EDTQRY_IDX;

drop index IPFSCRIPTIDX_COGIPF_RUNREP_IDX;

drop index IPFSCRIPTIDX_COGIPF_NATQRY_IDX;

drop index IPFSCRIPTIDX_COGIPF_RUNJOB_IDX;

drop index IPFSCRIPTIDX_COGIPF_RUNJSTP_IDX;

drop index IPFSCRIPTIDX_COGIPF_MOBILE_IDX;

commit work;