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

Products

• 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?

Environment

Release 12.0, 12.1

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 increasing the RLOGDAYS 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 run log data resides in the HIS770 area and may require increasing.

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