(Whei-Jen Chen, Masafumi Otsuki, Paul Descovich, Selvaprabhu Arumuggharaj, Toshihiko Kubo and Yong Jun Bi) As organizations strive to do more with less, IBM DB2 for Linux, UNIX, and Windows provides various built-in high availability features. DB2 further provides high availability solutions by leve

(Paul Zikopoulos) In the first thirteen parts of this series, I’ve introduced you to some of the many features available within the IBM Data Studio integrated development environment (IDE) that’s available for use with the IBM data servers. Specifically, I’ve shown you how to set up and use database

(Troy Coleman) Sometimes you need to look at the contents of a database request module (DBRM), which is typically stored as a member in a PDS file on z/OS. See the “Preparing an Application Program to Run” section of the “DB2 for z/OS Application Programming and SQL Guide” for more about DBRMs.

(Walker) One of the jobs of system administrator is to profile each server. This could be a simple job, but sometime it’s not as simple as it seems to be, especially for junior administrator.

(Timothy Prickett Morgan) The dividing line between a server and a disk array not only blurs from time to time. It also sometimes moves around. A system, of course, includes various servers as well as storage arrays, and the lines are less important. The AS/400 and its progeny have always been syste

What authorization and privileges are required to use Optimization Service Center to tune queries on a DB2 for z/OS subsystem?

(Jeffrey Benner) Have you, as a TSM or NetBackup backup solutions user, noticed multiple entries in LIST HISTORY BACKUP for each of your successful DB2 backups, each with a different image sequence number, and wondered why? If you are using multiplexing DB2 backup software such as TSM or NetBackup,

(Craig Mullins) I’m just now getting around to downloading the recently refreshed IBM DB2 9 for z/OS manuals. IBM updated almost all of the DB2 manuals in December 2008. Indeed, 19 of the 24 manuals listed have a publication date of December 2008.

(Henrik Loeser) Today I was pointed to the FAQ for XML:DB again and asked whether DB2 is a hybrid system or an XML-enabled database. In those FAQs they distinguish between a native XML database (DB), an XML-enabled DB, and a hybrid XML DB. So what is DB2?

(Willie Favero) “That’s a stage 2 predicate” is a cry that can strike fear into the heart and mind of an application programmer. What a terrible crime that someone may have just tried to perpetrate by choosing to use a stage 2 predicate. However, sometimes a stage 2 predicate isn’t used by choice bu