(Dorian Pyle) In part 1 of this column, I discussed assessing risk (in other words, estimating the probability that an adverse consequence will result from some action). After the column was published, readers reminded me of a truth about risk: It’s inherent in every activity, even writing (or readi

(Craig Mullins) I have a batch process that updates my DB2 tables and issues commit at a certain interval within the program. If I ran the process concurrently, with say five jobs, and one of them abends, will the rollback affect my other four jobs (R)

(Paolo Bruni) This IBM Redbook helps you design, install, manage, and tune stored procedures with DB2 for z/OS. Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. DB2 has offered an ever improving support for developing and

(Sylvia Qi and Michael Dang) Understanding how DB2 uses memory prevents you from over-allocating memory, and helps you tune memory use for better performance. This article teaches you the basics of DB2 memory usage and the concepts of shared memory and private memory. These apply to both 32-bit a

This tutorial shows you how to build asynchronous applications using DB2, WebSphere MQ and WebSphere Application Developer. First, you will create DB2 WebSphere MQ user-defined functions using the DB2 Development Center. A Web-based application is used for posting and receiving messages from the

(Lance D. Bader) Cloudscape is a database manager implemented in Java. Tomcat is the reference servlet container implemented in Java. This article is a cookbook, providing step-by-step recipes for integrating the two of them in three common scenarios: the prototype integration, the casual integratio

(Clint Boulton) The concept of information lifecycle management (ILM) continues to get ringing endorsements from the storage sector’s top companies. The latest vendor to throw its support the ILM way is StorageTek (Quote, Chart), which plans to announce archive software geared to help administrators

(Bob Swart) This article examines IBM DB2 Universal Database metadata in order to dynamically build views and forms, including how to dynamically generate a new CLX form and stream the form as a Delphi .pas and .xfm file, ready to be added to Kylix and Delphi CLX projects .

(Grant Hutchison and Kulvir Singh Bhogal) DB2 Universal Database (UDB) for Linux, Unix, and Windows version 8.2 supports many types of Java programs, including those used in client applications, in application servers, and in the DB2 UDB server itself in the form of stored procedures or user-defined

Have you considered how the latest database technology can improve your development productivity? If so, the database that has helped many developers is DB2 UDB — for mixed environments including Linux and Windows. There are many new features available to developers and DBAs in the next release of D