(Tom Huntington) Do you provide your users with a modern “look and feel” for their System i data? Are your users telling you that green-screen reports are unacceptable? Is your backlog of text-based reports overwhelming? Is your data warehouse project over budget, past due, and unsatisfying to users

(Paul Zikopoulos) In my latest articles, I’ve been writing about the IBM Rational Data Architect (Rational DA) integrated development environment (IDE) that’s specifically designed for those involved in data server design and schema evolution. So far, I’ve shown you how to add a database connection,

(Willie Favero) Yes, I know that’s extremely corny. However, for this particular post it’s actually fairly accurate. We’re going to talk about how a bind parameter is switching back to its old original default, how one of the oldest bind parameters is taking on a new default, we are talking about DB

(Joseph W. Baric, Jr.) Explore the topic of troubleshooting for IBM Informix Dynamic Server. After a brief overview, you’ll learn about the various tools that are available for troubleshooting, and then look at examples of how to examine the database server to solve problems. The third in a series o

(Scott Hayes) How many rows must be read (evaluated) to retrieve one row? If DB2 lacks sufficient indexes to filter the result set according to the WHERE predicates, then DB2 will have to evaluate many, possibly too many, rows from the data pages to find result sets.

(Kevin Forsythe) When RPG programmers begin to use SQL, one of the more difficult things for them to adjust to is that the SQL statements do not issue escape messages if an error occurs. They simply set a few status codes and return control to the next line of code in the program. Combating this pro

(Sami Salkosuo) Need sample data to test the application you’re developing? Learn how you can use IBM DB2 Test Database Generator to generate a variety of types of test data, including SQL, comma separated value (CSV), and XML formats. This article shows how to install, configure, and use this tool.

(Clint Boulton) Informix isn’t ready to retire. IBM said it has refreshed its Informix Dynamic Server (IDS), adding continuous availability and disaster-recovery features to its online transaction-processing (OLTP) database.

(Paolo Bruni, Roy Cornford, Raphael Garcia, Sabine Kaschta and Ravi Kumar) This IBM Redbooks publication introduces the enhancements made available with DB2 9 for z/OS. Its scope is to help DB2 for z/OS users understand the functions offered by DB2 9, justify their investment in installing or migrat

(Paul Zikopoulos) In a side-by-side comparison table, author Paul Zikopoulos makes it simple to understand the basic licensing rules, functions, and feature differences between the members of the distributed IBM DB2 9 (DB2 9) data server family.