search cancel

Number of database sessions to expect for autosys event_demon and as_server

book

Article ID: 228969

calendar_today

Updated On:

Products

CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

We are trying to monitor the number of DB connection sessions for both event_demon and as_server.

How do you calculate the expected number of sessions.

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

AutoSys uses the following:

DB_CONNECTIONS + DB_CONNECTIONS_SEND + DB_CONNECTIONS_RECV + DB_MONITOR(1) + HEART_BEAT(1) 
HEART_BEAT = High Availabiltiy Checking for Scheduler 
HEART_BEAT = Application Server HeartBeat 
If you do not set any variables, then Scheduler will show 16 + 2 + 2 + 1 + 1 = 22.  

HeartBeat:

Application Server and Scheduler make use of the dedicated connection to register the heartbeat.  The application server updates the ujo_ma_process with the latest timestamp every 5 seconds.  The Scheduler will update the ujo_ha_process table based on your HAPollInterval configuration.

DB_Monitor:

Application Server and Scheduler make use of a dedicated connection for identifying any database connection problems (network or server unavailability or listener unavailability, etc.,).