Versions Compared

Old Version 6

changes.mady.by.user IDERA

Saved on

compared with

New Version 7

changes.mady.by.user IDERA

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 
  • The process above needs to be repeated for the Network performance tables.  Replace DATE below with the same target date as above in the format YYYY-MM-DD.
 
Code Block
languagesql
select min(id) from net_device_perf_sample where TO_CHAR(sample_time,'YYYY-MM-DD') - 'DATE';
   
  • Use the ID from the previous command in place of ID in the following commands. 
 
Code Block
languagesql
delete from net_device_perf_ping where sample_id < ID; commit;
delete from net_device_perf_port where sample_id < ID; commit;
 
 
  • The process above needs to be repeated for the retained performance tables.  Replace DATE below with the same target date as above in the format YYYY-MM-DD.
 
Code Block
languagesql
delete from erdc_decimal_data where TO_CHAR(sample_timesampletime,'YYYY-MM-DD') - 'DATE';
delete from erdc_int_data where TO_CHAR(sample_timesampletime,'YYYY-MM-DD') - 'DATE';
delete from erdc_string_data where TO_CHAR(sample_timesampletime,'YYYY-MM-DD') - 'DATE';
delete from ranged_object_value where TO_CHAR(sample_time,'YYYY-MM-DD') - 'DATE';