(Robert Catterall) DB2 shops are finally diving in with this underused feature. When support for stored procedures first appeared on the mainframe scene with DB2 for OS/390 version 4, it wasn’t an instant hit. For one thing, the feature was aimed at users of the DB2 for OS/390 distributed data fa

(Igor Dayen) There are various ways to solve the problem of effective, automatic conversion of XML data into and out of relational databases. Database vendors such as IBM, Microsoft, Oracle, and Sybase have developed tools to assist in converting XML documents into relational tables.

Databases have become the universal means of storing information that is accessed in real time. In a perfect world, databases should function all the time without needing any major maintenance such as a reorganization. However maintenance remains necessary in order to eliminate performance degra

(Marie Wilson and Sue Kelling) IBM’s eServer Business Solution Test (BST) team designs, implements, evaluates, and deploys customer-like scenarios. The team consists of iSeries developers in the Rochester laboratory who design scenarios that demonstrate how iSeries technology can be used to build e-

When you are using the Host Integration Server 2000 ODBC Provider for DB2, if you try to use a linked DB2 table on an OS/390 Mainframe system from Microsoft Access, you may receive the following error: ODBC–insert on a linked table ‘MY_CODES’ failed [Microsoft][ODBC DB2 Driver] Invalid precisio

(Bryan F. Smith and Thomas A. Vogel) A data explosion threatens to bog down, fill up, slow, and generally complicate DBMSs. Archiving data that’s rarely accessed lets businesses hold on to the data they need while keeping DB2 performing at top speed. With databases growing at an exponential rate,

(Peggy Rader) The IBM Distributed Debugger provides a GUI interface for debugging Java stored procedures on DB2 Universal Database for Linux, UNIX, and Windows. This option is not available for debugging DB2 interpreted Java stored procedures on DB2 for z/OS. There are two alternatives that you can

Extnsive fast tips and ER diagram on how to set up replication between DB2 and Oracle.

(Ruud van Zundert) Although IBM strives to make the whole product family look and feel the same, there are always going to be differences due to the underlying operating systems. This article concentrates on the differences on the OS/390 side of MQSeries, and in particular on the Coupling Facility (

(Judith M. Myerson) Developers should want to know about and contribute to the development of the object-oriented wireless model, including learning how the model is used to store and retrieve complex information about the conceptual design of a wireless infrastructure. It is important for object