(Chris Eaton) DB2 has what are called “monitor switches”. These are settings that instruct DB2 to gather more specific information if a given switch is turned on. There is however a wealth of information that can be obtained without having to turn any switches on.

(Ted J. Wasserman and Raul F. Chong) Granting database access, authorities, and privileges to users and groups is one of the primary means of ensuring the security of your data. This article describes the different user and group accounts that are needed to install and work with IBM DB2 Universal Da

(Robert Catterall) Could you provide some recommendations for conserving disk space on a mainframe?

(Alex Woodie) When IBM revealed it was leaving the market for online analytical processing (OLAP) software earlier this month, it spawned competing ideas as to why Big Blue was abandoning such a profitable sector of the software market, and what its business intelligence strategy would be going forw

(Chris Eaton) In preparing for the upcoming International DB2 User Group (IDUG) European conference, I thought I would post a set of entries on one of my presentation from last year. For those interested, this year the IDUG European conference is being held in Berlin from October 24-28,2005.

(Paul McInerney and Danny Zilio) Get expert help with designing data partitioning keys, materialized query tables, and multidimensional clustering for IBM DB2 Universal Database (DB2 UDB), in addition to indexes. The Design Advisor offers the help you need and is built right into DB2 UDB. Here’s how

(Joe Pluta) In a recent article, I introduced the new Eclipse-based Rational tools and did the best I could to explain how they relate to the existing Eclipse-based WebSphere Studio tools. In essence, the primary connection is that they are Eclipse-based. That, and the fact that IBM renamed the WebS

(Dwaine Snow) Performance is one of the most important keys in any type of database system. This chapter focuses on a number of performance tuning tips with DB2 Universal Database (UDB). Although some tuning tips are the same, regardless of the database workload, there are differences between OLTP-

(Shahed Quazi) Looking for a high availability solution for IBM DB2 Universal Database (DB2 UDB)? This article provides a visual explanation of split mirror using suspended I/O for DB2 UDB for Linux, UNIX, and Windows databases and explains the details of various implementation scenarios. Learn how

(Kent Milligan) I need to “import” a text file located in the user computer, to a DB2 table in the database, what’s the best way to do this? (R)