epcim
10/20/2015 - 1:33 PM

ibm-itm-backupTEPSdb.howto.md

ITM backup TEPS db

/tsmmon/ITM/bin#  ./CandleExecute cq "runscript.sh migrate-export"

clean agentbuilder data

https://www.ibm.com/developerworks/mydeveloperworks/blogs/0587adbc-8477-431f-8c68-9226adea11ed/entry/removing_agent_builder_application_support_data_from_the_teps_database10?lang=en

Template

KFWWORKSPACELINK        APPLICATIONTAG       DELETE FROM KFWWORKSPACELINK WHERE APPLICATIONTAG='K25';
KFWWORKSPACE            WSGROUPID            DELETE FROM KFWWORKSPACE WHERE WSGROUPID LIKE 'zk25%';
KFWPRESENTATION         OBJECTID             DELETE FROM KFWPRESENTATION WHERE OBJECTID = 'k25';     
KFWPRESDEF              PRESENTATIONID       DELETE FROM KFWPRESDEF WHERE PRESENTATIONID ='WORKSPACE~REPORT~zk25.DC_obj_status';                THERE NEEDS TO BE A DELETE STATEMENT FOR EACH ONE
KFWFOUNDODI             APPL                 DELETE FROM KFWFOUNDODI WHERE APPL='K25';
KFWPARMA                TABLENAME            DELETE FROM KFWPARMA WHERE TABLENAME LIKE 'K25%';
KFWEDGE                 CHILD                DELETE FROM KFWEDGE WHERE CHILD LIKE '%zk25';
KFWMOBJASSIGNED         ID                   DELETE FROM KFWMOBJASSIGNED WHERE ID LIKE '%zk25%';
KFWMOBJPROP             ID                   DELETE FROM KFWMOBJPROP WHERE ID LIKE '%zk25%';
KFWMOBJ                 TEMPLATE             DELETE FROM KFWMOBJ WHERE TEMPLATE LIKE 'zk25%';
KFWTMPLSIT              TEMPLATE             DELETE FROM KFWTMPLSIT WHERE TEMPLATE LIKE 'zk03%';
KFWTMPLSTA              TEMPLATE             DELETE FROM KFWTMPLSTA WHERE TEMPLATE LIKE 'zk25%';   
KFWTMPL                 NAME                 DELETE FROM KFWTMPL WHERE NAME LIKE 'zk25%';
KFWSEEDLEVEL            FILENAME             DELETE FROM KFWSEEDLEVEL WHERE FILENAME='k25%';
KFWQUERY                APPL                 DELETE FROM KFWQUERY WHERE APPL='K25';

For available workspace

db2 "DELETE FROM KFWWORKSPACELINK WHERE APPLICATIONTAG='K11'"

db2 "DELETE FROM KFWWORKSPACE WHERE WSGROUPID LIKE 'zk11.avail%'"

db2 "DELETE FROM KFWPRESENTATION WHERE OBJECTID = 'k11'"
db2 "DELETE FROM KFWPRESDEF WHERE PRESENTATIONID ='WORKSPACE~REPORT~zk11.DC_obj_status'"
db2 "DELETE FROM KFWFOUNDODI WHERE APPL='K11'"

db2 "DELETE FROM KFWPARMA WHERE TABLENAME LIKE 'K11.avail%'"

db2 "DELETE FROM KFWEDGE WHERE CHILD LIKE '%zk11'"

db2 "DELETE FROM KFWMOBJASSIGNED WHERE ID LIKE '%zk11.avail%'"
db2 "DELETE FROM KFWMOBJPROP WHERE ID LIKE '%zk11.avail%'"
db2 "DELETE FROM KFWMOBJ WHERE TEMPLATE LIKE 'zk11.avail%'"
db2 "DELETE FROM KFWTMPLSIT WHERE TEMPLATE LIKE 'zk11%'"
db2 "DELETE FROM KFWTMPLSTA WHERE TEMPLATE LIKE 'zk11.avail%'"
db2 "DELETE FROM KFWTMPL WHERE NAME LIKE 'zk11.avail%'"
db2 "DELETE FROM KFWSEEDLEVEL WHERE FILENAME='k11.avail%'"

db2 "DELETE FROM KFWQUERY WHERE APPL='K11.avail'"