(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 second of two in a series that describes the top

(Mary Lynn Treadwell) If you’re like most IBM i (System i, iSeries, AS/400) customers, your staff members have relied on IBM Query/400 for years to generate simple queries of your DB2 database. Since its introduction with the AS/400 in1988, Query/400 has remained essentially unchanged and has its li

(Yee Ja and Julie Craft) Server virtualization enables you to rapidly provision new environments by using libraries of virtual image templates, or virtual appliances. Automated provisioning requires the management of operating system, network, and application-specific customization. This article pro

(Lester Knutsen) One important performance tuning step that’s often overlooked is to check how well Informix Dynamic Server (IDS) is handling locks and concurrency. In the Advanced Informix Performance Tuning class I teach, tuning locks is one of the top five items we use to improve performance.

(Axel Buecker, Simon Canning, Jay Devaney, Guillermo Rios and Satoshi Takahashi) Authentication is the act of verifying a user’s identity based on credentials that they have presented. Establishing each user’s identity is a critical first step in any client/server based system. In this IBM Redbooks

(Robert Catterall) I spent most of this past week teaching a DB2 9 for z/OS Transition class. In such a situation, it’s fun to get other people’s take on the new features delivered with this latest release of DB2 on the mainframe platform. One of the students had an interesting comment regarding the

(Josef Klitsch) Is your organization using or planning to use DB2 for z/OS stored procedures to provide business functions? Have you ever wondered how to reuse stored procedures without programming effort in Web services? If so, this article will be of interest to you.

(gopalv) pureQuery is IBM’s high-performance data access platform focused on simplifying, developing, securing, managing, and optimizing applications that access data. pureQuery provides access to data in databases and in-memory Java objects via its tools and APIs (delivered in IBM Data Studio Devel

This is a recording of the DB2 and Cloud Computing Chat with IBM 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).

(Henrik Loeser) Many of you know that parameters can be passed from the SQL context to the XQuery context. The functions XMLEXISTS, XMLQUERY, and XMLTABLE all have a “passing” clause that can be used to make constants, columns, or parameters available for XML-related expressions: