(Paolo Bruni and Jeffrey Berger) The MIDAW facility was introduced in the IBM z9 processor to improve FICON performance, especially when accessing IBM DB2 databases. This facility is a new method of gathering data into and scattering data from discontinuous storage locations during an I/O operation.

(Willie Favero) Once you finish your V8 upgrade to new function mode (NFM), something you will want to take advantage of almost immediately is the new sample program DSNTEP4. DSNTEP4 is an upgraded flavor of the well established sample program DSNTEP2. Written in PL/I just as its predecessor, DSNTEP

(Pat Moffatt, Bruce Creighton and Jessica Cao) Appendix A describes all of the tables in the Aroma database, which consists of two schemas: a simple star schema for retail sales information and a multistar schema for purchasing information. This appendix belongs to the SQL & XQuery Tutorial for IBM

(James Gannaway) Ever since Alexander Graham Bell invented the telephone in 1875, people have wanted to record and retrieve conversations. Although that basic desire hasn’t changed, the reasons for recording calls and efficiently retrieving them certainly have. Organizations today face more legal, f

(Hernando Bedoya) The next version of non-iSeries DB2 Products from IBM are planning to announce new enhancements forXML integration. DB2 UDB for iSeries will not be part of this announcement, at least for the time being. However, there are many other ways to integration DB2 UDB for iSeries with XML

(Willie Favero) Tonight I am offering up an opinion. I would like to hear your opinions on mine. Opinion on: Sequence objects, delivered in V8, are a better choice than identity columns from back in V7. Opinion off

(Kerensa Jablonka, Mary Desisto and Michael Lowe) This series of articles is designed to prepare you for taking the IBM DB2 Content Manager V8.3 certification exam 443. In addition, it provides a strong foundation for educating yourself on DB2 Content Manager, from understanding how to gather requir

(Pat Moffatt, Bruce Creighton and Jessica Cao) This tutorial introduces pureXML and XQuery, starting from a basic overview of the characteristics and advantages of the XML data type, and then compares it with standard relational tables. Users are then asked to write XQueries to retrieve XML elements

(Chris Eaton) I’ve noticed an increase lately in the popularity of what we sometimes call a split mirror backup. That’s when you use either the storage vendor hardware (like IBM System Storage or EMC Symetrix) or the file system software (like Veritas) to make an instantaneous copy of a set of data

(Xiao Li and Sheng Wei) The pClient and eClient, packaged with IBM DB2 Content Manager (CM), meet the client requirements of many Content Manager users. However, many others need to develop their own client applications to meet their special business needs and to integrate their own business with CM