(Whei-Jen Chen, An Na Choi, Marina Greenstein, Scott J Martin, Fraser McArthur, Carlos Eduardo Abramo Pinto, Arthur V Sammartino and Nora Sokolof) IBM DB2 has long been known for its technology leadership. This IBM Redbooks publication, intended for technical staff who are involved in an Oracle to D

(Michaela Trautwein-Ostner and Marcio Bulek) IBM Informix Dynamic Server, Version 11 (IDS 11) has new SQL features. Learn how to use SQL to perform administrative tasks, improve query performance, manage data security, and manipulate data. The eighth in a series of eight tutorials, use this tutorial

(Willie Favero) Or at least, let’s talk about one new DSNZPARM keyword introduced since DB2 V8 went GA. This ZPARM snuck into DB2 Version 8 sometime around April 2006 via an APAR so it has already been around for quite a while. To me, it’s one of those good news, bad news APARs. Fortunately, the goo

(Willie Favero) What does one do over breakfast in Seattle? You read IBM’s Tuesday morning announcement letters. It’s kind of neat getting to read them over my first coffee rather than having to wait until lunch. And what could I find so interesting in today’s announcements? Well, just the official

(James Reed and Michaelyn Shelley-David) Many companies rely on DB2 for z/OS for the highest level of availability and scalability. The U.K. government’s Land Registry maintains the world’s largest known transaction processing database (23.1TB) on DB2 for z/OS. UPS executes 1.1 billion SQL statement

(Kiet Q. Nguyen, Shubha Tangirala and Sundaraman Venkataraman) How efficient is your current business process implementation? One of the defining metrics for analyzing business process performance is the time factor, or duration. A business process is generally a series of activities to fulfill a bu

(Craig Mullins) Just a short entry today to discuss a feature that will be useful for organizations having tables containing long text strings which are stored as VARCHARs. It involves altering the data type of a column from LONG VARCHAR to a compatible data type.

(Eric Long) Learn how to use the new features of DB2 Express-C to store, query, and manipulate native XML documents using SQL/XML and XQuery. Previously, XML documents had to be “shredded,” or turned into a CLOB/BLOB/LOB (large object), to be stored in a relational database. This tutorial explains h

(Paul Titheridge) Creating connections from WebSphere Application Server to a Java Message Service (JMS) provider such as WebSphere MQ is costly in terms of both time and processor requirements. To improve performance, WebSphere Application Server maintains a pool of free connections that can be giv

(Paul Zikopoulos) In my last two articles on Microsoft Excel 2007 (Excel 2007) and DB2 I showed you how to get DB2 data into your worksheets and work with that data with some of the new advanced and very powerful features that are new in Excel 2007; at the same time, I’ve been introducing you to the