DX Application Performance Management

Hi,

Any idea how to disable a Monitor which does not exist any more?

When I am trying to disable from GUI I am getting connection error (because the ip of the monitor does not exist any more..).

Hi,

You can execute below sql against cemdb

update ts_monitors set ts_enabled=false 

Regards,

Mukesh Singh

mukesh_singh

Can you also mark my feedback (solution) as "Correct Answer"?

MelissaPotvin Hallett_German Amir-Mushtaq

hi Manish, seems only one answer can be marked as the correct one.  answer can be unmarked as correct and new answer marked as correct but i'd rather the person that marked it as such make that decision. another thing is to mark as helpful which might satisfy the need here. 

Hi Melissa:

     I believe that both solutions are correct depending on the database and APM version Will let it stand.

Thanks

Hal German

mukesh_singh

I have a same scenario. I am told by the DBA that the value for the table/filed is a 0/1 and not enable/disable. Here is my exchange with the DBA internally on IM

[3/29/2018 2:25 PM] Parikh, Manish A (US):

it's just looking up a table value, thought that would be pretty simple

[3/29/2018 2:25 PM] Sreeram, Madhu L (US):

the field is a number type though ...it has a 0/1 values

[3/29/2018 2:26 PM] Parikh, Manish A (US):

so I assume a 0 = false and a 1 = true ?

[3/29/2018 2:26 PM] Sreeram, Madhu L (US):

I wouldn't know that. The vendor should tell us.

[3/29/2018 2:27 PM] Parikh, Manish A (US):

but you can tell what the existing value is, right?

[3/29/2018 2:27 PM] Sreeram, Madhu L (US):

it is up to the app to interpret  the 0 or 1 as succ/fail or otherwise. I see two distinct values  - 0,1

[3/29/2018 2:28 PM] Parikh, Manish A (US):

the vendor asked me to do the following w/ DBA's help:

update ts_monitors set ts_enabled=false;  (can add a where clause ts-id=)

[3/29/2018 2:28 PM] Sreeram, Madhu L (US):

the value for ts-id isn't given , you need to ask the vendor

[3/29/2018 2:29 PM] Parikh, Manish A (US):

can you run that  "update ts_monitors set ts_enabled=false" against that table/field?

[3/29/2018 2:29 PM] Sreeram, Madhu L (US):

that will just fail. because "false" is not a number

[3/29/2018 2:30 PM] Parikh, Manish A (US):

so can we try the value 0

[3/29/2018 2:32 PM] Sreeram, Madhu L (US):

I don't recommend unless we are sure  - this will change values for all rows (without the where clause)

[3/29/2018 2:33 PM] Sreeram, Madhu L (US):

my suggestion is to get clarification from the vendor - whether it should be a 0 or 1, and also the value for ts_id  - unless they want us to change for all rows

---------------------------------------------------------------------------------------------------------

Thanks for any/all assistance in advance.

Manish

I've opened up a CA Support Case 00999305

the following procedure for me was applied in order to 'disable' the TIM Monitor on CEM GUI....

  1  select ts_id||'            '|| TS_IP_ADDRESS ||'   '|| TS_DOMAIN_STATUS_NAME||'    '|| TS_MTP_ENABLED||'   '|| TS_ENABLED

  2  from  apmmgr.ts_monitors

  3  where (lower(ts_name) like '%austin%' or lower(ts_name) like '%nashua%')

  4* and ts_enabled=1

SQL> /

TS_ID||''||TS_IP_ADDRESS||''||TS_DOMAIN_STATUS_NAME||''||TS_MTP_ENABLED||''||TS_ENABLED

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

700000000000000647              171739425       Normal (updated 2018-01-24 17:00:25)    0       1

700000000000000646              171747617       Normal (updated 2018-01-24 17:00:23)    0       1

2 rows selected.

SQL> update apmmgr.ts_monitors set ts_enabled=0 where (lower(ts_name) like '%austin%' or lower(ts_name) like '%nashua%') and ts_enabled=1

  2  ;

2 rows updated.

Commit;