Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Wait All DB2 I/O

Status
Not open for further replies.

MarcLodge

Programmer
Feb 26, 2002
1,886
GB
Hi,

We have a number of CICS DB2 programs that taking an excessive elapsed time. They are supposed to be quite high burners, but even though I have tuned them as much as possible using explain and the cost tables, they still take a long time.

Examination of the log shows that the actual CPU time is under 3 seconds even though the elapsed time is nearly 3 minutes and 20 seconds. All of the rest of the time is designated at 'Wait All DB2 I/O' time.

Does anybody have any experience of getting to the root cause of this problem and can give me any pointers along the path.

Many thanks.

Marc
 
I have - Do you use Insight? This may also be something to talk in private initially and then post here findings.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top