472,354 Members | 1,610 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,354 software developers and data experts.

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
1 1214

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Jack | last post by:
I wrote this code: <SCRIPT LANGUAGE=JScript RUNAT=Server> .... Response.Write("<INPUT type=text id=text100 name=text100 onchange='text101.value=eee'>"); Response.Write("<BR>");...
3
by: Peteris Krumins | last post by:
Hello! I would like to ask how to search for a container element which matches some criteria. Here is what I mean. Suppose I have a structure: struct my_struct { my_struct(const std::string...
2
by: Joachim Mueller | last post by:
This sql statement dies after using more than 40GB Tempspace: INSERT INTO dcp.cmp_mo_p_bab_kart ( currency, year, figure, period, month_date, company, center, account, value ) SELECT CASE...
3
by: Mats Mohlin | last post by:
We are testing Db2 Cube Views on DB2 V8 for Solaris Small MQT get created OK but for a big MQT we get this message in the db2diag.log ADM6017E The table space "TEMPSPACE1" (ID "1") is full....
1
by: Luc Le Blanc | last post by:
Under UDB 7.2 for OS/2, how can I determine the % of used space in a DMS container (preferably via the CLP interface, so I can script the command with REXX)? At what level should I go about adding...
0
by: apple | last post by:
How large should tempspace be relative to the largest table in a database to do reorgs? Does tempspace have to be at least twice the size of the table being reorged. Assuming nothing is using...
36
by: Peter Olcott | last post by:
So far the only way that I found to do this was by making a single global instance of the container class and providing access to the contained class, through this single global instance. Are...
5
by: gerry | last post by:
I am trying to create a custom container control that will only ever contain a specific type of control. At design time, when a control of a different type is added to the container I would like...
80
by: Boltar | last post by:
Hi I need to store a number of integer values which I will then search on later to see if they exist in my container. Can someone tell me which container would be quickest for finding these...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.