IBM Support

Attempting to load more data than fits into the data set

Question & Answer


Question

The LOAD DATA REPLACE utility receives the following error messages: DSNT500I DSNUGBAC - RESOURCE UNAVAILABLE REASON 00D70027 TYPE 00000220 NAME SON2DB2X.DSNDBC.SON2X.ACOHD.I0001.A001 DSNU017I DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E400AF' CAUSE=X'00C9000A' The table space is defined with a PRIQTY of 12 and a SECQTY of 12. The volume on which the table space resides has 839 cylinders of free space. The LISTCAT command shows 1 track for each primary and secondary allocation. The job is trying to load 1422 rows of 63 bytes each. With extents, the data should fit into this table space.

Cause

Examining the DDL that generated this situation shows a SEGSIZE attribute of 32 in the CREATE TABLESPACE statement.

Specifying SEGSIZE 32 tells DB2® to create 32 pages per segment. And at 4k, this means 32 x 4096 = 131072 bytes.

Consequently, DB2® is being requested to allocate 131072 bytes in a 19152 byte data set.

Answer

The data set must be defined with a size that is sufficient to hold the data that is to be loaded into it.

For further information about SEGSIZE, PRIQTY, and SECQTY attributes for tablespaces, review the CREATE TABLESPACE statement in the SQL Reference for your version of DB2.

Related Information

[{"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Utilities","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"10.0;11.0;12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21159619