(Lockwood Lyon) Analytical reporting against big data has become standard in many companies, along with embedding simple analytical queries in real-time applications.
Tag: IBM
There’s a New Db2 12 for z/OS Function Level (505)
(Craig S. Mullins) In late June 2019, IBM delivered more great new capabilities with the latest new function level for Db2 12 for z/OS, Function Level 505 (or FL505).
Why dsmtop isn’t Even Half as Good as db2top
(Ember Crooks) I think I’m beginning to better understand why IBM is not fond of tools like db2top. The truth is that the developers really only get exposure to the largest Db2 clients.
Db2 for z/OS – Talking About APPLCOMPAT (Part 1)
(Robert Catterall) The Db2 for z/OS package bind option APPLCOMPAT is not new – it was introduced with Db2 11.
Early stage predicate evaluation with DECFLOAT and implicit casts
(Xiaohong Fu) Indexable and/or stage 1 predicates can be evaluated at the early stage during row retrieval.
IBM Spectrum Discover: Metadata Management for Deep Insight of Unstructured Storage
(Joseph Dain, Norman Bogard, Isom Crawford Jr., Mathias Defiebre and Larry Coyne) This IBM Redpaper publication provides a comprehensive overview of the IBM Spectrum Discover metadata management software platform. We give a detailed explanation of how the product creates, collects, and analyzes meta
Asynchronous cross-invalidation (XI) for coupling facility (CF) cache structures, e.g. Db2 for z/OS group buffer pools (GBP)
(Peter Hartmann) When Db2 in a data sharing environment writes a changed page to the GBP the same page in the buffer pool(s) of the other member(s) must be invalidated to avoid back level data access in this/these member(s).
New! Db2 11.5 is available
(Henrik Loeser) A quick post to inform you that Db2 11.5 has been released.
Improved data availability with pending ALTER COLUMN – a Db2 12 GA feature
(Regina Liu and Paul McWilliams) Db2 12 for z/OS introduced a new capability to alter certain attributes of table columns as pending data definition changes.
Meet ‘the Crusher’ – or how we learned to love query acceleration
(Steve Cricchi) IBM’s Db2 Analytics Accelerator (formerly called “IDAA”) has been available for over 8 years, as IBM bought Netezza in 2010.