Code Place

147 Entries
 
 
6 years ago
Be the first person to recommend this.

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

Attachments
6 years ago
1 person recommends this.

DB2 for z native SQL UDF to convert hexa-decimal numbers to decimal number (or integer)

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

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 ...

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

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 ...

Attachments
15 years ago
1 person recommends this.

A REXX edit macro for Cobol/DB2 programmers - formats SQL statements and inserts them into source code

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

insert the output of an Insight/DB2 trace-request into a DB2 table

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

REXX can be used in a batch step preceding the LOAD Utility to cancel SERVER-type distributed threads

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

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]. ...

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

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 ...

Attachments
17 years ago
1 person recommends this.

Lists the tables in a subsystem

Attachments