Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

MIPS and DB2 V9 with full XML handling features

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
SaulS

New User


Joined: 23 Jun 2010
Posts: 2
Location: USA

PostPosted: Thu Aug 05, 2010 5:58 pm    Post subject: MIPS and DB2 V9 with full XML handling features
Reply with quote

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?
Thanks
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 05, 2010 8:43 pm    Post subject:
Reply with quote

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. . .
Back to top
View user's profile Send private message
SaulS

New User


Joined: 23 Jun 2010
Posts: 2
Location: USA

PostPosted: Thu Aug 05, 2010 11:55 pm    Post subject: Reply to: MIPS and DB2 V9 with full XML handling features
Reply with quote

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.
Regards.
S.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 05, 2010 11:59 pm    Post subject: Reply to: MIPS and DB2 V9 with full XML handling features
Reply with quote

Good luck - someone should be here if there are questions icon_smile.gif

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Full health checks of IMS databases ashek15 IMS DB/DC 1 Sat Apr 01, 2017 8:34 am
No new posts MIPS/CPU consumption reduction in Batch vishwakotin DFSORT/ICETOOL 4 Sat Mar 18, 2017 5:46 pm
This topic is locked: you cannot edit posts or make replies. MIPS reduction for Batch job Virendra Shambharkar All Other Mainframe Topics 8 Mon Nov 07, 2016 4:02 pm
No new posts ON ERROR handling soundarr PL/I & Assembler 2 Wed May 11, 2016 3:37 am
No new posts Need training ppt for DB2 v10 MSU / M... SRICOBSAS DB2 5 Tue Mar 15, 2016 10:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us