(Susan Visser and Bill Wong) Although the DB2 documentation covers the installation and configuration of DB2 servers and clients, this chapter provides more detailed instructions on installing the server. (Day 6, “Installing and Configuring DB2 Clients,” shows how to install the DB2 clients.) I also

(Sylvia Qi and Raul F. Chong) This article provides step by step instructions on how to setup Veritas NetBackup to work with DB2 Universal Database (UDB). It also provides examples of how DB2 UDB backups and restores work.

(Maria Almeida) Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. The DB2 Family of products has offered support for stored procedures for some time, with each release offering significant enhancements over the last. In the

(Robert Catterall) A DB2 statistics report can be the key to better performance. In my previous column, I wrote about DB2 for OS/390 and z/OS monitor statistics detail reports. I ended the column after covering data set open/close activity; in this column, I pick up the story with a quick look a

(Martin Hubel) When I speak to user groups on DB2-related topics, I pretend to confide a DB2 secret: There will be performance improvements in the next version of DB2. Since 1986, I’ve never been wrong. And DB2 Universal Database (UDB) for z/OS version 8 certainly keeps my prediction streak alive. I

(Bob Swart) This article demonstrates several ways to perform data entry input validation in ASP.NET applications on top of IBM DB2 UDB database tables.

(Paul Yip) This article is a sequel to an earlier article, Advanced SQL Procedural Scripting in DB2® v7.2. This article provides you with new insights, tips, and tricks. Because this article was written in reaction to feedback from those who read the first article and as the result of additional que

Before you install DB2, you should make sure that your system meets DB2’s hardware and software requirements. If you are migrating from a previous version of DB2, there are also pre-installation migration tasks you should perform to prepare your databases.

The luxury of being a single platform DBA is becoming a thing of the past. Many DB2 mainframe DBAs find themselves supporting DB2 on these distributed platforms, resulting in a huge learning curve. It is essential for the DB2 DBA of the new millennium to be well versed on running DB2 on multiple pla

(Silvio Podcameni) This redbook is the result of a residency project conducted at the IBM International Technical Support Organization (ITSO) San Jose Center. The project tested and implemented stored procedures executing in DB2 for MVS/ESA, DB2 for OS/390, DB2 for AIX, DB2 for OS/2, and DB2 for Win