Using the Trace adapter command

Edit online

About this task

To produce database trace information for specific database data sources or targets, use the Trace adapter command (-TRACE). For information about the syntax of this command, see the Resource Adapters documentation.

To produce the database trace file when using the DBQUERY or DBLOOKUP functions, use the Syntax2 format to call the function. For example, if output card 3 contains a DBLOOKUP function, call the function as

DBLOOKUP ( "SELECT ...", "-DBTYPE DB2 -SOURCE LAMBIN 
                        -USER ARL97IN -TRACE").