tempspace is managed by system. what's mean "TEMPSPACE1" (ID "1") is full? I execute command 'df -h' and get '/u' is 23GB. Has it used all the spaces?
Thanks a lot.

The following message was in db2diag.log .

ADM6017E The table space "TEMPSPACE1" (ID "1") is full. Detected on container
"/u/biw/biw/NODE0000/SQL00001/SQLT0001.0" (ID "0"). The underlying file system
is full or the maximum allowed space usage for the file system has been
reached. It is also possible that there are user limits in place with respect
to maximum file size and these limits have been reached.

What is your OS ? What version ? What is the type of filesystem ? You may have to get your filesystem 'Large File Enabled' to create files larger than 2 gigs ...
Also, check your ulimit using the command 'ulimit -a' .. if there is a restriction on the file size, get your sysadmin to reset it to unlimited .... then, logoff, logon and db2stop-db2start ...

HTH

Sathyaram

OS:linux core 2.6
HOSTELL6650 + SAN CX200
DB2:V8 ,FP6 and tablespace containers is raw devices

There is unlimited of filesystem.

"ulimit -a" messages:
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 65536
virtual memory (kbytes, -v) unlimited