Tag: IBM

Community

Parlez-Vous BI?

(Robert Catterall) Does this scenario sound familiar? You’re a DB2 DBA with years of experience managing operational database systems. You’re in a meeting in which some business intelligence (BI) experts – your colleagues or consultants – are discussing various aspects of a new DB2-based decision-su

Community

CICS IA Sample SQL Queries

IBM CICS Interdependency Analyzer starter set of CICS online queries is helpful for quick, relatively simple queries. However, virtually any possible query can be done by bringing to bear all the power of SQL on the DB2 database. Some customers have found that they already have DB2 information r

Community

High-performance SQL

(Serge Rielau) This article introduces advanced SQL features which are being used in IBM DB2 Universal Database (UDB) for Linux, UNIX, and Windows (DB2 UDB for LUW) TPC-C benchmarks. Find out how to use these features in everyday customer environments.

Community

Monitoring Performance, Part 3

(Roger E. Sanders) In two previous columns in this series, I explained the two kinds of tools that make up the Database System Monitor: a snapshot monitor and event monitors. The snapshot monitor captures information about the current state of an instance and/or database at a given point, while even