Seem to be getting a 2646 spool space error when there is no spool space problem

Analytics
N/A

Seem to be getting a 2646 spool space error when there is no spool space problem

I have a user whose job keeps abending with a 2646. When I check the spool distribution, not even one amp is touching the allocated spool ceiling. Here is how the data is distributed for the ID during the query in question ( I won't put the entire result set because there are so many rows, but I ordered by peakspool descending):

DATABASE ACCOUNT Vproc PEAKSPOOL maxSPOOL
FADWDPLM $LB$&S&D&H 83 5,518,902,272.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 149 147,533,824.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 108 104,856,064.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 441 81,945,600.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 328 79,777,280.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 246 78,166,016.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 337 72,461,824.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 10 60,479,488.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 429 54,774,272.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 195 50,712,064.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 33 22,991,360.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 346 8,627,712.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 196 2,366,976.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 231 2,360,320.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 197 2,356,736.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 436 2,344,448.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 116 2,328,064.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 118 2,324,480.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 236 2,316,800.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 64 2,313,728.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 375 2,309,632.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 191 2,299,904.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 357 2,296,320.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 140 2,295,296.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 27 2,285,056.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 74 2,284,032.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 249 2,276,864.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 310 2,271,232.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 194 2,270,720.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 256 2,269,696.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 292 2,266,112.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 0 2,260,480.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 141 2,258,432.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 288 2,258,432.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 186 2,257,408.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 75 2,254,848.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 169 2,252,800.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 171 2,249,216.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 182 2,248,192.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 201 2,245,632.00 10,666,309,509.00
.
.
.
.
.
FADWDPLM $LB$&S&D&H 271 1,916,416.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 427 1,902,592.00 10,666,309,509.00
FADWDPLM $LB$&S&D&H 416 1,902,592.00 10,666,309,509.00

Any Idea why this job received a 'No more spool space' error?
Tags (2)
3 REPLIES
N/A

Re: Seem to be getting a 2646 spool space error when there is no spool space problem

And another instance...

DATABASE ACCOUNT VPROC PEAKSPOOL MAXSPOOL
B0$FSPRD $LB$&S&D&H 369 443,904.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 379 260,608.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 398 174,592.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 22 164,864.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 68 143,360.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 261 132,608.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 423 93,184.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 46 84,992.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 231 81,920.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 212 64,512.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 151 59,392.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 139 51,712.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 62 50,688.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 163 45,568.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 160 45,568.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 5 43,008.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 224 41,472.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 257 32,256.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 221 30,208.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 315 29,696.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 443 28,672.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 355 28,160.00 662,251,721.00
B0$FSPRD $LB$&S&D&H 411 27,648.00 662,251,721.00
N/A

Re: Seem to be getting a 2646 spool space error when there is no spool space problem

Is there a PROFILE for that user?
Then you have to look at MaxProfileSpool instead of MaxSpool:
COALESCE(MaxProfileSpool, MaxSpool)

Dieter
N/A

Re: Seem to be getting a 2646 spool space error when there is no spool space problem

Thank you. The profile spool was smaller than the allocated spool, so that explains it. Thank you so much!