Log Extract job abended while doing full extract executing Log Analyzer

Products

• Log Analyzer for DB2 for z/OS

Issue/Introduction

Executing a Log Analyzer for Db2 for z/OS (PLA) extract job with full extract. The job is failing with the below error :

LAE0032E LAL@BLDX terminated with return/abend code: A03

BPA0071E: CALLED PROGRAM LAL@LOG ABENDED. ABEND CODE U0200 REASON CODE
            00000000 - PROCESSING TERMINATES.
 RETCODE =    20

.

.

LAE0008E SORT terminating.  Return/Abend Code: 16

.

.

ICE046A 0 SORT CAPACITY EXCEEDED 

 

 

Cause

As it is a full extract of the log the amount of storage for the sort was not sufficient.

Resolution

Problem was resolved by an update of the job JCL with a change of the sort parameters to increase sort capacity and MSG (Y) provides better diagnostics from:

DYNSORT  = (DSNUM(2),SPACE(10,10),MAINSIZE(1000),MSG(N))
to 
DYNSORT  = (DSNUM(6),SPACE(50,20),MAINSIZE(2000),MSG(Y))

 

MSG(Y|N)
Specifies whether SORT messages display after successful sort completions. The following values are valid:

Y
Displays SORT messages after all SORT invocations.

N
Displays SORT messages only after unsuccessful SORT executions. This option is the default.

Additional Information

DYNSORT Control Statement

LAE0032E

LAE0008E