Data Transformation Engine Database Interface Designer Reference Guide

Chapter 10 - Debugging and Viewing Results Database Trace Files
Database Interface Designer Reference Guide
150
This sample database trace file (map_name.dbl) reveals important information,
examples of which are described below.
♦ Lines 1-5 show information about the connection made, identifying the
database type as Oracle as well as the version number of the interface library.
In this example, there was no existing database connection and a new
connection was successfully established.
♦ Line 6 indicates that the data is being retrieved for input card number 2.
♦ Line 7 identifies the version of the database adapter for Oracle. Lines 8–11
identify the information used to make the connection with the Oracle database:
the host string, user ID, and password. Because this information is for an input
card, there is a message indicating that a database unload is being started.
♦ Next, the database trace file indicates that the query successfully executed (as
indicated by the following text on Line 18: Statement execution succeeded)
and includes descriptions of the ten columns to be retrieved.
♦ The results of the query are written to the buffer. 543 records (rows) were
retrieved using this query.
Use the Trace adapter command (
-TRACE) for as many database source or targets
as desired. Note that the information for later cards is appended to the default
database trace file unless a file name is specified using the
-TRACE filename
option as described in the Resource Adapters Reference Guide.
The exact information in the database trace file varies, depending upon the
information returned by different entities including the database driver, database
source versus target, and so on.
Database Trace for a Source with Errors
The example in the preceding section provided database trace information for a
database source with no problems. The following is an example of information you
may see when there are errors while accessing the database source.
Database type is Oracle
Status returned to engine: (0) Success
No existing connection was found.
Connection to Oracle has been established.
Interface library version 6.0(140)
Data being retrieved for input card 1.
Database adapter version 6.0(140)
Starting a database unload...
Host string:
Userid : demo
Password : ****
Query : SELECT * FROM BONUSS
Query size : 20
Output is to a buffer.
Error in: oparse