Code Place

143 Entries
 
 
8 years ago
Be the first person to recommend this.

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 ...

Attachments
8 years ago
Be the first person to recommend this.

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 ...

Attachments
8 years ago
1 person recommends this.

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  ...

Attachments
8 years ago
Be the first person to recommend this.

This SQL counts the number of levels of referential integrity (parent, child, grandchild, etc.) that exist in a database schema (up to 100 levels)

Attachments
9 years ago
1 person recommends this.

Script enclosed to aid in reporting on runstats information for range-partitioned tables & their indexes and statistical views.

Attachments
9 years ago
1 person recommends this.

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. ...

Attachments
9 years ago
Be the first person to recommend this.

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 ...

Attachments
9 years ago
1 person recommends this.

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 ...

Attachments
9 years ago
Be the first person to recommend this.

Required source code for the packet sniffer. See my blog for details on it's use.

Attachments
10 years ago
Be the first person to recommend this.

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)

Attachments