How to increase the volume of data recorded in the CA7_RUN_LOG SQL table?

book

Article ID: 8500

calendar_today

Updated On:

Products

CA Workload Automation CA 7 Edition CA-7 JOB MGMT CA 7 Workload Automation

Issue/Introduction

Running the program DBSQLPR to generate a SQL report from the  MFWA.CA7_RUN_LOG table the number of records obtained is very  limited (Only few days).

Is there any way to increase the number of records available in this table?

Cause

The MFWA.CA7_RUN_LOG SQL table contains one row for each and every execution of a job .
The number of days kept in this table depends on the value of the RLOGDAYS keyword in the DBASE Statement of the initialization file .

Environment

WORKLOAD AUTOMATION CA 7 EDITION release 12.0

Resolution

The default of RLOGDAYS is 5 and the maximum value is 365 so if you want to have more days recorded in this table you should update the value of the RLOGDAYS in your initialization file.

Before to increase this value consider the following:

*The size of the run log is one or more entries per job per day.
Each day can take up a considerable number of rows in the database
table.

*The LRLOG command can take longer as the number of days is increased (because more data is processed).

Additional Information

You can find more information about RLOGDAYS at the following link:

https://docops.ca.com/ca-workload-automation-ca-7-edition/12-0/en/configuring/programming/manage-the-initialization-file/dbase-statement