DB2 9 for z/OS Performance Topics Overview
DB2 9 for z/OS is an exciting new version, with many improvements in performance and little regression. DB2 V9 improves availability and security, as well as adds greatly to SQL and XML functions. Optimization improvements include more SQL functions to optimize, improved statistics for the optimizer, better optimization techniques, and a new approach to providing information for tuning. V8 SQL procedures were not eligible to run on the IBM System z9 Integrated Information Processor (zIIP), but changing to use the native SQL procedures on DB2 V9 makes the work eligible for zIIP processing. The performance of varying length data can improve substantially if there are large numbers of varying length columns. Several improvements in disk access can reduce the time for sequential disk access and improve data rates.
The key DB2 9 for z/OS performance improvements include reduced CPU time in many utilities, deep synergy with IBM System z hardware and z/OS software, improved performance and scalability for inserts and LOBs, improved SQL optimization, zIIP processing for remote native SQL procedures, index compression, reduced CPU time for data with varying lengths, and better sequential access. Virtual storage use below the 2 GB bar is also improved.
This IBM Redbooks publication provides an overview of the performance impact of DB2 9 for z/OS, especially performance scalability for transactions, CPU, and elapsed time for queries and utilities. We discuss the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates.
Keep in mind that your results are likely to vary, as the conditions and work will differ. In this book, we assume that you are familiar with DB2 V9. See DB2 9 for z/OS Technical Overview, SG24-7330, for an introduction to the new functions.
Member ID : AXZ75302PUQ
IBM Redbooks was added to my favorite authors list, after reading DB2 9 for z/OS Performance Topics.
Member ID : AXZ94894PUQ
Ik wilde DB2 9 for z/OS Performance Topics lezen, een heel interessant boek.
Member ID : AXZ13087PUQ
Never underestimate DB2 9 for z/OS Performance Topics, I could not put this book down. You must read this!.
Member ID : AXZ98682PUQ
Just Got it, can’t wait to read this book soon!
Member ID : AXZ22925PUQ
fem stjerner for DB2 9 for z/OS Performance Topics, tak for IBM Redbooks. du er den bedste.
Member ID : AXZ82481PUQ
Basically, I loved this book. I give the book 5/5 Stars, and this one is getting added to my All-Time Favorites list!
Member ID : AXZ25648PUQ
rakastan tätä kirjaa. sinun pitäisi lukea tämä.
Member ID : AXZ54165PUQ
IBM Redbooks è un grande scrittore, dovresti leggere questo.
Member ID : AXZ64538PUQ
Before I read DB2 9 for z/OS Performance Topics, I had read some reviews which had me wondering if this one would be something I'd like, reviews from people whose opinions I trust. It's True, so DB2 9 for z/OS Performance Topics stayed on my "TBR Someday".
Member ID : AXZ38870PUQ
When I started this book, I wasn't so sure how much I would enjoy it. but reading from IBM Redbooks's point of view was so refreshing.
Member ID : AXZ53045PUQ
Ein Buchliebhaber wäre daran interessiert, dies zu lesen.
Member ID : AXZ90191PUQ
Thank you to IBM Redbooks for my honest thoughts.
Member ID : AXZ74429PUQ
Just downloaded this book! Many thanks
Member ID : AXZ18978PUQ
IBM Redbooks хороший автор, вы не можете пропустить это чтение.
Member ID : AXZ41074PUQ
IBM Redbooks es uno de los mejores autores nacidos. DB2 9 for z/OS Performance Topics es un libro interesante.
Member ID : AXZ54862PUQ
le livre que j'ai toujours attendu, je peux enfin le lire maintenant. merci.
Member ID : AXZ94928PUQ
how to download this ebook???
You Need LOGIN To Read More Comments...