DB2ClearOS - The All in One DB2 Express-C Web Stack Appliance. Watch the Promo Video below - HD recommended http://www.youtube.com/watch?v=BxbHjEo7Rp8&hd=1 Download the ...
What does this script do 1. Check for the space in the server 2. Take a backup (full online compress in this example) 3. Copy it to another server 4. Remove Old ...
Oregon Department of Transportation's DB2 DBA's Assistant & CRM ISPF Productivity Tool Version 1.0 (DB2v8) November 5, 2007 Version 1.1 (DB2v8) May 14, 2010 Version 2.0 ...
This SQL counts the number of levels of referential integrity (parent, child, grandchild, etc.) that exist in a database schema (up to 100 levels)
Script enclosed to aid in reporting on runstats information for range-partitioned tables & their indexes and statistical views.
Often a single-column index may not be of great help if there exists a composite index with 2 or more columns having the first column identical to one present in a single-column index. ...
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 ...
A sample Unix shell script (korn shell) for analysis of lock waits in DB2 LUW. The script is based on information gathered from db2pd. Side note: the script will run properly and ...
Required source code for the packet sniffer. See my blog for details on it's use.
Uses Case statements to format a String like [RETURNS >>> Tuesday the 21'st of August 2001] from a timestamp field (could also be used against a date field)