hi

Thanks for your links.

i've already read all these documents and tried some changes like increasing num_io_servers, prefetching, sortheaps, sheaptress, logfilesize, util_heap_sz etc.. without any improvement.

That's why im looking for some Storm-brainning about what could be happening on my database, i cant do any specifical question because i do not know what to ask. All the database behaviour its a little bit uncommon, it should be working much faster but it doesnt.

i cannot see any bottleneck on our hardware or software so i suposse that the problem could be inside the db.

I really apreciate your help.

Revu.

Why the "longlobdata"? You're pulling the handbrake with that option.
The only reason I can think of when you start to inline LOB's or you try to lower the HWM.
In that case: don't be too harsh to db2 because it has to do a lot of work for you and it is a one-off execution.

Hi dr_te_z,

Yes, we want to low the HWM but we are having the same issues with another not longlob tables.

Thx.

This is somewhat akin to a doctor cutting off random parts of his patient's body hoping to stop the headache.

You'll need to determine _what_ the bottleneck is, _then_ take the appropriate action. Look at the database snapshots, db2top, operating system stats (e.g. nmon) to see what is the possible cause of the issue. Ask your storage administrators to monitor I/O performance from their perspective.

We are gonna review all the nmon statistics.

I'll keep you posted.

Thx a lot.

Do you think that there would be a bottleneck because we were not using a temporary tablespace?

If im not wrong... while reorging without using the tempspace the database could be writting and reading a lot on the same containers of the tablespace, so.. it could be producing i/o wait?


Thx.

I respectfully decline the invitation to make wild guesses. nmon and db2top should give you enough information.

I didn't find the information provided by db2top very useful or maybe I just don't know how to use it properly.

It can help... depending on which body part gets cut off.