DB2 graphic  QMF Version 8

Selecting components for tracing

Check box next to each component you want to trace on the Traces page.

Table 61. Types of traces
Component Description
DDM [Distributed data management architecture]: used by the distributed file management and distributed relational database protocol to define the protocol for communicating between two systems using the distributed file management and the distributed relational database.
Note:
Select this option only if using a DRDA connection.
TCP [Transmission control protocol]: a host-to-host protocol that provides transmission in an Internet environment. TCP assumes Internet Protocol (IP) is the underlying protocol.
Note:
Select this option only if using a TCP/IP connection.
CPI-C [Common Programming Interface for Communications]: a programming interface that implements the APPC [Advanced Program to Program Communications] verb set. Applications that require the APPC verb set can be written using CPI-C to achieve SNA vendor independence. QMF for Windows is written using CPI-C.
Note:
Select this option only if using an SNA connection.
CLI [Call Level Interface]: an application programming interface for relational database access. Using CLI, client applications, such as QMF for Windows, can connect to DB2 UDB servers and execute SQL statements.
Note:
Select this option only if using CLI to access data in a database management system.
ODBC [Open Database Connectivity]: a standard that provides applications with a common interface to data held in relational databases. Any application that can act as an ODBC client can access data held in any relational database that has a suitable ODBC driver. ODBC accepts Structured Query Language (SQL) data requests from the client application and translates these into a form acceptable to the target database engine.
Note:
Select this option only if using ODBC to access data in a database management system.
Embedded SQL

SQL statements are embedded within a host language program and are prepared (with the BIND process) before the program is executed.

Embedded SQL allows programmers to connect to a DB2 database using the DB2 native interface to manipulate and process data.

SQLAM [SQL Application Manager]: a function that represents an application to the remote relational database manager. The SQL application manager can be present in an application requestor and an application server.
REXX [IBM Object REXX]: a programming language available for the mainframe and Windows environments. IBM Object REXX handles simple and complex calculations, logic, column definitions, detail variations, and conditions in QMF for Windows
Note:
Select this option only if you are tracing a procedure that uses IBM Object REXX.
Internet Mail Traces Internet Mail operations.
Messages Logs system messages issued by QMF for Windows and QMF for Windows Administrator by message ID, date, time, message text, message type, help ID, suppressed state and result.

For example:

================== Message ===============
00000434/000006B0 == Thu Apr 25 11:16:28.46 2006
Error dialog box:
-------------------------------------------------
An error occurred while binding the packages.
"GUEST" does not have the privilege to perform
operation "BIND" on object "QMFWIN8X.RAARDBI2".
(SQL code = -551, SQL state = 42501)
--------------------------------------------------
Help ID: 0000811B
Suppressed: false


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004