|
View previous topic :: View next topic
|
| Author |
Message |
speedcnu
New User
Joined: 27 Jan 2004
Posts: 6
Location: Hyderabad
|
|
|
|
Hi,
Can some one help me to understand why MIPS count is increasing suddenly without our knowledge, as we are using inbuilt queries to extract the data, the next day we have received a mail from client saying that particular day we have used more than 450 MIPS in 2hours. Need explanation.
How could a associate or team member knows that MIPS count was increasing while using some queries.
Can we know or find out where the problem coming..
or in such situation how can we respond our immedaite manager...
Appreciate your reply on this....
Srini |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
1. Why did you respond to a topic that's been inactive for six months -- and with something that isn't quite relevant?
2. There is no such thing as "MIPS count" -- nor can you use 450 MIPS in 2 hours. MIPS is a measure of capacity and does not change in one hour, 2 hours, or 527 hours -- it is a constant for a given configuration. You may have used more service units in 2 hours -- but not MIPS. MIPS also cannot be used to refer to anything less than an LPAR as IBM does not support such a use. Of course, IBM no longer supports using "MIPS" at all ....
3. Your service unit usage depends upon what you were doing -- even "inbuilt queries", if poorly designed and coded, can use a lot of CPU and I/O time (thus driving the service unit usage up).
The real question is, what was done differently to cause the increase? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
I am also interested in the reply to Srini's question,
as I don't trust myself to formulate a politically correct answer. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| How could a associate or team member knows that MIPS count was increasing while using some queries. |
Most organizations track system utilization. Have you talked with the performance measurement people?
| Quote: |
or in such situation how can we respond our immedaite manager...
|
They should tell what they want to know and you should find the answers and report back. . .
| Quote: |
Can we know or find out where the problem coming..
|
Something in the process has changed or the data is not the same as the acceptable runs. If the elapsed time went up and the cpu and i/o stayed the same, the additional time could be due to the mix of processes running at that time. If the resuorce usage went up, it is probably not related to the mix. |
|
| Back to top |
|
|
|
|
