(Willie Favero) This afternoon I thought it would be fun to talk about a change in how parallelism affects your access path selection in DB2 9 for z/OS. Because of that change, we will also need to discuss a new DSNZPARM is being introduced by APAR PM16020 that throws some controls at how the optimi

(Florian Funke, Peter Gerstl and Benjamin G. Leonhardi) This article gives an end-to-end example of how an Open SQL query that handles arbitrary JOINS between SAP tables that are not known during coding time can be executed dynamically. You will learn how joins are done in Open SQL, how to specify t

(Susan Visser) The next Chat with the Lab session will focus on DB2 pureScale:

(Troy Coleman) Recently a user identifying himself as new to DB2 for z/OS posted this question on the DB2-L list server: “What is the difference (if any) between DB2 creator, schema qualifier and owner?”

(Julian Stuhler) For many years, DB2 for z/OS has been able to provide mainframe users with unmatched levels of resilience and scalability courtesy of some rather neat technology known as data sharing. This makes use of IBM’s Parallel Sysplex technology to allow many DB2 subsystems (or “members”) to

(Paolo Bruni, John Iczkovits, Hennie Mynhardt and Peter Zerbini) This IBM Redbooks publication will help you tailor and configure DFSMS constructs to be used in a DB2 9 for z/OS environment. In addition, it provides a broad understanding of new disk architectures and their impact in DB2 data set man

(Willie Favero) This afternoon I thought it would be fun to talk about a change in how parallelism affects your access path selection in DB2 9 for z/OS. Because of that change, we will also need to discuss a new DSNZPARM is being introduced by APAR PM16020 that throws some controls at how the optimi

(Shao Hong Xu) The IBM Enterprise Content Management Widgets (ECM Widgets) product is gaining traction in banking, insurance, health care, and many other fields. The ease of use and programming-free nature of the widgets enable business application developers to quickly produce content management ap

(Scott Hayes) Did you miss today’s episode of The DB2Night Show? No worries. Replays are now available for your download and enjoyment!

(Lockwood Lyon) Many critical business applications now execute in an environment separate from that of the enterprise database server. The database administrator often finds monitoring and performance tuning of these "distributed" applications to be especially difficult. This article looks at commo