It's not possible to do this from within the SQL Analysis module currently. There is no tool to manage the repository database, but you can delete the repository information manually.
To delete a collection, perform the following steps:
1.
Issue the following SELECT statement to determine the CKEY for the DELETE statements that follow:
Â
SELECT SC_COL_CKEY FROM QUEST.SC_COLLECTION WHERE SC_COL_START = <start_time> and SC_COL_NAME = <collection_name>;
(Replace <start_time> and <collection_name> with the appropriate values displayed on the collections window.)
Â
2.
Take the value returned from the above SELECT statement and replace the <ckey> in the following statements:
Â
-- Disable the auto commit option.
DELETE FROM QUEST.SC_PATTERNS WHERE SC_PTRN_CKEY = <ckey>;
DELETE FROM QUEST.SC_DEADLOCKS WHERE SC_DL_CKEY = <ckey>;
DELETE FROM QUEST.SC_DLDETAIL WHERE SC_DLDET_CKEY = <ckey>;
DELETE FROM QUEST.SC_COLINFO WHERE SC_CINFO_CKEY = <ckey>;
DELETE FROM QUEST.SC_SUMMARY WHERE SC_SUMM_CKEY = <ckey>;
DELETE FROM QUEST.SC_COLLECTION WHERE SC_COL_CKEY = <ckey>;
DELETE FROM QUEST.SC_WORKLOAD WHERE SC_WLOAD_CKEY = <ckey>;
DELETE FROM QUEST.SC_CONNECTIONS WHERE SC_CONNS_CKEY = <ckey>;
DELETE FROM QUEST.SC_TRANSACTIONS WHERE SC_TRANS_CKEY = <ckey>;
DELETE FROM QUEST.SC_LITERALS WHERE SC_LITS_CKEY = <ckey>;
DELETE FROM QUEST.SC_STATISTICS WHERE SC_STATS_CKEY = <ckey>;
COMMIT;
Â
Â
Â
STATUS:
Enhancement request CR 45058 has been submitted to Development for consideration in a future release of Toad for DB2.
