Warning: This article is meant for iSeries system administrators only. Purging data from product files will permanently remove them from the system. These actions cannot be undone easily and can result in undesired behavior.
Overview
On a very busy system, the Batch Report Server/400 log file, BCHLOG00, can become very large. This file keeps a record of every time a monitor starts and stops and every attempt to process a spool file.
To see the log data, run:
RUNQRY () RJSBCH/BCHLOG00
The informational records for starting and stopping take up the most space in the log. You can remove them at any time, since they have very little helpful information, other than keeping a record of monitor activity.
RJS Software recommends the following guidelines when purging the log file:
- Remove all INFO records on a regular basis.
- Remove OKCOPY & OKFTP records more than 30 days old.
- Retain ERRORCOPY & ERRORFTP records until you have reviewed them.
Removing INFO Records from the BCHLOG00 File
Warning: The SQL statement below permanently removes records from the log file. Make sure that you have read the security warnings and suggestions above first.
Use the following SQL statement to remove all INFO records:
DELETE FROM RJSBCH/BCHLOG00 WHERE NTL001 = 'INFO'
Removing OKCOPY Records from the BCHLOG00 File
Warning: The SQL statement below permanently removes records from the log file. Make sure that you have read the security warnings and suggestions above first.
Use the following SQL statement to remove all OKCOPY records that are more than 30 days old:
DELETE FROM RJSBCH/BCHLOG00 WHERE NTL001 LIKE 'OK*' and NTL003 < CURRENT TIMESTAMP - 30 DAYS
