Search

1 to 3 of 3
Sort by

Library Entry
Tuning with Virtual Indexes - A Brute-Force-Appoach

REXX-Library that contains scripts of presentation 'Tuning with Virtual Indexes - A Brute-Force-Approach' at IDUG 2015, Dublin. Please see presentation for details. For problems, questions or comments please contact me at rolf.drees@fiduciagad.de. Kind regards, Rolf Drees 30.11.2015...

vxgen.txt

Rolf Drees's profile image

Library Entry
REXX to find subsystem wide allocated space for DB2 z/OS

This REXX takes SSID as an argument, queries SYSIBM.SYSSTOGROUP to get a list of unique VCAT names and uses ISPF LM services to report the total allocated space in tracks. A sample Batch JCL has been provided. This REXX comes without any warranty and released under GNU GPL license. If you...


Library Entry
RXSQL: Process SQL file input from a file with LRECL > 72

This Rexx program frees you from the input LRECL restrictions imposed by SQL processing utilities such as DSNTEP2. It accepts non-Select SQL statements from an input file of any LRECL less than 32K. Each input record must contain a complete SQL statement and is passed to DB2 for processing via...

RXSQL.TXT

Don Leahy's profile image