How to increase the volume of data recorded in the CA7_RUN_LOG SQL table?
Article ID: 8500
Updated On:
Products
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?
Environment
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
Feedback
