Code Place

143 Entries
 
 
one year ago
1 person recommends this.

Calculates how full and how close to maximum capacity a partition is. This is for DB2/z.

 

Updated to use NPAGES instead of NACTIVE.

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

This Rexx Exec can be modified to take advantage of DSNACCOX.

 Available from ---> https://ruban.de/db2zos/rexx-procedure-to-execute-dsnaccox-db2-supplied-stored-procedure-v10/

 /* ...

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

DB2 for z/OS UDF to convert HEX into a bit string

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

DB2 for z/OS UDF that converts a bit string into a number

Attachments
4 years ago
1 person recommends this.

DB2 for z native SQL UDF to convert hexa-decimal numbers to decimal number (or integer)

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

Not all fields are processed , but a good start that you can use to adapt it to your needs

The rexx can only process 1 date/lpar/ssid at a time.

SMF records should be selected/narrowed ...

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