A script to reorganize each partition one by one in a datapartioned table while allowing read access. Works on DB2 9.7 and earlier. This script can be further modified to your ...
This article demonstrates how to check LOAD and IMPORT operations through ETL calls to SYSPROC.ADMIN_CMD in a database partitioning (DPF) environment. Developers can do this simply, ...
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 ...