(Willie Favero) This is the webinar many of you have been waiting for. I know I have. On January 28, 2014 at 11:00 AM EST (4:00 PM GMT) it will be time for Terry Prucell’s to tell us all about the query performance improvements being brought about by DB2 11 for z/OS. Whether you’re a programmin
Tag: IBM
Hey, Let’s Check the Catalog!
(Mike Cain) My long time friend and teammate Kent Milligan has some great insight and advice for an often overlooked feature of DB2 for i – the catalog.
DB2 for z/OS: Monitoring Prefetch Read Activity
(Robert Catterall) Not long ago, a colleague sent to me some DB2 for z/OS buffer pool activity data that a DB2-using organization had sent to him. The DB2 people at this site were alarmed by some of the prefetch-related numbers in the data, and they had requested a review of the information.
Best Practices For Optimizing DB2 Performance
DB2 performance tuning and optimization is a complex issue comprising multiple sub-disciplines and levels of expertise. Mastering all of the nuances can take an entire career. Deploying standard best practices can minimize the effort to achieve efficient DB2 applications and databases. (R)
In-memory? That’s so yesterday!
(Philip Howard) Not for the first time, IBM has been underselling itself. I refer specifically to DB2 with BLU Acceleration. Given this second sentence you might be surprise at the first: IBM has been heavily marketing BLU. However, it’s true.
APAR Friday: An improvement in REORG messaging and JSON support
(Willie Favero) I’m doing something a little different today… I’m actually publishing an APAR Friday post on Friday.
Using a Statistical View to Improve Query Performance
(Ember Crooks) Sometimes just using the index advisor and a bit of common sense, you can address SQL performance issues. But other times, you have to dig a bit deeper.
A couple of DB2 11 Redbooks available
(Willie Favero) Yup, there are a couple of new DB2 11 for z/OS Redbooks available for download already.
DB2 Tips n Tricks Part 19 – How to Find and Fix Invalid DB Objects
(Harishkumar Baburao Pathangay) How to Find and Fix Invalid DB Objects Admin View : SYSCAT.INVALIDOBJECTS Admin Proc : SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS
5 Performance Tips from the 2013 Holiday Rush
(Dave Beulke) Since this holiday season is shorter and more people hate the mall crowds, billions will be spent online this season. Unfortunately for management, lack of application development testing, up-to-date standards, and performance procedures will hinder profitability through poor performa
