Re: performance of db2 7 on mainframe

2007-11-20 Thread Timothy Sipples
Luca, In addition to John's excellent questions, another question to ask is what WLM (Workload Manager) goal you've got set. If you tell z/OS Workload Manager that the DB2 user (you) should get a response within X.XXX seconds if possible, then WLM is going to try to meet or beat that goal consist

Re: performance of db2 7 on mainframe

2007-11-20 Thread IBMsysProg (Avram Friedman)
Original Message- From: John S. Giltner, Jr. [mailto:[EMAIL PROTECTED] Sent: Monday, November 19, 2007 9:29 PM Subject: Re: performance of db2 7 on mainframe [EMAIL PROTECTED] wrote: > hello, > I'm having a performance issue with a Windows CLI/ODBC application > that connects to

Re: performance of db2 7 on mainframe

2007-11-19 Thread John S. Giltner, Jr.
[EMAIL PROTECTED] wrote: hello, I'm having a performance issue with a Windows CLI/ODBC application that connects to a DB2 rel 7.1 on a mainframe of a bank. I have to say I'm pretty new with this kind of environment. And I don't know the details of the HW of the host. I just know it's an host of a