Code Place

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

Hi!

 I cobbled together a little SQL to create a cross-reference of all DB2 tablespace, tables and indexes with key columns, uniqueness etc. I use it all the time and I finally ...

Attachments
5 years ago
1 person recommends this.

Attached is a copy of my slide-deck for the DB2’s Got Talent - 2016 contest

Hope the sample code content is useful

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