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.
Within a few months we’ll have DB2 11 for z/OS, which contains some important enhancements to DB2’s pureXML feature. In this article, Isaac Yassin takes a look back at DB2’s previous XML support before previewing some of the new features introduced in DB2 11.
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.
It's easier than ever to migrate Oracle applications to DB2. IDUG has organized a list of IBM Redbooks and IDUG conference presentations from IBM experts and from real-world DB2 users who've already made the switch.
In this article Jeff Lane presents a real life situation in which parallelism presented a performance dilemma. Do you tune for response time or reduced cost?