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

atinjain05 · #1 (**permalink**) 03-27-06, 04:44

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

sathyaram_s · #2 (**permalink**) 03-27-06, 05:51

Any message in db2diag.log ?

Sathyaram

atinjain05 · #3 (**permalink**) 03-27-06, 05:57

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

n_i · #4 (**permalink**) 03-27-06, 09:16

Create an index with the columns referenced in your ORDER BY clause.

atinjain05 · #5 (**permalink**) 03-27-06, 10:06

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

Internet Services

Web Development

Digital Marketing

Consumer Tech