Code Place

143 Entries
 
 
13 years ago
Be the first person to recommend this.

Submitted along with REXX and panel (for completeness). This is the same as Ron Root's original message member.

Attachments
13 years ago
Be the first person to recommend this.

Reads the DB2 Plan tables and presents the data via ISPF. Loads Changes packages into a DB2 table for review.

Attachments
13 years ago
Be the first person to recommend this.

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 ...

Attachments
13 years ago
Be the first person to recommend this.

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

Attachments
13 years ago
Be the first person to recommend this.

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. ...

Attachments
13 years ago
Be the first person to recommend this.

Customize Explain for your application you can easy read and understand

Attachments
13 years ago
Be the first person to recommend this.

DB2 Row Numbers for Z/OS, OS/390 (Versions 6, 7, and 8)

Attachments
14 years ago
Be the first person to recommend this.

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

Attachments
14 years ago
Be the first person to recommend this.

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. ...

Attachments
14 years ago
Be the first person to recommend this.

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]. ...

Attachments