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

Document ID : KB000008500
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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?

Environment:
WORKLOAD AUTOMATION CA 7 EDITION release 12.0
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 .

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