Resolution:


1). If the TIBCO BusinessWorks ProcessMonitor (BWPM) is configured with a partitioned database, to find out if the old data is deleted properly, the database tables can be queried using the following.

a. select PARTITION_NAME, HIGH_VALUE from user_tab_partitions where table_name = 'NJAMS_T_MONITOR_MAIN';

b. select PARTITION_NAME, HIGH_VALUE from user_tab_partitions where table_name = 'NJAMS_T_MONITOR_ATTRIBUTES';

c. select PARTITION_NAME, HIGH_VALUE from user_tab_partitions where table_name = 'NJAMS_T_ACTIVITY_STATISTICS';

d. select PARTITION_NAME, HIGH_VALUE from user_tab_partitions where table_name = 'NJAMS_T_MONITOR_EVENTS';

e. select PARTITION_NAME, HIGH_VALUE from user_tab_partitions where table_name = 'NJAMS_T_MONITOR_BWTRACE';

f. select PARTITION_NAME, HIGH_VALUE from user_tab_partitions where table_name = 'NJAMS_T_MONITOR_TRACKS';

g. select PARTITION_NAME, HIGH_VALUE from user_tab_partitions where table_name = 'NJAMS_T_TRACK_TEMPLATES';

The column HIGH_VALUE shows border between partitions within the table. The column PARTITION_NAME shows the partition name.

2). If BWPM is configured with a non partitioned database, to find out if the old data is deleted properly, the database tables can be queried using the following queries.

a. select count(*), MIN(jobstart) from 'NJAMS_T_MONITOR_MAIN';

b. select count(*), MIN(attribute_ts) from  'NJAMS_T_MONITOR_ATTRIBUTES';

c. select count(*), MIN(track_ts) from 'NJAMS_T_MONITOR_TRACKS';

d. select count(*), MIN(trace_ts) from 'NJAMS_T_MONITOR_BWTRACE';

e. select count(*), MIN(eventdatetime) from 'NJAMS_T_MONITOR_EVENTS';

These queries will result in acquiring the oldest existing time stamp of the particular attribute in the BWPM database.


 

What Queries can be used to find out if old data is deleted properly by NJAMS_DATA_MANAGEMENT?