Code Place

147 Entries
 
 
12 years ago
Be the first person to recommend this.

This script lists candidate tables for compression. A text file is generated with information about the server, instance, database, # tablespaces, tablespace types (D=DMS, S=SMS), schema, ...

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

This script lists tablespaces that are candidates for conversion from SMS to DMS and from DMS regular to DMS large in support of a project to implement large record identifiers so that ...

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

Compares COBOL contoken for a given member in various dbrmlibs and loadlibs. Easy to tailor - library names are listed inside.

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

db2audit allows you to extract the information from the b2audit.log in delimited ASCII files for easy loading into tables.

Attachments
17 years ago
1 person recommends this.

Lists the columns and their characteristics of a table

Attachments
17 years ago
1 person recommends this.

DESCribe Trigger definition

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

These set of scripts provide a menu driven utility for DPF environment to perform diagnostic tasks as checking application using maximum cpu, uow log space, max rows read, lock-wait ...

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

This program will give a nice output of an Explain in batch. It will show access path and cost. Give credit to David Sollenberger, an associate . Pass a parm of the program name in ...

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

This rexx generates JCL needed to stop related tablespace/indexes, delete the underlying VSAM datasets and drop the objects in question. Catalog contention during drop of 254 part object ...

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

DB2 for z/OS UDF that converts a date that resides in 2 bytes into a YYYY-MM-DD date.

The origin of date in 2 bytes is from computing pre-history were every bit was precious.

It ...

Attachments