Tuesday, March 1, 2011

Yet another useful OMEGAMON DB2 V5.10 enhancement

I've mentioned quite a few enhancements that have come about as part or OMEGAMON XE for DB2 PM/PE V5.10. There is one more I want to mention.

The Application Trace Facility (ATF) is an important part of the the OMEGAMON tool, and has been for many years. It remains one of the most consistently useful pieces of the tool. One aspect, or quirk if you will, of ATF in prior releases has been if you want to see SQL text in the trace, you can see the actual text for Dynamic SQL, but for static SQL, all you got was the statement number. You would then have to look somewhere else, referencing the statement number, to see the actual text for static calls. In V5.10 this is changed. You now have the ability to see the actual SQL text in the ATF trace regardless of whether it is a dynamic or static SQL call. Much more convenient since more often than not, the root of the problem may be poorly designed SQL code.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.