DBAs frequently get called on to develop “quick” database scripts and programs, never mind that we don’t have the time, the tools, or the training. Learn some tips and tricks for writing scripts to make your life easier.
What’s the main difference between single-row and multi-row inserts? Simply the performance. If you are inserting many rows in a loop via a single-row insert, you call DB2 for every single row, which means you spend some time for the communication with the DB2.
For the past 30 years, our focus as DB2 for z/OS database administrators has been on the support of COBOL programs with static queries that were relatively easy to control as they were identical throughout the business logic. Static SQL provided persisted access paths in the database s
We hope that you’ve enjoyed this month’s articles on DB2 performance on z/OS.
We talked about the new performance possibilities in DB2 11, about performance hints and tips for framework development, about explaining tuning to C-level and about efficient ways of replication.
Rodney Krick has made available an analyzer for the DB2 JCC Trace on the IDUG Codeplace here -
He has written a tutorial on how to use it, which we are delighted to share with the IDUG Community -