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 consistently. That is not the same thing as servicing your request first with nothing else running on the system.
If you tell WLM that 2 seconds is good enough, when you get 1.98 seconds you're getting what you told the system. The ability to do this, to instruct a server to deliver predictable performance across subsystems according to a service level agreement (SLA) goal, is probably unique to z/OS. It's a very useful business-oriented feature. And now you know what to ask. :-) Note that, if your application were also running on z/OS, it too would be embraced by WLM and managed according to the goal(s) you set. So, for example, if the application is at risk of taking too long to respond to a user, z/OS Workload Manager will try to allocate more system resources (such as CPU) to get that application to finish within the goal, if possible. That includes everything involved in fulfilling the request: z/OS TCP/IP, z/OS disk I/O, z/OS DB2 activity, and so on. Pretty cool, isn't it? I should also advise you that ODBC is the type of processing that can benefit from the zIIP (a specialty mainframe processor). I would recommend that the people you work with seriously investigate upgrading to DB2 8 (or better yet 9) and adding a zIIP, especially if there is current or planned "non-trivial" ODBC use. You are accessing DB2 via DRDA when you use ODBC, and much of the DRDA work can run on the zIIP instead of on the main processors. The zIIP could speed up your ODBC/JDBC access, or lower your DB2 CPU needs, or both. - - - - - Timothy Sipples IBM Consulting Enterprise Software Architect Specializing in Software Architectures Related to System z Based in Tokyo, Serving IBM Japan and IBM Asia-Pacific E-Mail: [EMAIL PROTECTED] ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
