This is a new one for me.  When I run the command below, I get a spool error.  The table has about 620 million rows in it.  Can someone please suggest what I need to do in order to resolve this?
COLLECT STATISTICS
  USING THRESHOLD 5 PERCENT
    AND THRESHOLD 7 DAYS  

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