00C90099
Explanation
An attempt was made to load data into a partition, but the partition is full. Based on the high key value specified in the index for each partition, utilities instructed Data Manager to load a record into the proper partition. This required Data Manager to build a new page with a page number one higher than the last page in the partition. However, this new page is in the next partition.
This situation usually occurs when a very large partition undergoes inserts and updates. When the table space or partition is reorganized, the page set is deleted and redefined, and the free space and PCTFREE cause the partition to expand. It might attempt to fit more data in the partition than the partition can now hold.
System action
The requested action is not performed.
Operator response
Notify the system programmer.
System programmer response
Use the -TERM UTILITY command to terminate the load utility and reduce the UIP (utility in process) counts.
User response
Redefine the high key values in the index and retry the load.
If you receive this code during a reorganization, query the catalog to check the PCTFREE and FREEPAGE values. You might be able to decrease the amount of free space to allow the REORG utility to complete successfully.
Alternately, you can terminate the utility and recover the table space. This approach can be time-consuming, but does not cause additional problems. When the recovery is complete, you can alter the partition key and run the reorganization again.
Problem determination
- Console output from the system on which the job was run, and a listing of the SYSLOG data set for the period of time that spans the failure.
- SYSPRINT output, including JCL, for the application program or batch job, and system messages that were issued. Make sure that MSGLEVEL=(1,1) on the JOB statement so that all diagnostic information is sent to SYSPRINT.
- Definitions of table spaces, tables, and indexes involved in the error.
