(Willie Favero) Two new built-in functions are being introduced in DB2 10 new function mode (NFM): PACK and UNPACK.

(Brian Pulito and Andrew Ivory) The Communication Enabled Application (CEA) Dojo widgets that were first released in the IBM WebSphere Application Server V7 Feature Pack for Communication Enabled Applications and in IBM WebSphere Application Server V8 are now available in source code format as sampl

(Robert Matchett) DB2 is not just for DBAs anymore. DB2—long known for outstanding core DBMS capabilities—now also lends its features to developers. One example of this is the ability to enable time-based information directly within the schema. This is facilitated by new temporal tables in DB2 10 fo

(Troy Coleman) While DB2 for z/OS is the focus of this blog, I feel it’s important to occasionally look at DB2 for LUW. More and more, mainframe DBAs must support DB2 for LUW in addition to DB2 for z/OS. As part of this mainframe DBA’s own education, I’ve been reading the “IBM DB2 9.7 Advanced Appli

(Rob Berendt) I’ve often needed to run a SQL statement from within a CL program. I knew I could by calling a RPG program with SQL embedded in it, or by executing RUNSQLSTM, but I really didn’t want to go to that much trouble to run one simple SQL statement.

(Michael Adendorff) Learn about target model calculations, their purposes and results, and how to use them in Cognos Adaptive Warehouse.

(Dan Gibson) A multi-temperature data management solution refers in part to having data that is frequently accessed on fast storage (hot data), compared to less-frequently accessed data stored on slightly slower storage (warm data) and rarely accessed data stored on the slowest storage an organizati

(Craig S. Mullins) XML is gaining popularity for persisting complex data and is frequently used in web-enabled applications and as a means of data transmission. This chapter introduces you to the basics of XML and provides an overview of pureXML, IBM’s implementation of XML support embedded in DB2.

(Cynthia M. Saracco, Priya Baliga and Stephen A. Brodsky) If you’re looking to getting a quick start with “big data” projects involving IBM InfoSphere BigInsights, you’ll want to become familiar with its integrated web console.

(Jan Koblenzer) Prior to the Jump Scan feature of DB2 10 when an index scan was executed on a composite index, DB2 scanned a large range of the index between start-stop keys or the entire index if no start-stop keys were present while applying predicates to locate qualifying keys. The start-stop