Code Place

144 Entries
 
 
15 hours ago
Be the first person to recommend this.

The Script can be used to get the accessplans at the stored procedure level

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

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

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

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

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