analytics/configuration/schemas/logging/informix/LS_dbClean_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. 

drop table COGIPF_ACTION;

drop table COGIPF_USERLOGON;

drop table COGIPF_NATIVEQUERY;

drop table COGIPF_PARAMETER;

drop table COGIPF_RUNJOB;

drop table COGIPF_RUNJOBSTEP;

drop table COGIPF_RUNREPORT;

drop table COGIPF_VIEWREPORT;

drop table COGIPF_EDITQUERY;

drop table COGIPF_AGENTRUN;

drop table COGIPF_AGENTBUILD;

drop table COGIPF_MIGRATION;

drop table COGIPF_THRESHOLD_VIOLATIONS;

drop table COGIPF_POWERPLAY;

drop table COGIPF_POWERPLAY_DIM_USAGE;

drop table COGIPF_POWERPLAY_LEVEL_USAGE;

drop table COGIPF_POWERPLAY_MEASURE_USAGE;

drop table  COGIPF_HUMANTASKSERVICE;

drop table  COGIPF_HUMANTASKSERVICE_DETAIL;

drop table  COGIPF_ANNOTATIONSERVICE;

drop table  COGIPF_MOBILESERVICE;

drop table COGIPF_SYSPROPS;

commit work;