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. From a quick, little runstats script in ksh, to a full blown application to load data or “fix a few rows”, it seems that if it is in the...
Attached is a copy of my slide-deck for the DB2’s Got Talent - 2016 contest Hope the sample code content is useful
Some helpful DB2 LUW sql and db2cos script discussion.pdf
The Time Spent hierarchy in DB2 LUW is a great way to understand where your system is busy or where it's waiting, and more metrics are added to it on a regular basis. This script captures the entire DB2 10.5 wait time hierarchy, showing by % where time is spent. It uses delta...
The script Drive RunstatScript.cmd will control the execution of the ps1 members, the parameter labelled "ameddev" is my database name, so replace that with your database name. Also this script is the member scheduled in MS Windows Scheduler. The script RunstatScriptbld.ps1 will generate...
3 attachments
A script to reorganize each partition one by one in a datapartioned table while allowing read access. Works on DB2 9.7 and earlier. This script can be further modified to your needs.
db2reorgpartitions.sh.txt
Make your life simpler with scripting the day to day jobs and DB2. Master the tricky quoting of params in Windows and different Unix shells. Use pipes for redirected restores and parse DB2 output to feed it back into other programs.
EU13F13.pdf