(Paolo Bruni) IBM DATABASE 2 Universal Database Server for z/OS Version 8 (DB2 V8 throughout this IBM Redbook) is the twelfth and largest release of DB2 for MVS. It brings synergy with the zSeries hardware and exploits the z/OS 64-bit virtual addressing capabilities. DB2 V8 offers data support, appl

(Bill Wilkins) Improving the performance of database inserts is very important to managing a database, especially in an OLTP environment. This article explains exactly what happens when an insert occurs, looks at alternatives, and examines issues that affect insert performance, such as locking, inde

(Monty Wright) Installing DB2 UDB on a non-RPM Linux distribution presents some challenges. Author Monty Wright draws on direct customer experience to help you through the process.

(Karen Durward, Holly Hayes and Nelson Mattos) By some estimates, 60 percent of business data assets are housed in mainframes — and these assets are growing 20 percent every year. Meanwhile, the pool of skilled mainframe IT staff is shrinking. Entrants into the technology labor force don’t realize h

(Robert L. Welgan) IBM DB2 Universal Database (UDB) administrators have a real challenge on their hands when trying to succinctly describe their system configuration to IBM support for problem resolution. After all, there are many configuration parameters and database characteristics to describe. Th

(Venkat Arikatla) You can reorg and runstats in a single ksh script. Install this script as a crontab to run every day during off-peak hours to get maximum performance in DB2. Change @HOME@ to your DB2 home dir and @SCHEMA@ to your database schema name. (R)

(Dorian Pyle) Nine simple rules you won’t want to follow. Not all mining projects are successful. This pronouncement may come as a surprise (but it probably won’t). Some mining projects are successful — sometimes spectacularly so. The fact that this second pronouncement may come as a surprise to

(Roman B. Melnyk and Paul C. Zikopoulos) Today’s efficient businesses strive to balance the cost savings of a just-in-time (JIT) inventory system with the potential for lost sales resulting from stock-out situations. A common database design for a JIT procurement system is to have a “master” table t

(Nagraj Alur) Portals provide users with a single point of access to multiple types of information and applications through a Web interface. IBM WebSphere Portal for Multiplatforms is one of the industries’ most comprehensive portal offerings. It contains a wide range of portal technologies that hel

(Bob Swart) This article shows how to use Delphi 8 for .NET to build an ASP.NET Web Service application that publishes the data tables from the DB2 UDB SAMPLE database to the outside world.