Blog

A quick and dirty db2 datafix to remove some dodgy characters that was causing our application to fail. Of course we also corrected the application to stop inserting these characters in the first place.

DB2 9.7.5

UPDATE devt.LOG 
set message = replace(message,TRIM(TRANSLATE(message, ' ', '(){}!;...

The Historical Statistical Facility (HSF) provides the ability to record statistics related to the time spent in a COBOL program and the time that parts of that program spent in CICS API commands/tasks, SQL operations and JCL jobsteps, as well as associated file and TSQ accesses.

The records conta...

Command to get the current transaction count from the command line of a Micro Focus Server Enterprise Edition (assume it will work for Enterprise Server as well).

curl -silent http:

//servername:9503/esmac/casrdo5 | grep -A 1 Transactions | tail -1 | sed -e 's/]*>//g' -e 's/ //g'