DB2 for z/OS UDF to convert HEX into a bit string
DB2 for z native SQL UDF to convert hexa-decimal numbers to decimal number (or integer)
JCL to clone a DB2 subsystem by doing a Homogeneous System Copy (HSC), most useful in a SAP environment. Uses the WAITFOR REXX (available in the Code Place). Carefully review the JCL ...
Does what it says in the title line! Will also work in V7 and V8 CM as long as you remove the STATSTIME CASE structure for the TP and IP. Now updated with a new file for DB2 10 ...
A REXX edit macro for Cobol/DB2 programmers - formats SQL statements and inserts them into source code
insert the output of an Insight/DB2 trace-request into a DB2 table
REXX can be used in a batch step preceding the LOAD Utility to cancel SERVER-type distributed threads
CANTHRED will list all the active threads in a DB2 subsystem and let you issue a cancel for one or more threads, if you authorized to do so. Invoke it by specifying [CANTHRED ssid]. ...
formats the output to a sequential file containing: ssnm macro parm heading value I use this input (and all the others) for a total overview & audit (compare agains standards) for all ...
Lists the tables in a subsystem