(Timothy Prickett Morgan) With much fan-fare last week, IBM rolled out its “Viper” database technology into the version of DB2 for its z/OS-based mainframes. Viper is not just a relational database, which can store information in the traditional format that is friendly to SQL and other query methods

This is a DB2 configuration problem where there is not enough storage available in the heap UTIL_HEAP_SZ to process the statement.

(Justin Whitney) As a Web developer, I want my DB2 database to do more than just store pretty things. I want to be able to show them off for all the world to see. PHP gives me a fun way to do that. But how do the two work together? And how can I use PHP to make the most […]

(Ted J. Wasserman) Learn how to create and use user-defined routines in IBM DB2 9. This is the last tutorial in a series of nine tutorials that you can use to help prepare for the DB2 9 Application Development certification exam (Exam 733). (R)

(Vinayak Shenoi) This article explores the following enhancements to the user-defined routine (UDR) feature available in Informix Dynamic Server: –Multiple OUT parameters (Dynamic Server 9.4 and above) –Multiple INOUT parameters (Dynamic Server 10.00 and above) –Named return parameters (Dy

Language features, such as outer joins and scalar function calls, are commonly implemented by database systems. The syntax for these features is often database-specific, even when a standard syntax has been defined. ODBC and JDBC define escape sequences that contain standard syntaxes for the languag

(Susan Visser) In the mail today, I received an invitation to the next IDUG NA Conference that is taking place in San Jose in May. Given the recent announcement of DB2 9 for z/OS, and the close proximity to the lab that creates the product, I’m sure you’ll have a chance to meet many of the developer

(Alain Fisher and Suita Gupta) This article introduces the VMware Infrastructure components and walks you through setting up DB2 Enterprise 9 on a 64-bit Linux virtual machine using the VMware ESX Server product

(Craig S. Mullins) The beta program for the next version of DB2 for z/OS began back in June of 2006. This latest and greatest version of DB2 is known as DB2 9 – no V, just 9. At the time I’m writing this (early December), no GA date has been announced, but “word on the street” says to expect GA […]

(Tom Wabinski, Anil Varkhedi and Thomas Atwood) IBM WebSphere Classic Data Architect (CDA) is a remote administration tool for IBM WebSphere Classic Event Publisher for z/OS, and can be run from Windows or Linux workstations. This article covers the setup of MQSeries objects required by the scenario