By Daniel L. Luksetich, DanL Database Consulting - SQL tuning is not just looking at an SQL statement and EXPLAIN information, but is also about verifying whether or not a tuning change, be it a change to a statement or change to a database object, actually has a positive impact on...

1 Comment - no search term matches found in comments.

Daniel Luksetich

Added Feb 16, 2015

View Forum

benchmark Data Studio DB2 for LUW DB2 for z/OS DSNTEP2 explain SPUFI SQL Performance

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

DB2 for z/OS DSNTEP2 LRECL rexx