(Vikram Khatri) Finally DB2 implemented a long standing demand for setting the Java application name so that you could see the name through DB2 utilities instead of seeing db2jcc_applica.

(Alice Ma and Ute Baumbach) Performance monitoring and tuning are critical tasks for a database administrator (DBA). DB2 Performance Expert helps DBAs tackle immediate performance problems, as well as avoid problems in the future. This article is the first of two in a series that describes the top 6

(Cynthia M. Saracco and Matthias Nicola) DB2 9.7 for Linux, Unix, and Windows offers new pureXML capabilities for integrating XML data into data warehouses, business intelligence environments, and operational data stores. Enhanced scalability, improved support for analytic applications, and new admi

(Dave Beulke) Java performance is often a problem because the application processing is emulating the database which executes more efficiently or the processing is poorly designed. Either of these scenarios that my teams have found during performance or design reviews always led to extended I/O act

(Pamela Siebert, Veronica Gomes and Jing Shan) The new IBM Informix Warehouse Feature provides an integrated and simplified software platform to design and deploy a warehouse repository on your existing IBM Informix Dynamic Server (IDS) infrastructure. This tutorial, the beginning of a series, gives

(Alex Woodie) Guardium has added support for DB2/400 (DB2 for i) with its database security software, the company announced this month. Guardium’s software monitors all major database management systems in real time for signs of unauthorized or malicious activity from internal and external threats,

(Yingxin (Nicole) Xing and Caroline Daughtrey) Learn how to monitor and administer human task processes using the IBM WebSphere Business Monitor dashboard. This article shows you how to personalize the user interface, manage human tasks, and configure the dashboard for dimensional analysis.

(Roger E. Sanders) How do I spread 150GB over Logical Unit Numbers (LUNs)? Would it be a problem if a storage person gave me only one directory (mount point) on one LUN? If the data is to be spread over many LUNs, how do I calculate the optimal number of LUNs (2, 3, or 4)?

This is a recording of the DB2 and Cloud Computing Chat with the Lab held in Mar 2009. It outlines the IBM Cloud Computing strategy for DB2 database for Linux, UNIX, and Windows and describes various Cloud related DB2 offerings such as AMIs for Amazon’s Elastic Compute Cloud (EC2).

(Craig 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 perfo