Code Place

145 Entries
 
 
17 days ago
Be the first person to recommend this.

Db2 native Stored Procedures that need to be retrieved from the catalog may need to be reformatted to 72 chars per line.
This REXX extracts and reformats such Stored Procedures.
Also ...

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

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

Attachments
2 years 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
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
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