(Roger Sanders) Try your hand at these questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted with permission. Check back each week for more, and try past questions here.

(Troy Coleman) Last week I wrote about the DB2 secondary sliding scale space allocation feature in DB2 V8. DBAs often wonder about the impact of sliding scale allocation on their systems. Specifically, they want to know what the performance hit or CPU cost will be when they let their application run

(Paul Zikopoulos) So far in this series about the IBM Data Studio Developer 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 (

(Alan Marwick) While there are several different ways for a user to specify metadata conditions, this article discusses one that has special advantages: faceted navigation. Follow the faceted navigation system described in this article, a technology demonstrator based on IBM Omnifind Discovery Editi

(Willie Favero) Although I am part of the cast of thousands that keep the DB2-L list behaving as correctly as we can make it behave, I don’t always have time to answer as many DB2 questions on the list as I would like to. It looks like when I do have the time to answer the occasional question, it ap

(Paolo Bruni, Sabine Kaschta, Marcel Kutsch, Glenn McGeoch, Marichu Scanlon and Jan Vandensande) This IBM Redbooks publication helps you design, install, manage, and tune stored procedures with DB2 9 for z/OS. Stored procedures can provide major benefits in the areas of application performance, code

(Timothy Prickett Morgan) Our coverage of the forthcoming i5/OS V6R1 operating system continues this week with a hodge-podge of smaller enhancements and features that were rolled up into the January 29 announcements. IBM has made a bunch of tweaks to DB2 for i5/OS, logical partitioning, performance

(Willie Favero) I have a great one this afternoon. When I mentioned this APAR a few weeks ago it was still open. Well, APAR PK45916 has now been closed. This APAR eliminates the need for SORTNUM. The short description taken directly form the APAR cover letter: “DB2 utilities CHECK DATA, CHECK INDEX,

(Alan Marwick) While there are several different ways for a user to specify metadata conditions, this article discusses one that has special advantages: faceted navigation. Follow the faceted navigation system described in this article, a technology demonstrator based on IBM Omnifind Discovery Editi

(Peter Plevka) What is your biggest challenge in managing applications in a DB2 for z/OS environment? Is it keeping data and the application available 24/7? Is it meeting ever-more stringent service level agreements (SLAs), including optimal response time? Is it managing the ever-growing complexity