(Martin Hubel) Since the beginning of commercial applications, input/output (I/O) has been one of the main determining factors for overall performance. In the world of relational database, I/O can easily surpass all other considerations, particularly if an SQL statement asks for a very large result
Tag: IBM
Db2 Location Statistics Traces for Remote Applications
(James Pickel) Do you have a significant amount of work coming into your Db2 for z/OS subsystems through the Distributed Data Facility? If so, this article may be of interest to you.
Guru: SUBSET on EXECUTE and OPEN
(Paul Tuohy) The DB2 for i Enhancements in IBM i 7.3 Technology Refresh 8 / IBM i 7.4 Technology Refresh 2 just made dynamic SQL, embedded in RPG, a lot easier to use. It includes an enhancement entitled USING SUBSET on EXECUTE and OPEN with Extended indicators.
Db2 11.5 Mod Pack 4 is available
(Henrik Loeser) A quick note that Db2 Version 11.5 and its Mod Pack 4 are now available. You can read more about its new features and changes in the “What’s new” section of the Db2 docs.
RemoteDBA or Consultancy on Demand. What’s the difference?
(Carol Davis-Mann) At Triton we understand that clearly defining the differences between our remote DB2 support service and Consultancy on Demand can help set important customer expectations so you can decide which solution is ultimately the best fit for your organisation and your business needs.
Announcing Two New Db2 Web Query Editions!
(Doug Mack) Db2 Web Query for i is a family of analytics products. The two products on the reporting/Business Intelligence side have been Express Edition and Standard Edition.
Machine Learning with IBM Db2: Building and Deploying a Linear Regression Model
(Les King) In this demonstration, we’ll use a Jupyter Notebook from IBM Watson Studio to show how you can build a Linear Regression model inside Db2.
The Various Aspects of Db2 for z/OS Data Encryption
(Robert Catterall) Just last week, a person on the Db2 for z/OS team at an organization asked me for some guidance regarding data encryption in a Db2 context.
Db2 12 for z/OS Function Level 507
(Craig S. Mullins) This month, June 2020, IBM introduced a new function level, FL507, for Db2 12 for z/OS. This is the first new function level this year, and the first since October 2019.
Enabling Db2 Historical Monitoring (db2histmon) – continuous diagnostic data collection and archival
(David Sciaraffa) When a problem with Db2 arises, identification of the problem’s root cause by IBM Db2 support and development is often directly influenced by the availability of diagnostic information before, during, and after the time-frame of the problem event.