DB2 Performance Improvements in DB2 10 for zos2010 DB2 Magazine article discusses the DB2 performance improvements in DB2 10 for zOS which improve total cost of ownership.
| |||
 Comments are closed  DB2 Performance  DB2 10, DB2 Optimizer, DB2 utility, DB2 zOS, total cost of ownership
Please keep the comments coming and it seems there are a lot people interested in Oracle to DB2 conversions especially migrating from Oracle to DB2 for z/OS. The main questions were “How long does the migration from Oracle to DB2 really take?” and “When migrating from Oracle to DB2 what are the real problems . . . → Read More: Migrating from Oracle to DB2 Part 2
Thanks for all the comments and emails about the blog. It is great to hear from everyone and hear how your company is having success or the same issues with your applications. It is also interesting to hear from the database competition Oracle.
DB2 9.7 has a number of features that make it . . . → Read More: Oracle Conversion to DB2 The beta of DB2 10 for z/OS continues to progress with the early indications that the relative DB2 performance processing bar is definitely being raised in this next version. Early DB2 10 beta customers are truly experiencing 5-10% DB2 performance improvements out of the box. Some are even experiencing greater improvements because their unique application . . . → Read More: DB2 Version 10 and DB2 LUW: Redefining DB2 Performance It seems that I hit a nerve when I was talking about DB2 tools. It seems many shops are upset at the rising costs of third party tools. IBM’s responses of some free tools that have limited capabilities are also getting limited enthusiasm. What has been interesting is there really seems to be support for . . . → Read More: Get the SQL Cache Anyway–Even Without OSC DB2 performance tuning is always different for every system and application. In addition, the different DB2 LUW DBM configurations and z/OS zParms provide customizable options to improve your system and application DB2 performance mix. These parameters are usually standard with the DB2 LUW AUTOCONFIGURE options. The DB2 z/OS standard settings from years of previous versions . . . → Read More: Improve DB2 Performance by Reducing Your Other Time The comments about Optimization Service Center (OSC) and the free Data Studio were great last week. Sorry I could not reply because I am working with clients on their DB2 performance issues. I’m only able to look through the DB2-L Digest in the evenings. I agree that IBM has a great free product in OSC . . . → Read More: What DB2 Tools Do You Use Most? DB2 Version 9 offers a new way to handle testing out a new version of a DB2 application through the Plan Stability enhancements. The Plan Stability enhancements offer a way to save a static DB2 access package for an application and then BIND a new one. If the access package is not as efficient, Plan . . . → Read More: Plan Stability – Version 9 DB2 Performance Features – Part 20 Index design is one of the most important items or maybe the most important item in database design. Sometimes it is better to enhance the database with more indexes instead of trying to fix the application SQL. Tuning SQL is always good but tuning many SQL statements takes too much time. When time is tight . . . → Read More: Many New Index Options in DB2 – Version 9 DB2 Performance Features – Part 19 New DB2 9 for z/OS UtilitiesWithin the IBM Z Summit road show that was recently in Washington DC, the DB2 presentations highlighted a number of DB2 utilities improvements. All of these DB2 utilities improvements are integrated into the new DB2 10 but there were many that can be incorporated into . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 18 |    | ||
| Copyright © 2024 Dave Beulke - All Rights Reserved | Privacy Policy | Refund Policy Website by The Web Mechanic Powered by WordPress & AtahualpaClick to access the login or register cheese | |||