Executing CA Fast Check with ESTIMATED-KEYS keyword specified but receiving sort capacity exceeded error

book

Article ID: 52233

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

Executing CA Fast Check for DB2 for z/OS CHECK DATA and CHECK INDEX with ESTIMATED-KEYS specified in the utility syntax but the execution fails with sort capacity exceeded errors.

The CA Fast Check execution may fail with one of the following depending on installed sort package:
CASO121E SORT CAP. EXCEEDED
ICE046A 1 SORT CAPACITY EXCEEDED
WER046A SORT CAPACITY EXCEEDED

Solution:

To properly control dynamic sort work allocation within CA Fast Check all of the following keywords are required in the utility syntax:

ESTIMATED-KEYS - An integer that specifies the total number of keys to be passed to the sort program for the tables / indexes being checked.
SORTDEVT - Device type for temporary data sets to be dynamically allocated by your sort program.
SORTNUM - An integer that specifies the number of temporary data sets to be dynamically allocated by the sort application program for each sort.

Example: ESTIMATED-KEYS 100000 SORTDEVT SYSDA SORTNUM 6

Environment

Release:
Component: PFC