Code Place

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

Steps to do :

- Submit IFASMFDMP to extract SMF100 (jcl not provided)

- Submit the provided JCL100 which will sort the SMF dataset and give it as input to the program REX100

Note ...

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

REXX-Library that contains scripts of presentation 'Tuning with Virtual Indexes - A Brute-Force-Approach' at IDUG 2015, Dublin.

Please see presentation for details.

For problems, ...

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

SQL to create GRANT statements to copy table data privileges (SEL/INS/UPD/DEL only) from one schema to another. Resulting statements are longer than 72 characters/line.

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

The SQL One Liners can be used for different tasks like Getting the Long Running SQL's, Lock-wait details, Top Dynamic SQL's etc

Attachments
6 years ago
1 person recommends this.

The script Drive_RunstatScript.cmd will control the execution of the ps1 members, the parameter labelled "ameddev" is my database name, so replace that with your database name. Also ...

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

"DB2 in the Big Data World"

Have you been hearing all the talk around big data?: Are you concerned that hadoop is flavour of the month, and the general principles of database management ...

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

This produces a menu of DB2 subsystems (active and not) which can be passed to another command.  REXX code and ISPF menu

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