(Alex Osuna and Roger E. Sanders) IBM DB2 Universal Database (DB2 UDB) is configured to run on any system that meets its minimum hardware requirements. As a result, the basic configuration provided must be tuned to achieve optimum performance on systems that exceed the these requirements. Tuning a s

Occasionally, if the tablespaces in db2 isn’t system managed, it can get full. Your application might fail from… DB2 SQL error: SQLCODE: -289, SQLSTATE: 57011, SQLERRMC: TBSPNAME

(Vincent McBurney) DataStage 8 comes with some range lookup functionality within the lookup stage, a feature that came in at number four in my My top ten features in DataStage Hawk. A field on an input link can be compared to two fields on a lookup link or vice versa using a between clause returning

(Anant Jhingran) In 2001, I had been at the Almaden labs as the head of computer science for a few months. Almaden database folks — Hamid Pirahesh, Eugene Shekita, Bruce Lindsay, and a countless number of others — had started looking into what it means to do XML inside the database. New innovati

(Lydia Parziale, Hyun Baek, Javier Chavez, Vince Crose, Giovanni Grita, Theodor Kuebler, Georg Mayer, Heinz Ruflair, Mary Siart and Johannes Schuetzner) This book presents the SAP features for DB2 for z/OS V9 and for DB2 Connect V9.1. It demonstrates the best ways to exploit these new features to ac

(Mohankumar S P, Priyambada Behera, Radhika Gadde and Inge Halilovic) The IDS 11 release features significant additions over prior versions. It offers many new features for application developers, hierarchical data structure support, and improved query capabilities across multiple instances of the d

(Craig Mullins) DB2 9 for z/OS offers a new DDL parameter for your tables: APPEND. If you specify APPEND NO, which is the default, DB2 will operate as you are accustomed to it operating. That is, when rows are inserted or loaded DB2 will attempt to sequence them based on the clustering index key.

(Alex Osuna, Nailah Bissoon, Sunil Kamath, Jawahar Lal, Augie Mena and Roger Sanders) Currently, Ethernet bandwidth is eclipsing Fibre Channel and the cost of Ethernet is becoming more affordable than Fibre Channel. One question that has arisen is how NFS and iSCSI perform in comparison to FCP. This

(David Beulke) DB2 9 for z/OS has many new features that give database and application designers greater flexibility to solve business problems. I recently helped a client with an application design review and saw first hand how implementing many of these features can immediately and dramatically im

This exciting ninety minute webinar will examine the top 10 most compelling reasons that will convince managers, database administrators (DBAs), and application developers to install and deploy DB2 9 for z/OS as quickly as they possibly can! (R)