(Chris Eaton) In the past few postings you have seen how to use compression along with many real world customer examples of compression rates in DB2 Viper. In this posting I want to compare this technology to other competitors (I’m not proclaiming myself as an Oracle or Microsoft expert and there ar

(Willie Favero) One of the coolest features in DB2 for z/OS version 8 turns an old programming rule on its head. For years, we taught DB2 application programmers not to use arrays (with the exception of the indicator variable). DB2 version 8 changes that with multirow FETCH and INSERT.

(Chris Eaton) In order to use row compression in DB2 Viper you must first set the table to be compression eligible and then you must generate the dictionary that contains the common strings from within the table.

(Nic Kesic) If you have valuable, sensitive, or confidential data, and the data can be accessed or seen by unauthorized people, then data encryption is a must. The extended BASIC APIs of IBM UniData and UniVerse (U2) perform symmetric encryption operations on data using various available ciphers. Th

(Kane Scarlett) The IBM Autonomic Integrated Development Environment (AIDE) is a set of software development tools that embrace the Web Services Distributed Management (WSDM) standard, helping to ease IT management burdens by defining an architecture for connecting computing resources with managemen

XML data is a key ingredient for solutions based on Service Oriented Architectures (SOA) and building XML aware and XML centric applications marks the next stage in the evolution of database programming. (R)

(Susan Lawson and Dan Luksetich) In today’s high performance computing environments we are bombarded with dynamic SQL more than we ever were in the past. Queries coming into our subsystems from products like DB2 Connect and Websphere are executed as dynamic SQL. This dynamic SQL creates problems suc

(Dan Burger) To keep the wheels turning on the service oriented architecture (SOA) bandwagon, IBM has announced plans to introduce a new version of WebSphere Portal in the third quarter of 2006. When WebSphere 6.0 becomes generally available, it will replace the current product, WebSphere Portal for

(Jack Boswell) This article is a simplified user’s guide for troubleshooting problems that you encounter with Content Manager Standard Edition for iSeries. Much of the information for this document was assembled from the Information Center. Use this information in conjunction with the Information Ce

(Vincent McBurney) I am running another theme week next week, it is going to be data quality firewall week! Watch accurate data pass through the wall of fire. Be amazed at the jaw dropping tricks on display.