Showing posts with label Dynamic SQL. Show all posts
Showing posts with label Dynamic SQL. Show all posts
Friday, February 13, 2026

Db2 Performance Myths That Refuse to Die

›
After decades of working with IBM Db2 for z/OS , I’m continually surprised that some performance myths simply refuse to go away. Despite new...
2 comments:
Monday, November 15, 2021

Db2, SQL, and Modern Coding Techniques

›
  Mainframe application development has changed dramatically during the lifetime of Db2. Way back in the beginning, and even for a long time...
2 comments:
Friday, February 24, 2017

The DB2 12 for z/OS Blog Series - Part 5: Enhancements for Managing Dynamic and Static SQL

›
Most modern application development is done using dynamic SQL. But some features work only with static SQL and others only with dynamic SQL...
Tuesday, February 25, 2014

Dynamic SQL - Let's Do The Math

›
We've come a long way in the world of DB2  in the past decade or so. I remember way back when it was common for DBAs to say  "If p...
Friday, September 04, 2009

Dynamic SQL Causing Lock Escalation?

›
Lock escalation is the promotion of a lock from a row, page or LOB lock to a table space lock because the number of page locks that are conc...
3 comments:
Friday, January 25, 2008

Get Control of Access Path Changes for Dynamic SQL when Migrating to a New Version of DB2

›
Are you making plans to migrate to a new version of DB2? Do you know what impact the access changes for dynamic SQL will have on performance...