This tutorial demonstrates the use of the advanced features of the IBM DB2 Development Add-In for Visual Studio .NET to create and deploy SQL stored procedures from a development environment to a production DB2 for z/OS database environment. (R)

Red Hat Enterprise Edition 3.0 and Red Hat 9.1 are not DB2 UDB supported versions. Installing DB2 UDB on these two Red Hat version requires a work-around. This technote provides the work-around when db2setup is used.

(David Martineau, Steve Sanyal, Kevin Gashyna, and Mike Kyprianou) Database applications provide programmers with the challenge of utilizing DBMS resources efficiently. DB2 provides rich features such as UDFs, stored procedures, concurrency, and transaction management. Using these features properly

I thought that the DB2 v.7 for z/OS ZPARMS SRTPOOL and MAXRBLK referred to the global respective sort spaces, but I recently read somewhere that they refer to SORT and RID SORT pools for each individual user. Mine are each set to 8,000 (4K, pages). If what I read is true, I’m worried that I’m crowdi

(Hernando Bedoya) Stored procedures, triggers and User Defined Functions are the key database features for developing robust and distributed applications. In V5R1, SQL Triggers are supported on DB2 Universal Database for iSeries to give much more portability to the database. This IBM Redbook inc

(Joyce Bischoff) In contrast to a traditional transaction processing system, the process of designing a data warehouse is iterative in nature. We take a first cut at the warehouse design and wait for feedback from users regarding changing requirements – and change they will. It is only after users a

(Serge Rielau) Views are commonly used to separate the logical DB2 schema from the physical schema. This article assesses which views are updatable on their own, and then introduces a feature new with DB2 UDB V8.1 called INSTEAD OF triggers which makes all views updatable.

How do you ensure simple yet secure access to your organization’s applications and data? The answer is Web enablement, which provides a common infrastructure for building integrated solutions. The result: You can pull together data from across your enterprise, and also integrate data from suppliers

(Robert Catterall) If you’re a regular reader of this column, you probably know that my technical background is primarily in DB2 Universal Database (UDB) for z/OS and OS/390. I like to write about what I know, and what I know best is DB2 on mainframe servers. In recent years, however, I’ve learned a

(Barrie Sosinsky) You can take a number of steps to reduce the time it takes to perform a restore operation. First, you should optimize the use of your buffers. Make sure that the restore buffer is a multiple of the buffer that was used during your backup, and that that buffer is a multiple of the e