Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB2 Version 9 vs Version 8

Status
Not open for further replies.

PruSQLer

Technical User
Nov 6, 2001
221
US
We're trying to quantify the performance gains we'll see in 2008 when we convert to Version 9. To those of you who have already gone to V.9, have you seen significant performance improvements? If so, would you say it's as much as 25 or 30% ?

Any feedback is greatly appreciated. We're using UDB on UNIX.
 
Specify performance gain:
- storage gain?
- fire 50% of your DBA-staff?
- stop messing around with XMLin BLOB's and stop utilizing various XML parsers in you applications?
 
We are currently in the midst of a somewhat massive consolidation project to combine our 2 databases. When complete, we will have a DB in the neighborhood of 1.5 terabytes. Our monthly production cycle is a fairly extensive "batch" process consisting of feeds from various admin systems, large and numerous table loads, followed by a long stream of reports automatically executed. Soon after the consolidation, we will be converting to Version 9.

IBM came in and gave several presentations to our Tech Management guys who now are saying V9 will be a big improvement over V8. However, they haven't installed V9 on a database even approaching the size of ours. We are looking to speed up our monthly cycle as much as possible due to shrinking reporting timelines. My question is, given the type of processing we do, can we expect a boost from V9? So, if anyone out there has any experience such as I'm describing, please key me in on what effect, if any, going to V9 had.

Thanks.
 
A typical IBM reply: "it depends". How well did you tune your V8 database? If you did not pay much attention tuning memory parameters on V8 and you install V9 and enable automatic memory management, then HUGE improvements can be expected.

But if the above is not the case... V8 is already a fenomenal database system. Better look at your hardware and your O.S. and most important your SQL. Did you eliminate table-scans where possible? (if your reply: huh what? then hire a DBA :) )

Are you running 64 bit? Linux or Unix? 6 to 10 disks per CPU?
A dedicated database server? A truckload of RAM?
 
Thanks for the response Truss...

I'm in the business area so we don't get to tune the database, that job falls to our DBAs. We make recommendations to them and sometimes they listen and other times they ignore us. So, I don't know how much attention was paid to Memory parameters on V8. Sounds like auto memory management is the ticket for V9, eh?

We will be making optimization changes to our production SQL so hopefully any table scans will be eliminated.

We'll be on 64 bit, UNIX. Don't know the disk count. We have a dedicated server and they're adding RAM. Also putting in more disk storage and more processors.

Hopefully things will go faster for us on V9.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top