Troubleshooting
Problem
How can the REQUEST table be cleared of records from the OCTIGATE database, which is running on Oracle?
Symptom
The table REQUEST can be manually datatrimmed.
Connect to the ITCAM database.
Here are 2 options:
- If the data in the table is not important at all, then a simple truncate command will be sufficient.
- truncate table REQUEST ;
commit ;
- If 7 days of data in the table is to be retained. then execute the following:
- create table REQUEST_TMP as select * from REQUEST where end_time > sysdate - 7 ;
truncate table REQUEST ;
insert into REQUEST select * from REQUEST_TMP ;
commit;
[{"Product":{"code":"SSDTFJ","label":"Tivoli Composite Application Manager for Application Diagnostics"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"ITCAM for APPLICATION DIAGNOSTICS Managing Server","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Product Synonym
ITCAM ITCAM4AD ITCAMfAD
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21427760