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.
The Script can be used to get the accessplans at the stored procedure level
Calculates how full and how close to maximum capacity a partition is. This is for DB2/z.
Updated to use NPAGES instead of NACTIVE.
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 ...
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/
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.
DB2 for z/OS UDF to convert HEX into a bit string
DB2 for z/OS UDF that converts a bit string into a number
DB2 for z native SQL UDF to convert hexa-decimal numbers to decimal number (or integer)
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 ...
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504