As DB2 reaches its 30th anniversary and IDUG reaches its 25th anniversary, I’ve thought about many DB2 tips and best practices that have been incorporated by companies, projects and applications that have led to great successes. The ones that have been most common and have had the greatest impact a
In this session, Melanie will present analogies and insider advice to help you improve performance, availability, reliability, recovery and usability. Come learn new ideas, tips and enhancements that you need to know when using various DB2 LUW Utilities.
Ever since IBM introduced DB2/2 for its OS/2 operating system back in 1987, the DB2 community has been divided into two camps: those that mainly use DB2 for z/OS on IBM’s high-end System z mainframes, and those that spend most of their time using DB2 for Linux, UNIX and Windows...
With large tablespaces, well designed NPIs can improve query performance but can create performance and availability challenges. DPSIs can help, but have their own compromises. In this article, Toine Michielse provides an overview of some DPSI-related enhancements coming in DB2 11 for z/OS.
As with any new release of DB2 for z/OS there comes a host of SQL performance improvements. In this article, Dan Luksetich outlines a few interesting SQL enhancements coming our way in DB2 11 for z/OS.