Got a kind of strange question from my boss today.
"We do not have a problem with additional DASD space or CPU but we have a quite limited amount of MIPS on our box. We are going to install DB2 V9 and use those new XML handling features which are there. How to be sure that overall performance would not be degraded for the reason of relative small MIPS amount?"
Anybody familiar with the subject of minimum MIPS requirements for good DB2 V9 performance? What literature to read would be usefull? Any references to the specific IBM manual?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Hello and welcome to the forum,
I have no idea how this could be: "We do not have a problem with additional DASD space or CPU but we have a quite limited amount of MIPS". What does your boss mean by CPU?
If one wants to do new large tasks that require higher amounts of cpu, one must invest in more cpu power. . .
There is no generic answer about "minimum mips" for db2 v9 that i'm aware of. The amount of cpu resource needed depends on how the tables are defined and queried. Actually mips is not a measurement - it is a rating. A process does not use "mips" - a process uses system resources, one of which is cpu (not mips).
You might ask your IBM rep if there is any material they provide.
Something i'm sure your boss is interested in is that when a larger cpu is installed/upgraded, the cost of software licenses goes up. . .
That's exactly what made me so confused. Looks like he mixed apples and oranges. I'm just quoting him " We are running only on lesss than 300 MIPS. No problem with DASD and CPU. Could you give me recommendation on the MIPS usage for V9 and would we able to install and run it successfully?".
I'd rather contact with IBM support with all technical parameters of our Z box try to do so having my boss on the other line.