(Paolo Bruni, Patric Becker, Willie Favero, Ravikumar Kalyanasundaram, Andrew Keenan, Steffen Knoll, Nin Lei, Cristian Molaro and PS Prem) The IBM DB2 Analytics Accelerator Version 2.1 for IBM z/OS (also called DB2 Analytics Accelerator or Query Accelerator in this book and in DB2 for z/OS documenta

(Krithika Prakash) Part 2 of this multi-part article series describes how to create, configure, and debug the Web Token Service. It also explains typical use cases of WTS and the advantages of using WTS over other services. Finally, it provides a sample configuration of WTS.

(Philip) For the third in the series I am going to look at the little doosie that was presented to me the other day where the seconds of time passed from a system are presented as an integer and needed converting to a time, when I say a time I mean a time that will add up in MS Excel […]

(Ember Crooks) This post is specific to WebSphere Commerce. Stagingprop can fail for a dizzying array of reasons. I’m attempting to document some of them, since there’s no real reference that digs into the details.

(Alice Guidotti and Gaetano Ruggiero) Suspect Duplicate Processing (SDP) is a key feature of IBM InfoSphere Master Data Management (MDM). It allows collapsing suspect parties when found to be identical. It also identifies possible suspect matches and provides a matching score, allowing the user to r

(Craig S. Mullins) Session variables, set by DB2 or by the user, offer another way to provide additional information to applications. Session variables are set by DB2, and are accessible to application programs and end users. By accessing session variables, an application program can determine many

(Robert Catterall) If you work with DB2 for z/OS — as a systems programmer, a DBA, an application developer, or in some other capacity — you REALLY ought to be using IBM Data Studio. Why? Well, start with the fact that it’s FREE and downloadable from the Web.

(Cynthia M. Saracco and Marcel Kutsch) If you’re looking to get off to a quick start with big data projects involving IBM InfoSphere BigInsights, learning the basics of how to query, manipulate, and analyze your data is important. This article takes you through simple query examples that show how yo

(Dave Beulke) Last week’s example built a petabyte table by putting multiple tables under the definition of a UNION ALL View. This tactic provides unlimited growth potential for the logical big data table to all types of regular and analytical users. Unfortunately, as some commented, this UNION AL

(Paul Pendle) Traditionally, storage provisioning on the mainframe has been a slow and complex process. Apart from procurement and hardware installation, there are host activities for the Input/Output Definition File (IODF), SMS storage groups, and Automatic Class Selection (ACS) routines.