Here you can find DB2 related resources
For detailed explanation regarding each script, please visit the blog.

 

DB2JGEN	a REXX script that tailor skeletons by SQL select result set
IXRNSTS	Runstats Index skeleton example for DB2JGEN
TSRNSTS	Runstats Tablespace skeleton example for DB2JGEN
JOBISPF	jcl example for running DB2JGEN
SDXCMPT	a REXX script to compare access paths between DB2 systems for a package
DB2FXIDN	a REXX script that fix identity value problems pre v8 nfm

CPSTSJOB	Sample job for DB2CPSTS
DB2CPSTS	a REXX script that generates SQL statements to copy statistics by tablespace
DB2PCKCS	a REXX script calls DB2CPSTS for every tablespace a given package depends on

 

 

 

Partitioning implementation for DB2 Express

SP_ADD_PARTITION	Procedure to add a partition
SP_REMOVE_PARTITION	Procedure to drop a partition
SP_RECREATE_PVIEW	Procedure to recreate the partitioned view
CREATE_CONTROL_TABLES	SQL to create control tables