Log Analyzer ends with RC=16 caused by SORT

Products

• Log Analyzer for DB2 for z/OS

Issue/Introduction

SORT failure when running Log Analyzer for DB2 for z/OS. The job terminates with a return code of 16 (RC=16). Error messages such as LAE0008E SORT terminating and ICE118I 0 UNKNOWN FILE SIZE appear in the job log, even after increasing the DYNSORT allocation parameters.

 

Environment

z/os 

Log Analyzer

DB2

Cause

This issue occurs when attempting to analyze a large volume of log changes within a single execution. The SORT utility cannot manage the data volume effectively when multiple report options and large log data sets are processed simultaneously.

Resolution

To resolve this issue, separate the Log Analyzer (PLA) options into different jobs. This reduces the processing load and allows the SORT utility to handle the data for each specific report or action more efficiently.

Follow these steps to implement the solution:

1. Review the current Log Analyzer batch job and identify the various report options being executed (for example, DML reports and Rollback Activity reports).
2. Create separate JCL jobs for each major report or processing task.
3. Ensure that the REGION parameter on the job card is set to a sufficient value, such as 0M, to provide the necessary memory for large extractions.
4. If using the Rollback Activity report (RBREPT), consider running it independently as it often processes log data without filters, which significantly increases the demand on the SORT utility.