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?
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 .
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).
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