Submitted along with REXX and panel (for completeness). This is the same as Ron Root's original message member.
Reads the DB2 Plan tables and presents the data via ISPF. Loads Changes packages into a DB2 table for review.
This code snippet uses the IGGCSI00 routine to access the Catalog Search Interface (CSI) for retrieving file information (VSAM, GDG, flat files). A REXX proc puts the data into a flat ...
Rexx routine to build VSAM delete/define members for any requested dataset. Useful if the original to for disaster/recovery. Uses the CATALOG SEARCH INTERFACE. Includes sample JCL
A set of panels and batch jobs that will report changes in access path selection based on the data in the plan table. Panels will show package SQL and support the creation of HINTS. ...
Customize Explain for your application you can easy read and understand
DB2 Row Numbers for Z/OS, OS/390 (Versions 6, 7, and 8)
This table lists all the types of DB2 workload and the fields describing that work that can be used to classify the work within Workload Manager
This is a job that issues -ARCHIVE LOG in the 1st step and the 2nd step checks the status up to 20 times, with a 30 second pause between each check. CC=0 means the archive is complete. ...
CANTHRED will list all the active threads in a DB2 subsystem and let you issue a cancel for one or more threads, if you authorized to do so. Invoke it by specifying [CANTHRED ssid]. ...