Friday, November 27, 2009

DB2 – Dataset Maximum Extents reached

Problem:
A "load resume yes" job for the table Table failed due to a problem with the maximum number of extents reached for the database data set.

Approach Failed:
With out terminating the abend utility, increased the secondary space parameter of the DDL of the TS(SEEANS0) and asked SE to try restarting the job. But the job failed as expected with the same problem. The reason being it was unable to increase the number of extents even though the secondary space parameter was increased now.

Solution:
Terminated the load utility, increased the primary space paramter as well, recovered the TS to the RBA (X'15de75966DFF' with a timestamp taken from log analyzer in Platinum tool) prior to the abended job step starting timestamp. Took image copy after the recovery for the TS and asked the SE to restart the job from the load step. The job got completed successfully.

No comments:

Post a Comment