467,888 Members | 1,528 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,888 developers. It's quick & easy.

Tempspace only one container is being used - EEE!

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

Nov 12 '05 #1
  • viewed: 1124
Share:
1 Reply

"Visu" <Vi*******@gmail.com> a écrit dans le message de
news:11*********************@g44g2000cwa.googlegro ups.com...
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


Hi, you should look at the access plan to see if at one step all goes to a
mono-partition nodegroup thru a tablequeue, to join with a table that is in
this mono-partition nodegroup.

One way to lift this is to create a REPLICATED table of this table in a
tablespace that is multi-partition to allow DB2 continue inter-partition
parallelism. Don't forget to runstats on this table, and you can also create
indexes (non unique) on this type of table.

HTH,

Jean-Marc
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Peteris Krumins | last post: by
2 posts views Thread by Joachim Mueller | last post: by
1 post views Thread by Luc Le Blanc | last post: by
reply views Thread by apple | last post: by
80 posts views Thread by Boltar | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.