(Troy L Coleman) The stored procedure DSNUTILS has been deprecated as of Db2 12. It’s used to call utility program DSNUTILB using EBCIDIC encoded parameters. While your application will continue to function when DSNUTILS is called, it could be removed from future releases.

(Craig S. Mullins) IBM has improved the availability of accessing Db2 Catalog objects when maintenance is being run in Db2 12 for z/OS. This impacts access during CATMAINT and online REORG.

(Troy L Coleman) With the introduction of continuous delivery making it possible for customers to put new features into production through regular maintenance, awareness of Db2 function levels takes on greater importance. So how do you determine what level you’re at and what level of maintenance has

(Jeffery Andersen) Creating regular backups is a critical step to recovering from a disaster. Restoring the database is arguably the most important and time-critical portion of the backup and restore process. This IBM Redbooks web doc describes the following elements that are critical to a successfu

(Robert Catterall) In this, the fourth of a set of four entries covering SQL enhancements introduced with Db2 12 for z/OS, I will describe new trigger capabilities delivered by way of what are called “advanced triggers” (the kind of trigger that you could define prior to Db2 12 — and which you can

(Lockwood Lyon) The size of a data warehouse may make it a poor performer for tactical analytic queries. After all, these are typically used in real-time as part of customer transaction processing.

(Dave Beulke) After data validation, in most instances SQL performance is the most important big data performance factor in big database applications. Understanding the fine details of DB2 SQL performance tips can make a huge difference in processing time, especially true when going against a big da

(Joe Pluta) I like to use SQL primarily as a query tool. Its very name—Structured Query Language—sort of leans you in that direction. It’s also an excellent tool for set-based updates, as its many proponents will tell you.

(Craig S. Mullins) If you’ve worked with Db2 for z/OS for awhile (note to IBM: I still have a problem with that lower case “b” but I’m trying), particularly as a DBA, you’ve almost certainly had the opportunity to use the DSN1COPY offline utility, sometimes called the Offline Copy utility.

(Michael Roeckon and David Sciaraffa) With the many new features introduced in 11.1.2.2, not to be overlooked are some of the enhancements made in the area of Recovery and Availability. The team has been hard at work: