Hi,

I'm trying to load a table and getting error because TEMPSPACE is getting filled up.

Here is the load command I used.

load from /db2/uszbad10/db2wkarea/cos/data/COS_TCOSW910exp.ixf of ixf savecount 5000 replace into COS.TCOSW910;


Here is the error message :

SQL3110N The utility has completed processing. "30084239" rows were read
from the input file.

SQL3519W Begin Load Consistency Point. Input record count = "30084239".

SQL3520W Load Consistency Point was successful.

SQL3515W The utility has finished the "LOAD" phase at time "08/16/2006
13:59:29.587932".

SQL3500W The utility is beginning the "BUILD" phase at time "08/16/2006
13:59:29.600325".

SQL3213I The indexing mode is "REBUILD".

SQL0289N Unable to allocate new pages in table space "TEMPSPACE3".
SQLSTATE=57011

I increased the size of TEMPSPACE3 many times,,, but still getting error.

Any thoughts ?

Thanks,

Sudheer

index has the (indexfields + the rowid (5bytes)) for each row; if your indexfield is 11 bytes you are looking at 16 *30mil=480meg roughly for index size; since db2 uses tempspace3 for sorting, you need temp3 to be something like 2 times the index size( 960meg or 1gig in our example).

How many indexes do you have on the table? To complete the load, drop all indexes except the PK. The try the load again. If that doesn't work, then try to increase tempspace as posted by dbamota.