(Craig S. Mullins) This four-part blog series took a look into SQL performance and optimization from a generic perspective.
Tag: IBM
The DB2Night Show #209: The Perfect Db2 Server and What’s New Db2 V11.1.4.4
(Scott) 100% of our audience learned something!Klaas Brant’s presentation was amazing! From monitoring commands to configuration recommendations, Klaas covered it all!
Db2 for z/OS JSON SQL APIs and Native REST Services
(Jane Man) In the recent customers’ conference calls, a lot of customers are confused about Db2 for z/OS JSON capability and Native REST services.
Db2 for z/OS Global Variables: What is a ‘Session’?
(Robert Catterall) Has this ever happened to you? You’re looking at the Db2 for z/OS SQL Reference (or in the Db2 for z/OS Knowledge Center on the Web), and you see something like this (and the quote below is from the description of the CREATE VARIABLE statement in the SQL Reference, with highlighti
Db2 Performance: Tuning Db2 LUW Explains and db2advis, Part 2
(Scott) This is part 2 of Db2 application tuning for Db2 Explains and db2advis. We are on a mission to make Explains and the Db2 Advisor faster and more efficient. PLEASE review PART 1 as a prerequisite so that the information flow is fresh in your mind before continuing.
IBM Cloud: The 5 minute barebone news chatbot
(Henrik Loeser) Do you have 5 minutes and want to build a really simple news chatbot? I tried this yesterday with IBM Cloud and the Watson Assistant and Discovery services.
The Db2Night Show #z91 – z/OS: Machine Learning and Db2 for z/OS
(Martin) 100% of our studio audience learned something!Terry covered how the Db2 optimizer is changing to incorporate machine learning features.
What is using my Linux swap space?
(Jack Vamvas) Question: I’m familiar with how to monitor swap space usage for processes. There is more detail about the methods I’ve adopted for using vmstat to check swap in and swap out on Linux swap space and DB2 . How can I check what is currently in the Linux wasp space ?
Incorporate Git and IBM Cloud information into BASH command prompt
(Henrik Loeser) Many of you know that I love to use the command line. Because my day to day work includes interfacing IBM Cloud and GitHub, I have changed the BASH configuration to include related information into the command prompt.
Data Masking: An Imperative for Compliance and Governance
(Craig S. Mullins) For those who do not know, data masking is a process that creates structurally similar data that is not the same as the values used in production.