It’s a term, and a concept, that has been circulating the DB2 for z/OS world ever since the introduction of DB2 Version 8. If you have ever visited one of the US larger fast food chains, they use the phrase as a catch all meaning to make everything just order larger (in many cases down right huge). We in DB2 land use it just in just about the same way.
For all of you that love to do performance and tuning of you DB2 subsystems, DB2 land is about to make your job a whole lot easier in the stored procedure and user-defined function (UDF) categories by improving some of the existing metrics and adding a few new ones.
The issue; a couple of numbers all lumped in together. The solution; more granularity, possibly right down to the individual stored procedure or UDF level, if everything gets set up correctly…… Continue reading »
Performance Availability Scalability
If you hang with DB2, what else do you want? What else could you ask for?
A few months back we (IBM) announced the DB2 Analytics Accelerator V2 (IBM United States Software Announcement 211-454, October 12, 2011) that combined all the things we’ve grown to love and expect from System z with the speed of Netezza. It was without a doubt the perfect marriage.. and almost everyone seems to want to hear more about it. This could be one of the hottest products I’ve seen come around it long time…… Continue reading »
If you are interested in improving the performance of your partition REORGs, here’s a code update that should be of interest. All you need to do is stay current on your maintenance and add an additional keyword here and there. Magically, you have better performance…… Continue reading »
Are you using or are you considering using sparse index scan? If yes, then you may want to keep this HIPER on your radar: APAR PM49154. It seems that during sorted work file scan, and I quote, “the new predicate evaluation mechanism took over even though it was not set up for such a scan. This resulted in millions of extra getpages for sparse index access.”….. Continue reading »
Even though something may be working as designed doesn’t necessarily mean it’s working as expected. This always seems to happen around performance stuff to me. In my experience, something that has unexpected performance can be far worse than something that has bad performance. Often, bad performance can be explained and possibly even corrected. However, when stuff happens out of the blue and catches you completely off guard, these can be the problems that can turn into real challenges to resolve…… Continue reading »