(Charul Kapil, Jaijeet Chakravorty and Manoj Sardana) pureQuery client optimization can improve the performance, security, and administration of Java database applications. The first article in this two-part series described how how to enable client optimization on a single application server node.

Getting Started with Adobe Flex is the latest free e-book in the On Campus series.

(Troy Coleman) When I attended IDUG NA 2010, there was, naturally, considerable buzz about the upcoming DB2 release. While there’s always hype surrounding these key releases, I think many folks at IDUG were genuinely excited about DB2 10.

(Aslam Nomani, Madhusudan K J and Santhees Kodi) The DB2 pureScale Feature builds on familiar and proven design features from the IBM DB2 for z/OS database software. This article describes how to deploy the DB2 pureScale Feature in a disaster recovery configuration. This configuration leverages the

(Keith McDonald) IBM released DB2 for LUW 9.7.2 recently and, along with numerous quality improvements, there were a number of interesting new features. In today’s post, I will talk about the “default parameters in UDFs” feature and how that helped me shrink the amount of code I needed to write for

(Michael Sansoterra) There are many non-IBM i developers out there who have opportunities to develop applications that interact with the i and its DB2 data store (aka AS/400, iSeries, i5, System i). These developers are many and varied and can include .NET and Java developers, Visual Basic and VBA d

(Luc Auvray) The goal of this article is to explain how to test a Web Service designed for IBM WebSphere Application Server 7.0 using IBM Rational Application Developer and IBM Rational Service Tester 8.x or IBM Rational Performance Tester with SOA extension.

(Kim May) IBM has moved DB2 Connect support into the Optim group, as it is in some ways the original Optim solution. Kathy Zeidenstein, who manages community outreach efforts for the Optim team (a weekly e-newsletter, content on the developerworks site, Twitter, etc.) is coordinating a DB2 Connect

Partitioned tablespaces greatly improve the speed and effectiveness of processing large tables within DB2. They also open the door to the optimizer for SQL query parallelism — a must for today’s large table sets. But when should you partition a table, and how do you determine its sizing? The right f

(Nancy Perkinson) DB2 access paths can be a daunting topic for non-DBAs, but a good understanding of them is very important if you want to be a successful Performance Analyst working in any DB2 shop. For this article, we will assume very little DBA background, but we will cover the basic points of