(Priya Govindarajan and Satish Khot) The IBM Informix Dynamic Server (IDS) provides support for heterogeneous data replication using InfoSphere Change Data Capture. Heterogeneous replication enables the sharing of transactional data across a variety of servers and databases and with external clients

(Paolo Bruni and Michael Schenker) This IBM Redpaper provides a step-by-step introduction on how to get started with Web services using Data Studio V2.1. Our goal is to explain basic concepts and introduce the functions that can help you take your first steps in the Web services arena with DB2 for z

(Robert Catterall) Back in 2006, I wrote an article about XML for IBM Database Magazine (known then as DB2 Magazine). With the availability that year of DB2 9.1 for Linux, UNIX, and Windows (LUW), IBM delivered pureXML, a technology that enabled truly integrated management of XML and non-XML data. R

(Chao M Beck and Stephen Kinder) The Service Component Architecture (SCA) assembly model offers you the ability to assemble and wire service components using commonly used programming languages. The specification lets you concentrate on solving specific problems by enabling a diverse range of servic

(Mike Ebbers, Nin Lei, Manoj Agrawal, Willie Favero, Juraj Hrapko, Shantan Kethireddy, Cristian Molaro, Frank Neumann and PS Prem) Customers have a strong interest in the scalability of data warehousing solutions on the IBM System z platform using DB2 for z/OS. Since business intelligence environme

(Dave Beulke) Use partitioning for robust tables that play central parts in the processing to help ease locking and encourage parallelism. Also leverage database partition for large tables (over 500,000 rows) which might benefit from spreading out the I/O to different partitions and different device

(Srinivasan R. Mottupalli, Gagan Maheshwari and Vishwas T. Mahadevaiah) Informix 4GL, or simply I4GL, supports a programming language for interacting with the Informix database servers. It provides a rich environment with forms and reports language for easy development of relational database applica

(Robert Catterall) Last week I gave a presentation at a meeting of SIRDUG, a regional DB2 users group based in Charlotte, North Carolina. Also on the program was David Simpson, a Senior Technical Advisor with Themis Education. David is a reliably excellent presenter, and he certainly didn’t disappoi

(Troy Coleman) Enforcing or validating XML documents against an XML schema is one concern DBAs have when storing XML documents in DB2. An XML schema contains a description of the corresponding XML document, along with constraints on the document’s structure and contents.

(Paul Read) In part one of this two-part series, get an introduction to the IBM solidDB Universal Cache solution and its component parts, and learn about the basic system requirements and the architecture of a solution. Get started with the IBM solidDB Universal Cache solution and an IBM DB2 for Lin