DB2 V5 OS/390 - CPU consumption of DB2 address spaces

Vijay Kumar

DB2 V5 OS/390 - CPU consumption of DB2 address spaces
Greetings,

Could anyone let me know whether the Class 2 CPU accounted for the
application is included in the CPU consumed by the address spaces (System
Services, Database Services, DDF, Stored Proc. addr. spaces)?

I was looking at the CPU consumed by the address spaces (TCB+SRB) and found
that the total CPU of the address spaces is about 60% more than the Class 2
CPU of the application.

Your answer will help me to do the capacity projection.

Thanks in advance.

Vijay.



_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com



Roger Miller

Re: DB2 V5 OS/390 - CPU consumption of DB2 address spaces
(in response to Vijay Kumar)
At the 100,000 foot level, the DBM1, MSTR and IRLM address space cpu times
are not included in the class 2 accounting. The DDF and stored procedure
address spaces are the applications and are included in the class 2
accounting. I presume that you are using the red book, DB2 for OS/390
Capacity Planning, SG24-2244. It has information about the address spaces
and the section on capture ratios seems close to what you are asking.

The tools that you use are performing some manipulation in most cases, so
you need to understand your situation. I often see differences in SRB
time handling, since that has changed substantially with enclaves.

Roger Miller, DB2 for OS/390