Code Place

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

edit macro you can use to execute DB2 commands from an ISPF edit session.

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

Very usefull for generating SQL/JCL that has incremented numbers (DDNAMES, Step names, etc).

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

IDUG EU 2004 session entitled [Monitoring Your Database With Just SQL Scripts] and are intended to give you samples. The scripts cover performance tuning including bufferpool, sort, ...

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

Reads the DB2 Plan tables and presents the data via ISPF. Loads Changes packages into a DB2 table for review.

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

SQL statement for DB2 on Z; identify and create DROP statements for all aliases whose tables (or views) do not currently exist.  (Uses Common Table Expression and UNION to create multi-line ...

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

The force application command is asynchronous. This script loops and makes sure that all applications are forced off. This can be run before taking a full offline backup.

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

1) Generates a calendar and prints out the last working day of the month. 2) Prints factorial of numbers from 1 to N

(does not work on DB2 z/OS)

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

GENALTER will generate ALTER SQL for stogroup defined objects and comments for user defined objects. The output will only contain those objects that should be resized. This rexx uses ...

Attachments
8 years ago
1 person recommends this.

JCL for generating DB2 subsytem parameter settings report (DSNZPARMs) thru IBM supplied program DSN8ED7.

DSN8ED7 is a C-language caller of stored procedure DSNWZP. You must have ...

Attachments