This IBM Redbook describes the benefits of DB2 V8 for SAP. It explains why to run SAP BW in a zSeries environment. It also lists best practices and provides performance and tuning recommendations.

(Carla Sadtler, Philipp Huber and SangMin Yi) Successfully implementing a service-oriented architecture (SOA) requires applications and infrastructure that can support the SOA principles. Applications can be enabled by creating service interfaces to existing or new functions hosted by the applicatio

(Chris Eaton) Now that you have seen how grouping sets work, think about how you can use them to speed up your business intelligence queries.

(Willie Favero) In 1966 “the Beach Boys” coined the phrase “Wouldn’t it be Nice” in one of their hit singles. Everyone has a “Wouldn’t it be Nice” list in the back of their mind for something. Some even have a list for stuff they would like to see someday in DB2. So, I thought an entry talking about

(Jin Ji Wen and Shen Yu) Today, many exciting business events take place in non-English speaking regions. For example, Arabs are leading in the petroleum business and the Chinese are leading in the textile space. Merchants from these countries or regions feel more at ease when communicating in their

(Roger E. Sanders) Q: In your recent column on split mirroring [Distributed DBA, Quarter 4, 2005], you write that the SET WRITE RESUME command must be executed from the same database connection that has executed the SET SUSPEND command. What do you do when this session has abended? (The same problem

(Bill Moore, Martin Keen, Antonio Carvalho, Michael Hamann, Prasad Imandi, Ron Lotter, Philip Norton, Christian Ringler and Gabriel Telerman) IBM WebSphere Enterprise Service Bus is a flexible connectivity infrastructure for integrating applications and services, designed to enable the development o

(Paolo Bruni, Bhaskar Achanti, Suneel Konidala, Glenn McGeoch, Martin Packer, Peggy Rader, Suresh Sane, Bonni Taylor and Peter Wansch) This IBM Redbook helps you design, install, manage, and tune stored procedures with DB2 for z/OS. Stored procedures can provide major benefits in the areas of applic

(Andreas Breitfeld) Find out how you can install one of the two major enterprise Linux distributions and configure it for running IBM Informix Dynamic Server (IDS) Version 10.0. You’ll learn how to get a trial version of the IDS database server up and running and how to use a disk as a raw device.

(Ted J. Wasserman) The DB2 UDB auditing facility is an important security tool in the DBA’s toolbox. It generates and allows a DBA to maintain an audit trail for a series of predefined database events. It is capable of logging database events such as authorization checking, database object maintenan