(John Burgess, Trevor Clarke and Arndt Eade) This IBM Redpaper publication highlights the findings of a study about the factors that affect the performance of IBM CICS transactions that access IBM DB2 resources through the CICS DB2 attachment facility. Most of the study used the following hardware a

(Thuan Bui and Hassi Norlén) Testing of enterprise changes are costly and difficult tasks for IT organizations. See how an IT team at a fictitious outdoor equipment retailer uses IBM InfoSphere Optim Query Capture and Replay to reduce costs and mitigate risks with realistic testing.

(Dave Beulke) There are many companies that are realizing business insights through new big data analytics. Many are finally looking at data that they only once dreamed of analyzing because of the continuing decline in the cost of storage and CPU as well as the availability of cloud computing resou

(Abhishek Rohira) This article describes how you can dynamically connect a new schema when moving from one environment to another by enabling IBM WebSphere Adapter for JDBC to pick up the database schema name for tables at runtime.

(Troy Coleman) The DB2 for z/OS trace facility uses something called the instrumentation facility (IF). The IF collects and records data that can be used to conduct performance tuning and analyze database performance. Here are a couple of great resources related to the IF and traces in general:

(Bruce Vining) Last month, in “Run-Time Selection Using the RUNSQL CL Command,” we saw how to build an SQL statement on the fly, selecting specific records/rows from the file/table SAMPLE. In this article, we’ll look at how to combine information across files using the RUNSQL CL command. But before

(Robert Catterall) The other day, I got a note from a mainframe DB2 DBA who’d seen a system requirement for DB2 10 that had him concerned. This DBA, whose company was preparing for the migration of their DB2 9 subsystems to DB2 10, had read the following in the text of IBM APAR II14564 (an “info” AP

(Serge Boivin) Learn how to take advantage of the Time Travel Query feature and temporal tables with DB2 for Linux, UNIX, and Windows V10.

(Yuki Miyata, Kohsuke Sakamoto and Hideki Gohara) During the process of implementing and validating real ISV business applications on the IBM PureApplication System, the authors gathered some best practices, tips, and how-tos for developing both virtual application patterns (VAPs) and virtual system

(Ember Crooks) As I mentioned in a recent post, I do a lot of restoring databases to get them from one server to another. On rollforward after a recent restore, I saw this: