Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2006
    Location
    UK
    Posts
    8

    Post Unanswered: SMS Tablespace 8(TEMP_16K) is FULL or file is too large

    Hi All

    I am doing a select query on a table which is having 17 million record having 4 column in order by clause.I am getting following error

    SMS Tablespace 8(TEMP_16K) is FULL or file is too large (at OS or user limit).
    Detected on Container 0. ContPage= 67088 Obj=10 Type=128.

    DB2 version : 7.2
    AIX version : 5.2.0.0.

    I have enough space in temp tablespace still I am getting this error

    Temp tablespace is 35GB and ulimit is unlimited.file system is JFS2 .

    If anybody have ever seen this problem please help me.

    Regards
    Atin

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Any message in db2diag.log ?

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2006
    Location
    UK
    Posts
    8
    The message which i have posted is from db2diag.log only.

    SMS Tablespace 8(TEMP_16K) is FULL or file is too large (at OS or user limit).
    Detected on Container 0. ContPage= 65653 Obj=10 Type=128


    regards
    atin

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Create an index with the columns referenced in your ORDER BY clause.

  5. #5
    Join Date
    Mar 2006
    Location
    UK
    Posts
    8
    But this error is keeps coming for many tables which is having large ory area.

    I can see temp file size is terminated as soon as it reached 1GB

    regards
    Atin

Posting Permissions

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