(Troy Coleman) As a DBA or application developer, you’ve likely performed some task that you wish DB2 would handle for you. One way to get IBM’s attention about such things is through IDUG, which regularly compiles requirements suggested by DB2 users and delivers them to IBM for its evaluation. (IBM

(Mike Cain) As I travel around the world engaging clients, one question that I am always asked is “Do we need a DBA”? Sometimes, the question takes the form of apparent confusion, such as, “We have an SQL Server DBA. We have an Oracle DBA. Why don’t we have a DB2 for i DBA”? In other situations, I h

(Bryan Patterson and Dexiong Terry Zhang) Over the past 10 years, companies have significantly increased their use of XML data for business-to-business messages and internal business modeling, which in turn has created demand for managing and reporting on this data. DB2 pureXML is being used more an

(Paolo Bruni, Joel Gauci, Sabine Kaschta, Josef Klitsch, Pallavi Priyadarshini and Rajesh Ramachandran) Flexibility in business has become of equal in importance with operational efficiency. Service-oriented architecture (SOA) can help businesses respond more quickly and cost-effectively to the chan

(Khurram Faraaz, Ronny Bartsch and Susan Malaika) Many XML capabilities were introduced in IBM DB2 9 and 9.5 through the pureXML feature. In this article, see how you can exercise administrative functions, such as XML metadata management, and application development functions, such as XML manipulati

(Dave Beulke) Last time we talked about excess tablespace scans, list prefetch and index scans. Let’s look further into potential application performance issues.

(Vikram Khatri) If you have DB2 scripts that you want to run through your Java programs, you normally use Runtime.getRuntime().exec method to run system commands. The following sample code tells how to run DB2 scripts.

(Paul Zikopoulos) In the first part of this series, I showed you how to use Microsoft Access 2007 as a graphical front end to a back-end IBM DB2 data server. Specifically, I showed you how to implement linked tables and create an abstraction layer over those linked tables such that information worke

(Vitor Rodrigues) IBM pureQuery and IBM DB2 pureXML are revolutionary database technologies in their fields. pureQuery is a high-performance Java data access platform focused on simplifying the tasks of developing and managing applications that access data from a database. pureXML is the native XML

(Radhesh Kumar) While analyzing slow response or poor database performance, you might be curious to know where a database request spends time. This information will feed to database performance intelligence and guide the tuning effort in the right direction. However, I doubt if anyone ever found a s