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 SuiteDatabase Management for DB2 for z/OS - Performance SuiteDatabase Management for DB2 for z/OS - Recovery SuiteDatabase Management for DB2 for z/OS - SQL Performance SuiteDatabase 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=