(Troy Coleman) I firmly believe that DBAs should always be prepared for the worst-case scenario. With this in mind, an imagecopy backup of data is your best friend. However, if you haven’t worked with tables containing XML data, you may not know that both the table space (which contains the base tab

(Michael Sansoterra) This article briefly explores the new client special registers that are now available in V6R1 and how they benefit client/server development. In case you missed them, Part 1 of this series discussed several query enhancements and explained how IBM is packing more functionality i

(Robert Peterson) In this introduction to Web 2.0 and REST with IBM WebSphere DataPower SOA Appliances, learn how to build strict REST services on DataPower and bridge them to backend Web services. Sample REST code is included that demonstrates best practices, with instructions that detail how it wa

(Mike Sniezek) One of the most exciting features in DB2 9 for z/OS is native extensible markup language (XML) support. XML was refined in the late 1990s to solve the problem of the universal data interchange between dissimilar systems. XML has been around for a while. IBM has supported storage of XM

(Andrew Binstock) The acquisition of Sun by IBM raises several interesting possibilities, especially in regard to the wide array of Sun software that is likely to be affected. Here are some thoughts on the effects of the deal on key technologies.

(Sami Salkosuo) IBM solidDB Universal Cache is in-memory caching software for use with traditional disk-based relational databases. It promises extreme speed, adaptability, and robustness. Explore these promises and follow a sample use case for the first — extreme speed. See, also, how to use a cust

(Michael Sansoterra) Part 1 of this series focused on some of the stellar query enhancements IBM gave its DB2 for i developer community. It’s hard to believe the 20-plus-year-old AS/400 system (now called IBM i) can continue to look so young given its great strengths in database and other areas. But

(Chris Eaton) In AIX 5.3 running on the POWER6 processor series, the IBM System p team have added a great feature to enhance the stability of software running on this platform. Known as “storage protection keys”, these new built-in machine instructions can be used to allow or disallow access to spec

Great news for people who want to write portable applications! This reference makes it easy for you to develop applications using SQL that is portable across the DB2 database family, including DB2 for z/OS Version 9, DB2 for i Version 6.1, and DB2 for Linux, UNIX, and Windows Version 9.5.

(GGZ) After careful review of the XML features in DB2 9 for z/OS and their user experiences and feedback, the XML development team decided that the XDBDECOMPXML stored procedure for annotated schema-based decomposition be deprecated in DB2 9 for z/OS and may be removed in a future release. Users are