(Peter Hartmann) With DB2 Version 9.1 for z/OS a new system supplied stored procedure SYSPROC.ADMIN_INFO_SYSPARM was delivered.
(Akiko Hoshikawa) As the size of database and the volume of transactions increase, many of Db2 transactions tend to spend significant amount of wait time in database read and log write I/Os.
(Lockwood Lyon) Analytical reporting against big data has become standard in many companies, along with embedding simple analytical queries in real-time applications.
(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).
(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.
(Robert Catterall) The Db2 for z/OS package bind option APPLCOMPAT is not new – it was introduced with Db2 11.
(Xiaohong Fu) Indexable and/or stage 1 predicates can be evaluated at the early stage during row retrieval.
(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).
(Henrik Loeser) A quick post to inform you that Db2 11.5 has been released.