(Robert Catterall) SQL statements executed by way of the Db2 for z/OS distributed data facility (DDF) are not, of course, the only workload that uses zIIP MIPs, but in my experience this does tend to be the main driver of zIIP utilization in a z/OS system on which Db2 runs.
Tag: IBM
HADR Tutorial Part 15 – Twisted HADR Setup Snapped the Transactions
(Harishkumar Baburao Pathangay) Twisted HADR Setup Snapped the Transactions Kindly Share Your Inputs.
Using Actions in InfoSphere Optim
(Gaurav Rohila) InfoSphere Optim Data Masking Solutions provide a way to convert extracted or archived data into CSV, XML, or enterprise content management (ECM) data formats, and can also mask data while converting to any of these file formats.
New tutorial: Db2-driven Slackbot
(Henrik Loeser) Ever wanted to build a Slackbot, a chatbot integrated into Slack, on your own? I am going to show you how easy it is to integrate Slack or Facebook Messenger with the IBM Watson Conversation service.
Speculating About Speculative Execution
(Steve Pitcher) There’s been a lot of talk about Spectre and Meltdown since Google developers first announced the vulnerabilities on January 3, 2018. Rightfully so, as this type of vulnerability is arguably the biggest security concern in the history of computing.
DB2 Native REST API – Bonus Features with APARs PI86867/8
(James Gill) In the last blog we focused on the new TSO/Batch BIND SERVICE and FREE SERVICE and a sample DB2XML UDF to drive services from z/OS. In doing so, we skated over some of the other features that were delivered with these APARs.
New IBM i Technology Refreshes Announced; Available Mid-March
(Dan Burger) IBM yesterday announced that Technology Refresh 8 (TR8) for IBM i 7.2 and TR4 for IBM i 7.3 will provide support for Power9 hardware, enhancements for RPG, security enhancements, and a variety of new capabilities for licensed products.
Check your machine learning IQ
(Jennifer Clemente) As the expression goes, “There’s no AI without IA.” In other words, enthusiasm for AI has led many to jump in head first. But without a strong technology foundation, companies could be setting themselves up for obstacles.
Performance differences between upper-case (XQuery) and UPPER scalar function
(James Gill) I thought I’d share a recent performance issue I had with one of our customers. We’re in the Pre-Production testing stage of a project and our responsibility is a series of Stored Procedures to manage the INSERT, UPDATE and SELECT commands to be run against the database.
The DB2Night Show #Z84: Revival of the SQL Tuner
(Martin) 94% of our studio audience learned something!Sheryl presented about increasing the attendee’s ability to identify and fix access path problems.