IBM has long been a leader in parallel database technology with its Universal Database (UDB) DB2. Until recently, a special version of DB2 was required for those who wished to partition a database across multiple systems and allow those systems to work in parallel on a single database operation (suc

(Paul C. Zikopouos) If you’ve read an IT magazine, attended a conference, or are an IBM DB2 Universal Database(DB2 UDB) user, you’ve heard the buzz about “Stinger”, the preview of the next release of DB2 UDB for Linux, UNIX, and Windows “Stinger” introduces over 175 valuable features -more than some

This part of the book covers Structured Query Language (SQL), specifically DB2 for OS/400 SQL (or SQL/400, for short).1 SQL is an industry-standard language for defining and manipulating data contained in a relational database. This chapter introduces SQL/400 and covers the Data Definition Language

(Alexander Kuznetsov) This article uses examples to illustrate cases in which adding a column or two to an index can boost a query’s performance by “covering” the columns used in a SELECT statement. The DB2 optimizer is very good in recognizing such situations and can choose a very efficient executi

(Raul F. Chong) This article shows DB2 UNIX, Linux, and Windows specialists how to leverage their DB2 knowledge in these platforms to gain skills on DB2 for iSeries.

(Robert Catterall) If you want to generate a random number to populate a column in a DB2 table, you have a number of options, divided into two broad categories: generate the value outside of DB2 or use a DB2 facility to generate the value.

(Sridhar Reddy Varakala and Kulvir Singh Bhogal) If you are interested in information integration but haven’t had the time to pick up the basics, this article offers a gentle but quick introduction to the capabilities of DB2 Information Integrator for integrating and updating data in an Oracle datab

(C.M.Saracco, Jacques Labrie and Stephen Brodsky) Combining Enterprise Information Integration (EII) technology with Service Data Objects (SDO) helps object-oriented programmers easily work with a wide variety of heterogeneous data sources and reduces the complexity of integrating disparate data.

If a DTS package is built to export a SQL Server table to DB2/MVS (version 5.1) by using the Microsoft OLE DB Provider for DB2 (DB2OLEDB) and the AUTOCOMMIT property of the provider is set to FALSE, the following error may be reported: [OLE/DB provider returned message: A SQL error has occurred.

(Roman B. Melnyk) DB2 uses table and table space states to control access to data or to help protect the integrity of the database. This article describes these states and shows you, by way of working examples, typical conditions under which they appear, and how to respond to them.