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 ...
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 ...
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504