Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Posts
    4

    Unanswered: TEMPSPACE is getting filled up.

    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

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    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).
    mota

  3. #3
    Join Date
    Mar 2003
    Posts
    343
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •