Insufficient space in the Db2® work file database
When processing large amounts of data, you can encounter insufficient space in the Db2® work file database.
Symptoms
HCL Z Asset Optimizer operational jobs are failing.
Causes
When you run SQL queries that process large amounts of data, including sorts and joins, there is insufficient space in the work file database that is used for temporary storage.
Diagnosing the problem
DSNT501I -DE91 DSNIXWKF RESOURCE UNAVAILABLE 553
CORRELATION-ID=XXXXXX
CONNECTION-ID=DB2CALL
LUW-ID=AUIBMQXP.OMU1DEC1.C4729058740C=0
REASON 00C900A5
TYPE 00000230
NAME 4K
DSNT501I -DE91 DSNIWKFL RESOURCE UNAVAILABLE 554
CORRELATION-ID=XXXXXX
CONNECTION-ID=DB2CALL
LUW-ID=AUIBMQXP.OMU1DEC1.C4729058740C=0
REASON 00C90084
TYPE 00000230
NAME 4K
View and check the sizes and extents of the physical data sets allocated to the table spaces in the work file database.
Resolving the problem
Increase the sizes of the table spaces associated with the work file database. The sample db2.SDSNSAMP(DSNTIJTM) job provides examples of how to increase the sizes of the table spaces.