edit macro you can use to execute DB2 commands from an ISPF edit session.
Very usefull for generating SQL/JCL that has incremented numbers (DDNAMES, Step names, etc).
IDUG EU 2004 session entitled [Monitoring Your Database With Just SQL Scripts] and are intended to give you samples. The scripts cover performance tuning including bufferpool, sort, ...
Reads the DB2 Plan tables and presents the data via ISPF. Loads Changes packages into a DB2 table for review.
SQL statement for DB2 on Z; identify and create DROP statements for all aliases whose tables (or views) do not currently exist. (Uses Common Table Expression and UNION to create multi-line ...
This file provides fixes for the old version of ODOT's DB2 DBA Assistant. Please note that a completely revised version of this tool is available for download here . Original ...
The force application command is asynchronous. This script loops and makes sure that all applications are forced off. This can be run before taking a full offline backup.
1) Generates a calendar and prints out the last working day of the month. 2) Prints factorial of numbers from 1 to N (does not work on DB2 z/OS)
GENALTER will generate ALTER SQL for stogroup defined objects and comments for user defined objects. The output will only contain those objects that should be resized. This rexx uses ...
JCL for generating DB2 subsytem parameter settings report (DSNZPARMs) thru IBM supplied program DSN8ED7. DSN8ED7 is a C-language caller of stored procedure DSNWZP. You must have ...