Code Place

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

If you ever need to recover a DB2 environment from a disaster or serious operational system problem and want the database to perform like it did before the recovery, information about ...

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

If you have application jobs or users that run the DB2 load utility and would like to keep track of this information over time there is valuable information stored in the DB2 diagnostic ...

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

Shows the DBRM SQL statements, with Unicode translation when necessary (well, ASCII to EBCDIC). Results are saved to a data set, which is then Browsed (when running under ISPF). Uses ...

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

Usage: place in your SYSPROC and type DB2 in front of a load module name in a loadlib member list display under ISPF. (Better still, compile and put in your ISPLLIB concatenation.) ...

Attachments
11 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
11 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
11 years ago
Be the first person to recommend this.

This file provides fixes for the old version of ODOT's DB2 DBA Assistant.

Please note that a completely revised version of this tool is available for download here .

 

Original ...

Attachments
11 years ago
1 person recommends this.

Supplied in PL/I source code format, this version of DSNTEP2 does not 'wrap' the output report around 133 byte lines. For best results, execute with ALIGN(LHS) run time option.

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

Does what it says in the title line! Will also work in V7 and V8 CM as long as you remove the STATSTIME CASE structure for the TP and IP.

Now updated with a new file for DB2 10 ...

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

I recently sent you RUNSQL in XMIT unload format. Here it is again in a simple .txt file.

Attachments