(Lester Knutsen) In my previous column, I discussed five useful new tables in the Informix Dynamic Server (IDS) 11 Sysmaster database. In this column, I’ll continue that list.

(Radhesh Kumar) If you need to find out dynamic SQL statements in the database package cache, you can do so using Dynamic SQL Snapshot. If you need to check the details of your application, you can use Application snapshot. If you are accessing application snapshot through table function, you have t

(Craig S. Mullins) Among the many new enhancements that have found their way into DB2 9 for z/OS is the ability to gather histogram statistics with the IBM RUNSTATS utility. This feature has been available in DB2 for Linux, Unix, and Windows for some time now, but after you migrate to DB2 V9 it will

(Willie Favero) While tracking APARs this week, I came across a couple that were Hipers so I thought I would point them out. I know of a lot of customers that not only track all hipers, they try to apply them on a weekly basis.

(Willie Favero) Today’s the focus is on OSC and OE. There were a couple of fixes published this week that could be interesting if you are a fan (or user (or both)) of these tools.

(Khurram Faraaz, Ronny Bartsch and Susan Malaika) In many systems that use XML, the XML schemas will evolve over time. In this article, you’ll learn how to handle those changes using DB2 pureXML Schema Registry (XSR) features, whether they are major or minor, and walk through an example of schema ev

(George Baklarz and Paul C. Zikopoulos) In this chapter you will be introduced to the DB2 family of products that run on the Linux, UNIX, and Windows operating systems. This version of DB2 is often referred to as the distributed version to differentiate it from the DB2 for z/OS version that runs on

(Mark Fontecchio) Along with i5/OS V6R1 is the DB2 that comes with it, and as there are enhancements in V6R1, so there are for DB2, IBM’s relational database management system. Let’s go over some of the details of those enhancements. (R)

(Paul Zikopoulos) So far in this series about the IBM Data Studio integrated development environment (IDE) that’s available with DB2 Version 9.5 (DB2 9.5), I’ve shown you how to set up database connection objects and the actions that you can perform on them. In addition, I introduced you (in Part 2)

(Roger E. Sanders) In my previous column, I mentioned that the enterprise database growth rate is about 125 percent annually. As databases grow, so does the need to preserve, protect, distribute, and derive value from the data stored in them. To help minimize storage requirements for growing databas