(Chris Eaton) The concept of a tablespace in DB2 for LUW is pretty much identical to that of DB2 for z/OS. That is, a tablespace is a storage management concept and is an object that you put tables in. So tables live in tablespaces and a tablespace is an object that has physical storage associated w

(Dwaine R. Snow) In Version 8, DB2 introduced two new features to help you monitor the health of your DB2 systems: the Health Monitor and the Health Center. These tools add a management by exception capability to DB2 Universal Database by alerting you to potential system health issues. This enables

(Kent Milligan) Is there a way to have a dynamic IN clause embedded in a COBOL program? (R)

(Joe Pluta) To finish the (admittedly somewhat lame) analogy of health clubs, once you get a regular routine, it’s easier to keep at it. But why do Preventive Service Planning (PSP) at all? And why is it so much more complicated for WebSphere users? The answer to the first question is simply that th

(Greg Crawley) New features in DB2 UDB v.8.1 help DBAs move tables faster. DBA’s are always looking for quick and easy ways to move tables into new tablespaces. Sometimes table moves are necessary because tables are getting too big; sometimes because grouping a set of tables in a particular table

(Scott Simmons) Last month’s article introduced the WebSphere Integration Reference Architecture, as well as an SOA framework and some services. This month’s concludes by looking at more services and showing the architecture in action.

(Dwaine R. Snow) While databases are becoming more and more self-aware and self-healing, they still require some monitoring to keep them running as efficiently as possible. Just like your car, a database requires a tune-up every once in a while to keep it running optimally.

(Lorysa Bond) One of the hot topics we see in customer support is locking. “Why does DB2 lock this table, row, or object?” “How long is the lock held, and why?” “Why did I get a deadlock?” “What is my lock request waiting for?” Looking in closer detail at some common locking examples can help illust

(Robert Catterall) Choices related to primary key selection are among the more important decisions made in developing a database design to support an application. In this column, I would like to share with you some of my thoughts about primary key selection for a DB2 database.

(Paola Bari) This IBM Redbook gives a broad understanding of the Workload Manager component of the z/OS system. It covers basic aspects of Workload Manager (WLM) together with the new functions available in the z/OS release up to z/OS 1.7. The book provides a discussion on how to create WLM policies