(Roman B. Melnyk) Two DB2 utilities, db2move and db2look, can be used to clone databases when there is no support for cross-platform backup and restore operations. This article provides an overview of these utilities and gives a step-by-step example of how to clone a DB2 database using this approach

(Chuck Ballard) In this IBM Redbook we discuss primary processes and various alternatives that prepare you in implementing a DB2 near-realtime business intelligence environment. We discuss architectural alternatives and include overviews of software products that you can use in an implementation. As

(Whei-Jen Chen) This IBM Redbook discusses the integrated environment of DB2 UDB and WebSphere Application Server (WAS), including design considerations, best practices, operation, monitoring, and performance tuning. We provide an overview of the architecture and main components of both WebSphere

(Alexander Kuznetsov) First introduced in DB2 UDB V8.1, INSTEAD OF triggers are very useful when you need to modify the database structure without changing the applications running against the changed database. In other words, you may use INSTEAD OF triggers and views to isolate applications from ch

(Andrew Ward) DB2 for z/OS v.8 provides a host of partitioning changes that bring better query performance, more efficient use of utilities, and other benefits of true physical partition independence.

(Bruce Miller) Business applications are brimming with documents, email, and other information in electronic form. Any document, email, or similar item created in the conduct of the business mission (especially if it records or contributes to a business decision) is a corporate record and, therefore

(Nick Adams) A set of classes to encapsulate DB2 CLI APIs in ADO style.

(Kent Milligan) This article explains what cursor sensitivity is and how it’s programmatically controlled on DB2 UDB for iSeries. In addition, the article covers the performance impacts of using the different cursor sensitivity settings.

(Craig Mullins) Our applications use a lot of timestamp columns. My question concerns the storage of timestamp values and nulls. When a null indicator is set to X’FF’ (indicating a null value), DB2 requires at least one byte of space for the null indicator. What does DB2 allocate for the “empty” dat

DB2 Information Integrator enables real-time integrated access to heterogeneous data such as relational databases, XML documents, queues, and text files. It can all be transparently accessed from a common platform and combined using the power of SQL. In this tutorial you’ll use DB2 Information Integ