Have you ever run the db2 [call get_dbsize_info(?,?,?,0)] command to get the size of your DB2 LUW database and noticed that the size is much smaller than the space used on your UNIX ...
Small change to original panel from Ron Root
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