(Abhiram Jayaram) Ever wondered if the data generated by the execution of an SQL statement could be reported in the form of a XML document? If so, this article is for you. It explains how the output of an SQL statement can be reported in the form of a XML document.

(Bill Wilkins) Improving the performance of database inserts is very important to managing a database, especially in an OLTP environment. This article explains exactly what happens when an insert occurs, looks at alternatives, and examines issues that affect insert performance, such as locking,

Have you considered how the latest database technology can improve your development productivity? If so, the database that has helped many developers is DB2 UDB – for mixed environments including Linux and Windows. There are many new features available to developers and DBAs in the next release of D

(Howard Goldberg) Monitoring the health of an UDB instance and its associated databases is one of the many tasks that a DBA must perform on a daily basis. One of the tools a UDB DBA uses is the DB2 "get snapshot" commands. These commands obtain a point in time snapshot of the database’s critical per

As part of our disaster recovery procedures, we try to get the (4-way) DB2 data sharing group up and certain critical applications running within the first 2 hours after a disaster has been declared. To accomplish this we have the following: –A dedicated MVS logical partition (LPAR) running at

When you execute a SELECT COUNT(*) statement to retrieve the count of all records in a table against a linked DB2 server on a mainframe that is using it’s four-part name, the following error message occurs: Server: Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing a query fo

(Paolo Bruni) DB2 Performance Expert for z/OS is the most reliable tool for monitoring and tuning your DB2 for z/OS environments. In addition to a wide range of comprehensive reports, the tool analyzes performance online and recommends changes for DB2 performance-related settings. It is comprised of

Registration is now live. Register before 17 September to save! The International DB2 Users Group (IDUG) invites you to the premiere European DB2 education event: IDUG 2004 – Europe. The conference will run Monday – Thursday, 11-14 October, 2004 at Prague, Czech Republic. Experience four days of

(Craig S. Mullins) One of the most intriguing new features of DB2 for z/OS V8 is the ability to code recursive SQL. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of recursion is to think about a mirror that is reflected into another mirror and when

(Kulvir Singh Bhogal) Cached Row Sets are a new offering of Java 1.5 emerging from the efforts of JSR114. This new capability enables you to have a serializable disconnected object. This means you can connect to the database, grab your data in the form of a result set, release the connection and man