Code Place

145 Entries
 
 
7 years ago
1 person recommends this.

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

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

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

Attachments
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
9 years ago
1 person recommends 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
9 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
9 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
10 years ago
2 people recommend this.

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

Attachments
10 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
10 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
10 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