Log Analyzer : Log Extract job abended while doing full extract
Article ID: 216542
Updated On:
Products
Issue/Introduction
Running an 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
Environment
Release : 20.0
Component : Log Analyzer for DB2 for z/OS
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 parms 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
Feedback
