search cancel

Creating and Closing Database connections.

book

Article ID: 90047

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Creating and Closing Database connections.

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Detailed Description and Symptoms

Q1. Does Applications Manager manage its connections? i.e Does it open and close connections as needed?

Q2. What determines when a new connection is opened?

Q3. What determines when a connection is closed?

Q4. Does at least one connection stay active on an agent at all times?


Solution

?A1. The AgentService processĀ opens and closes connections as needed.

A2. We have a pool of connections which we use to connect to the database for each data requests or job submission. If those are all in use, a new connection would be opened.

A3. The connection is returned to the pool after the request or submission is complete.

A4. Yes, the agent will get a connection when the Agent starts up to ensure that it can connect to the DB. Each time we need a connection we get one from the pool and return it afterwards. If there are no available connections at the timeĀ  we are trying to connect to the database it will open a new connection, which will then be added to the pool of available connections.