dtxprof utility command

The dtxprof utility command returns 0 if the Map Profiler is successful and 1 if it is not successful. It is a batch operation that can also be used for automation.

The Map Profiler is a user-configurable utility that captures and reports map execution statistics. The profiler focuses on component and mapping rules and the functions and types within those rules. The resulting information enables you to see where performance is lagging and in turn make improvements in your maps.

For example, in the profile report you see that the processing time for a LOOKUP function is significantly more than other functions. You can modify the rule to use a better choice, such as the SEARCHUP function (because in this specific case the data in the LOOKUP is ascending), and as a result the processing time is greatly reduced. See Data Search Usage in the IBM Transformation Extender Performance Recommendations documentation for more information about recommended usages of the different search functions to achieve your performance objectives.

See "Troubleshooting" for details about capturing and evaluating the return code resulting from the execution of this utility command.

You can use the dtxprof utility command to calculate suggested settings for memory page size and count for work files used in maps that you are running with the z/OS Batch Command Server. See z/OS Batch Command Server dtxprof Usage.