Data Transformation Engine Database Interface Designer Reference Guide

Chapter 10 - Debugging and Viewing Results Database Audit Files
Database Interface Designer Reference Guide
165
specify a name or the full path for the file. For more information, refer to the
Resource Adapters Reference Guide.
The database adapter audit file provides the following details for each database
access:
♦ Execution Time (Audit Time)
This is the amount of clock time (in seconds) the database adapter takes to
execute the database action (for example, the retrieval of all rows for a data
source, a single instance of a
DBLOOKUP function, and so on).
♦ Adapter Return Code (AC)
This is the adapter return code as a result of executing the database action.
♦ Connection
This information identifies the connection used for each database action. This
can be helpful in determining ways to configure your map to minimize the
number of database connections that must be made.
♦ Map Name (Map)
This is name of the compiled map file.
♦ Access Type (Input Card, Function, or Output Card)
This information identifies the type of database action (for example, whether
the type is for an input card, output card, or for a
DBLOOKUP, DBQUERY, GET, or
PUT function).
♦ Additional Information
This information is provided (when appropriate) for each database action such
as the SQL statement associated with an input card, the name of the table or
stored procedure for a database target, or the SQL statement executed by any
of the functions for interfacing with data in a database (for example,
DBLOOKUP,
DBQUERY, PUT, and GET).
The following is an example of the database audit file produced for a map that has
one database source (input card #2), executes five
DBLOOKUP functions, and has a
single database target (output card #1).