ICE046A 5 SORT CAPACITY EXCEEDED - RECORD COUNT 149050210 ON A DATABASE ANALYSER JOB
search cancel

ICE046A 5 SORT CAPACITY EXCEEDED - RECORD COUNT 149050210 ON A DATABASE ANALYSER JOB

book

Article ID: 248158

calendar_today

Updated On:

Products

Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

While trying to move a table in a UTS PBR, the job failed with the following message:  ICE046A 5 SORT CAPACITY EXCEEDED. What's causing the problem?

 

Environment

Release : 20.0

Component : Database Analyzer for DB2 for z/OS

Resolution

ICE046A 5 SORT CAPACITY EXCEEDED Problem resolved by adding the following CARD DFSPARM card OPTION DYNALLOC=(3390,32),FILSZ=