CAUAJM_W_10998 Performance warning messages in DBMaint.out

Products

• Autosys Workload Automation

Issue/Introduction

In the DBMaint.out log, there are CAUAJM_W_10998 Performance warning messages, regarding queries being executed in the AutoSys database

Environment

AutoSys 12.1.01

Resolution

CAUAJM_W_10998 messages triggered when a query being executed by AutoSys breaches the threshold specified in the DBLibThresholdTime.

This parameter can be found in the instance configuration file ($AUTOUSER/config.$AUTOSERV):

Keyword: DBLibThresholdTime=<value>

Defines the time limit that any query in AutoSys should take to complete,
when any query takes more than the configured value, then the application
logs a warning message in the scheduler or the application server log and
user can make a decision to check query plans and take corrective action.
This will enable users avoid database related performance problems.

The valid values are as follows:

  >0 = Specifies that any query can take  so many seconds to  limit, when
        any query exceeds the limit, application will log a warning.

Default : 10