by Craig S. Mullins | Jun 26, 2023 | BIND, data studio, explain, performance, sql, tips and tricks, visual explain
Query execution plans play a crucial role in identifying performance bottlenecks within an IBM Db2 database. When a query is executed, the database optimizer determines the most efficient way to retrieve the requested data by generating a query execution plan. It does...
by Craig S. Mullins | Nov 15, 2021 | BIND, Dynamic SQL, sql
Mainframe application development has changed dramatically during the lifetime of Db2. Way back in the beginning, and even for a long time thereafter, most Db2 programs were written in COBOL and coded to use static SQL. This meant that the SQL was bound before...
by Craig S. Mullins | Sep 17, 2020 | BIND, COBOL, Java, jdbc, SQLJ
As most Db2 developers and DBAs know, when you modify a Db2 program you have to prepare the program to enable it to be executed. This program preparation process requires running a series of code preprocessors that—when enacted in the proper sequence—creates an...
Recent Comments