(Willie Favero) I’m still talking about real-time statistics. This is what is referred to as the trickle affect. Periodically I keep discussing another little piece of real-time statistics. This stuff is important… it’s useful… and in my opinion it’s pretty interesting…. Every time I reread one of m
Tag: IBM
IBM Enterprise-Class RDBMS Gets Even Better
(Joseph Veleeparambil and Shawn Moe) Two years after its hugely successful release of IBM Informix 11.7, IBM continues to deliver significant new versions of the Informix data server. Building on 11.7, the Informix 12.1 release focuses on its core online transaction processing (OLTP) strengths of hi
Zigzag join enablement for DB2 star schema queries
(Lee Jung Chu and Sudhir Singh) IBM DB2 10.1 Linux, UNIX, and Windows introduces a new join method called zigzag join. Zigzag join improves consistency in performance as well as reduces the execution time of queries in data warehouse or data mart environments with large volumes of potentially partit
Bringing Home The Data
(Michael Sansoterra) In IBM i 7.1 Technology Refresh 4 (TR4), IBM gave SQL developers the ability to insert data into a local database table from a remote DB2 for i database table within the comfort of a single SQL statement.
Practical SQL: OLAP, Part 1
(Joe Pluta) SQL has always been a great tool for querying data. The problem is that SQL doesn’t always lend itself to the sort of pattern analysis that’s needed in enterprise data processing. Something goes awry in the database and the only way to identify the source of the problem is to backtrack t
DB2 Tools corner: Using IBM Tools Customizer for z/OS in a multiple-LPAR environment
(Rasha Dwidar, Steven Gregg and Eric Radzinski) Although Tools Customizer currently supports only the local LPAR, you can use several methods to customize products on multiple LPARs where Tools Customizer is not installed.
Super Analytics, Super Easy
(Sam Lightstone, Guy Lohman and Berni Schiefer) Imagine a database technology that gives you 10-20 times faster performance right out of the box, requires dramatically less storage, and nearly eliminates the need for tuning. Too good to be true?
An update on Real Time Statistics
(Willie Favero) An interesting title for a blog post? The word “update” implies I have discussed real time statistic before; I have not. Although, I wish I had. In fact, it’s getting ever more difficult to come up with an original DB2 for z/OS subject to write about.
Integrating WebSphere Message Broker and WebSphere MQ with IBM Integration Designer using a Service Integration Bus and MQ Link
(Abner Carmona Sanchez, Edgar Gonzalez Cervantes and Juan Carlos Pineda Marin) This article shows you how to communicate between IBM WebSphere Message Broker V7, IBM WebSphere MQ V7, IBM Integration Designer V7.5.1 using a Service Integration Bus (SIBus) engine.
DIA3208E Error encountered in TCP/IP protocol support
(Jack Vamvas) Question : I recently received a query from an application owner, who reported application outage issue.
