IBM Support

Manual Datatrim of the REQUEST Table in Octigate database running on Oracle

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

Document Information

Modified date:
17 June 2018

UID

swg21427760