Hi all,
DB2 - Ver 7.2 EEE on AIX
This Sytem temporary tablespace in question is created on all the 5
nodegroups, and the containers are in 5 different filesystems. For some
reason only one container is being used and eventually the filesystem
is getting FULL and the transcation fails.
The SQL being executed is a select statement with about five joins and
a group by , and tables involved are relatively big.
The filesystem holding each containers have 37GB freespace. And ulimit
for the user is unlimited.
Any hint on why this happens will be a great help!
Thanks