(Craig Mullins) With today’s posting we return to our examination of the new features of DB2 9 for z/OS. With V9, DB2 storage groups can be better integrated with SMS storage classes.

(Gene Cobb) In July of 2007, IBM announced DB2 Web Query for System i, a product positioned as a query and reporting tool for the System i and the strategic enhancement to the Query/400 tool. DB2 Web Query has many advantages over Query/400. Most notably, it provides modernized development and end-u

(Whei-Jen Chen, Ivo Rytir, Paul Read and Rafat Odeh) In this book, we discuss the existing and new DB2 security features introduced in DB2 9.5 for Linux , UNIX, and Windows . These enriched DB2 security features provide you the capability to protect your data and comply with regulatory requirements.

(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 Sanders) If DB2 9 DBA certificiation is on your list of resolutions this year, spend some time looking over some sample questions to help you prepare. Here are more questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC P

(Troy Coleman) Over the years database administrators have had to deal with locking issues and performance. IBM has continued to improve DB2 by reducing the number of times applications take locks and or reduce the amount of time a lock needs to be held. The general term for this is optimistic locki

(Nikesh Jauhari) Commercial databases such as Oracle and IBM DB2 can maximize performance by using raw I/O. One may use the raw command for both IDE and SCSI devices. This will map a raw device to a blocked device for an entire disk partition.

(Willie Favero) If you have completed the DB2 Version 8 enabling new function mode (ENFM) step, you know that your catalog has been converted to Unicode, or at least most of the catalog. There are a couple tables that remain in EBCDIC, but that’s not really big news anymore. What does occasionally c

(Prasanna Alur Mathada and Dhanashri Kudgavkar) IBM Informix Dynamic Server is well known for its ease of administration. When you combine it with Server Studio, administrative tasks become even easier. Learn how Server Studio’s proven tools for DBAs and developers emulate natural workflow and impro

(Willie Favero) In an effort to make this blog a little more interesting and to possibly add a little structure, this year I am going to feature an APAR each week (I’ll try for Friday’s) that I think sounds interesting. In most cases I will be avoiding APARs that fix something that broke unless it i