search cancel

Disable Connection Pooling when connecting to Oracle database

book

Article ID: 90078

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Disable Connection Pooling when connecting to Oracle database

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Detailed Description and Symptoms

How to force UC4 Database Agent to use a connection to a remote database only once 

Investigation

The configuration of the connection pool in SQL Agents can be done with the retention_time parameter in the INI file. 

Solution

In V9 the connection pool can be turned off with the parameter retention_time=0. 

In V8 the value retention_time=0 will reuse a database connection if Jobs are running in the same second against the same database.