db2 code share
Rexx and Assembler codes around processing Db2 instrumentation facility (SMF, IFCID)
Tuesday, July 18, 2023
SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=PROCEDURE;PROD.O7BPIDOC, DRIVER=4.31.10
›
Hello, Just to record that we had this error in production and it has nothing to do with the explanation in the manual. In fact, you just h...
Monday, February 14, 2022
Assembler to list the Db2 client version connecting to the Db2 Z
›
This code reads SMF101 and extracts only the product ID and the correlation ID , allowing you to track the workstations that must migrate ...
Wednesday, May 12, 2021
Sample Assembler code to select specific plan/ correlation ID and get the sum of cpu consumption
›
Man vs Db2 SMF records. Man wins. When you work on performance metrics, you need to check the cpu consumption of some threads for a specific...
›
Home
View web version