(Carmen K. Wong, Stan Musker, Manjula Panthagani and Joseph W. Baric, Jr.) Apply Label-Based Access Control (LBAC) to protect your data from illegal access, yet have the flexibility to allow users to restrictively access data. Create these and other LBAC solutions in this step-by-step guide based on

(Lester Knutsen) A lot has happened in the last month; I started this article on a plane trip to Beijing, China, and finished it after attending the IDS “Cheetah” T3 training at the IBM lab in Toronto, Canada. By the time you read this, IDS 11 (code-named “Cheetah”) will have been released. I though

(Paolo Bruni and Jeff Berger) In data warehouse applications, it is common to have many very large indexes defined on large tables. It is also possible that the index spaces exceed the size of the tables upon which the indexes are based. As one way of helping you to manage the cost of ownership, in

(Craig Mullins) Another IBM DB2 utility that has received some attention under Version 9 is MODIFY RECOVERY. For those not sure what this utility is, MODIFY RECOVERY is used to remove records from the SYSIBM.SYSCOPY table in the DB2 Catalog, along with related log records from the SYSIBM.SYSLGRNX di

(Paul R. Welka) This tutorial builds upon Part 1 of this series and illustrates a valuable feature of the product. In this step-by-step tutorial, learn how to set up compound document relationships. Specifically, you learn how to set up the document management system to maintain the relationship bet

(Willie Favero) And how do I know that? For starters, I just finished reading a paper by Julian Stuhler of Triton Consulting titled “DB2 9 for z/OS – Data On Demand”. If you know someone who needs a nice concise “to the point” description of the value of DB2 9 for z/OS, this is definitely the paper

(Francis DiNardo) This article describes a technique for handling exceptions across sequential invocations of multiple WebSphere Process Server Service Component Architecture business process components. It proposes the use of fault handlers in a pattern that allows the capture of exceptions as earl

(Willie Favero) Building on the excellent storage usage introduced in DB2 for z/OS Version 8, DB2 9 for z/OS has made more significant storage improvements of its own by moving more of the environmental descriptor manager (EDM) cache areas above the 2 GB bar.

(Wayne Ha and Patrick Zeng) Learn how to enable database high availability (HA) using IBM Linux, UNIX and Windows (DB2 V8 or DB2 9) High Availability and Disaster Recovery (HADR) capability in an SAP ABAP and Java dual stack environment, as well as how to enable automatic failover using IBM Tivoli S

(Roger E. Sanders) Label-based access control (LBAC) is a DB2 9 security feature that uses one or more security labels to control who has read access and write access to individual rows or columns in a table. In my previous column, I described how you can use LBAC to control who can access individua