(Paul C. Zikopoulos) With custom folders in the DB2 Universal Database (DB2 UDB) Control Center, you can group systems and databases into folder artifacts that represent your business and can more quickly and easily perform DBA tasks. Walk through the steps to customize your Control Center view.

(Philip Gunning) Regardless of how well a RDBMS performs, the monitoring of SQL statements and resources is required to ensure continued good performance and to identify problem areas. Using the information gathered, adjustments can be made to instance and database configuration parameters, physica

(Chris Eaton) There is more to saying DB2 is optimized for SAP than just having the best performance. Of course if you want the best performing database for SAP, the benchmark results available here show that DB2 tops the list. But it takes a lot more than good performance to have a successful syste

(Ray Else) Learn the best practices of RedBack Object planning, creation, and use for an effective Web site. Poorly planned use of RedBack Objects could mean a slow-performing Web site (and an unnecessary load on your database server), whereas the well-planned use of RedBack Objects can mean a fast,

(Willie Favero) Continuing on from where I left off yesterday, let’s complete the discussion about multi-row processing in DB2 V8 with a few words about multi-row INSERT. My discussion of multi-row FETCH and setting up the arrays used by multi-row processing can be found in my entry posted on Januar

(Bob Swart) This article shows how to use Borland Delphi 2005 and the Enterprise Core Objects (ECO) to import an IBM DB2 Universal Database (DB2 UDB) database and create a UML object model for it, which is the basis for a .NET WinForms application. The object model (called EcoSpace) uses the DB2 UDB

(Ryan Graciano) WebSphere Information Integrator Content Edition (II CE) provides a single interface to any number of content repositories and workflow systems. This single interface makes it easy for application developers to integrate all of their information sources into new or existing enterpris

(Willie Favero) And finally, some actual detail about a DB2 for z/OS Version 8 feature. My first detailed entry will introduce you to multi-row INSERT and FETCH. This Version 8 SQL enhancement does exactly what you would expect. It allows you for the first time, to insert multiple rows or fetch mult

(Craig S Mullins) One of the most important areas for tuning DB2 subsystem performance is memory usage. DB2 for z/OS uses memory for buffer pools, the EDM pool, RID pool and sort pools to cache data and structures in memory. The better memory is allocated to these structures, the better DB2 will per

(Vikram S. Khatri) This article presents a logging framework that you can use with IBM DB2 Universal Database (DB2 UDB) stored procedures to log informational, error, and debug messages directly from the procedure itself. The logging framework methods use shared memory concepts to coordinate and cha