Skip to main content

Online region hung transaction

  • Nov 13, 2020 5:31 PM UTC
  • 2 replies
  • 9 views

Hi,

Is there a way to set email alert mechanism if there are any long running hung transcations in Online region. Because everytime we have to manually go to Online region-> SEP table.

Or in which keyword from the console log we can use it to configure monitoring 

 


#EnterpriseServer

2 replies

  • Mar 23, 2021 7:14 PM UTC

Hi,

Is there a way to set email alert mechanism if there are any long running hung transcations in Online region. Because everytime we have to manually go to Online region-> SEP table.

Or in which keyword from the console log we can use it to configure monitoring 

 


#EnterpriseServer

Hello Noël,

It's quite difficult to catch such behavior.

Only  way i can drive you in, is to set a Timeout on the transaction definition  that trigger SQL statement.

If Timeout is reached , you will get a warning message in  Console.log  you can catch for monitoring.

 

Kind Regards.


  • May 7, 2021 12:39 PM UTC

Hello Noël,

It's quite difficult to catch such behavior.

Only  way i can drive you in, is to set a Timeout on the transaction definition  that trigger SQL statement.

If Timeout is reached , you will get a warning message in  Console.log  you can catch for monitoring.

 

Kind Regards.

Hi,

Thanks for your response.

Should i use the castran command to set the timeout value or something else? Need your help