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

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=