JRH DB2I2 Tips Download

 

 

Use ED macro to reuse DB2 Samplib

Use MACRO(xxxx) option with DB2I2 utility command to customize generated utility JCL

Use MAXASGN option with JRH DB2I2 DDL or MIGR command to calculate the start value for a Identity or Sequence column

Multiple Db2 versions/Lpar Support

Online Reorg Mapping Table Definition

RXDB2I2 Sample Scripts

RXDB2I2 Sample Scripts – Generate DSNJU003 Conditional Restart Job from last Archive Log RBA + 1

RXDB2I2 Sample Scripts – Automatically build and run DSCOPY from one location to another location

RXDB2I2 Sample Scripts – Sample Tso Receive and Delete Commands 

RXDB2I2 Sample Scripts – SIZEIT -  Size a Database with TS lines  

RXDB2I2 Sample Scripts – Size a Database with TP lines   

RXDB2I2 Sample Scripts – COPY a database with Dual Copy Based on Size information

RXDB2I2 Sample Scripts – Recover To LAST FULL COPY based on Size information

RXDB2I2 Sample Scripts – Recover To RBA with LISTDEF

RXDB2I2 Sample Scripts – Runstats Based on Site Information 

RXDB2I2 Sample Scripts –Reorg On Demand

RXDB2I2 Sample Scripts –Migration a structure and then DSCOPY data