Good instructions/hints on using Pro*COBOL on UNIX

We have a legacy system that we have ported from another database system to Oracle. It contains several million lines of Pro*COBOL (yech!) code. We are currently running on HP-UX.

We are now in the process of fine tuning the code to improve performance. The old database system was not truly relational, and just didn't behave in the same way as Oracle, so the design of many of the tables is causing severe performance problems with a true SQL-based system. We have been using combinations of bstat/estat and SQL TRACE (with EXPLAIN PLAN) output to try and pinpoint bottlenecks.

Can anyone offer any hints on how to more precisely find out what is going on inside some of our huge Pro*COBOL programs? Are there any tools out there that make the job of looking over TKPROF output and database performance data any easier. Are there any down-and-dirty queries we can perform against the data dictionary when some of our programs are running to get more detail about what's going on? Does anyone have hints or suggestions about using Pro*COBOL, other than dropping it and going to Pro*C? ;^) Any good books on Pro*COBOL?

Thanks,
Brian

-- 
Brian M. Biggs                             mailto:bbiggs_at_cincom.com
Cincom Systems, Inc.                       voice: (513) 677-7661
http://www.cincom.com/