(Frank Fillmore) Dr. Sheldon Cooper of “The Big Bang Theory” regularly records a YouTube video called “Fun with Flags” so I’m going to call this blog post “Fun with SQL”.
Tag: IBM
Db2 for z/OS Partitioned Table Spaces: How the Number of Partitions can Impact Performance
(Robert Catterall) This past summer, I delivered a couple of presentations at a meeting of a regional Db2 users group in the USA. During the lunch break, I shared a table with a member of the Db2 for z/OS support team at a large financial institution.
The DB2Night Show #210: Db2 Performance Tuning- Indexes vs Prefetch
(Scott) Famous for putting his kids through college by Dropping Db2 Indexes, Martin covers a wide variety of Db2 Performance Tuning topics with focus on indexes, prefetch I/O, bufferpools, Db2 MDC and ITC tables, and much more (detailed below).
Making JSON with SQL Functions
(David Churn) In our connected world, we send and receive messages with other businesses using different formats.
IBM Spectrum Scale and IBM StoredIQ: Identifying and securing your business data to support regulatory requirements
(Sandeep R Patil, Sasikanth Eda, Atul V Gore and Nils Haustein) The appropriate storage for hosting business-critical data and the proper analytic software for deep inspection of that data is necessary, especially for data that is subject to regulatory compliance..
The Db2Night Show #z92 – Distributed access to Db2 for z/OS: top things
(Martin) 98% of our studio audience learned something!Cristian covered all aspects of distributed access to Db2.
Dirty Reads… Done Dirt Cheap
(Craig S. Mullins) Let’s talk about dirty reads (with apologies to the AC/DC pun in the title of this blog post).
Validating JSON Documents
(John Maenpaa) Using JSON is a lot easier than using XML. Manually editing a document is much more manageable and adjusting the structure is quick and easy. It is also easier to create an invalid JSON document without knowing it.
Big Data: Health Checking Your System
(Lockwood Lyon) As big data solutions grow in size and complexity, concerns can rise about future performance. Will the current application scale up and out? Are there potential issues with data consistency? Can your big data application co-exist on the same hardware with regular production processi
DB2 Native REST API – Versioning and Control
(James Gill) The DB2 for z/OS REST API has been available on V11 and V12 for a while now and has continued to evolve through IBMs continuous delivery maintenance strategy.