(Yongli An, Tsz Kin Tony Lau and Peter Shum) Performance and scalability are essential for your e-business systems. While your business is growing, you need more power on your e-business site to support more customers. This paper documents the technical aspects of a scalability study that demons

As the demand to meet user and customer information requests continues to grow for today’s businesses, the use of DB2 Stored Procedures is on the rise. Are you prepared? Get to know the underlying basics and learn how to get started on your WLM implementation with your current version of DB2 today.

(Naveen Balani) This tutorial shows developers how to render PDF applications using DB2 SQL/XML functions, WebSphere Studio Application Developer (Application Developer), and the Apache Formatting Objects Processor (FOP) project. (R)

The SUM. column function calculates the total of all values in a column for selected rows. It applies to a group of numbers and returns a single value for each group of numbers to which it is applied. You can use the UNQ. operator with SUM. to request that QMF use only unique values when calcula

(Wally Terhune) This article is written to assist with the problem determination process for someone administering or supporting IBM UniData databases. If you’re faced with a puzzling problem, here are some questions to ask in order to zero in on the problem, and actions to take to solve it.

(David Beulke) Attendees of the International DB2 Users Group (IDUG) North America conference held in May in Orlando, Fla., learned firsthand about the new application development and other features of the next release of DB2 Universal Database (UDB) for Linux, Unix, and Windows v.8.2. For those

(Craig Mullins) I have a query which selects from DEC fields and displays as follows: .00 100.00 I would like some formatting to display it as: .00 100.00 Is there any way of doing this? (R)

This document describes, step-by-step, how to access DB2 data through Lotus Approach 9.5.

(Bob Swart) This article examines the design and implementation of a Borland Delphi application you can use to create or delete/drop IBM DB2 Universal Database tables inside IBM DB2 databases. It provides several examples of sending SQL DDL to the DB2 DBMS using Delphi and the cross-platform dbExpre

(Jennifer deJong) While much of IBM Corp.’s efforts are focused around Linux, Java and WebSphere, the company is continuing to evolve its CICS tools, with two new product updates.