(Kent Milligan) In the first article that I wrote on the DB2 for i field procedure (FieldProc) support in the IBM i 7.1 release, I shared that the Field Procedure support delivered at GA should not be used to conditionally returned masked values due to the risk of data loss.

(Willie Favero) The SRTPOOL subsystem parameter on macro DSN6SPRM defines the amount of sort work area an SQL SELECT statement can use. The number defined on this ZPARM is per SQL task. Bigger is always better if you are talking about only DB2 SQL performance. However, you must keep in mind that

Report administrators looking for the best method to copy the report between the environments.

(John Burgess, Trevor Clarke and Arndt Eade) This IBM Redpaper publication documents the findings of a study into the factors that affect the performance of IBM CICS transactions that access IBM DB2 resources through the CICS DB2 attachment facility. The majority of the study used the following hard

(Troy Coleman) A new DB2 10 feature is designed to make it easier to determine what data is active data based on a specified timeframe (application temporal) and track changes to that data (system temporal). To enable these “time travel” queries, DB2 10 supports a new type of table — temporal — as

(Jun Shen) The WebSphere MQ binding provided with WebSphere ESB and WebSphere Process Server enables communication between native MQ applications and a Service Component Architecture (SCA) environment. The WebSphere MQ bindings simplify the sending and receiving of MQ messages, but MQ header field c

(Willie Favero) This is my “official” notice to all of the DB2 Professionals in the greater Houston area announcing out 3rd Quarter 2012 Houston Area DB2 User Group meeting. The meeting is scheduled for Wednesday, July 11 (in just three weeks) and will be hosted once again by Jack Henry & Associate

(Guy Jones and John Leahy) One of the more advanced concepts in the development of IBM Cognos TM1 cubes is the proper implementation of FEEDERS within TM1 rules. This document describes FEEDERS and how to use them effectively for improved performance when building IBM Cognos TM1 cubes.

(Ember Crooks) How big is it? How much space do we need if we copy it? How big will it be in a year? These are common questions for a DBA. Sometimes we know the answer intimately, and sometimes we have to look it up. If the person asking the question is not a DBA, they expect a hard number […]

(Willie Favero) You’re right, there were no DB2 for z/OS product publication updates in May; there can’t be stuff to update every month. However, there are a couple of DB2 10 and DB2 9 manuals that have been refreshed for June.