B.2 Cosminexus DABroker Library
In Cosminexus DABroker Library, the connection ID is output to extended database access trace.
This section describes the how to acquire the extended database access trace and output format of the trace.
- Organization of this subsection
(1) Extended database access trace
The Extended database access trace is a trace that outputs the access information from the time of database connection until disconnection. The extended database access trace is output each time a connection is established with the database.
The following conditions must be satisfied to output the connection ID to the extended database access trace:
- Conditions for output of the connection ID (In HiRDB)
-
-
The version of HiRDB client must be 07-01 or later.
-
0 or a higher value must be specified in DABEXSQL_TRC_LINE of the Cosminexus DABroker Library operation environment definition file.
For details about setting the operation environment of Cosminexus DABroker Library in Windows, see Chapter 18 in the uCosminexus Application Server Compatibility Guide, and for UNIX, see Chapter 18 in the uCosminexus Application Server Compatibility Guide. For details about the Cosminexus DABroker Library operation environment definition file, see Chapter 18 in the uCosminexus Application Server Compatibility Guide.
-
- Conditions for output of the connection ID (In Oracle)
-
-
You must be using Oracle9i or Oracle10g.
-
-1, 0, or a value in the range of 1024 to 32767 must be specified in DABEXSQL_TRC_LINE E of the Cosminexus DABroker Library operation environment definition file.
In Windows, use the environment settings utility to set the Cosminexus DABroker Library operation environment definition file. For details about setting the operation environment of Cosminexus DABroker Library using the environment settings utility in Windows, see Chapter 18 in the uCosminexus Application Server Compatibility Guide, and for UNIX, see Chapter 18 in the uCosminexus Application Server Compatibility Guide. For details about the Cosminexus DABroker Library operation environment definition file, see Chapter 18 in the uCosminexus Application Server Compatibility Guide.
-
(a) How to acquire
The storage location of extended database access trace is as follows:
-
In Windows
Files under the Cosminexus-DABroker-Library-operation-directory\spool\db_access directory
-
In UNIX
Files under the /opt/DABroker/spool/db_access directory
(b) Output format
The output format of extended database access trace is as follows:
For details about the output format of extended database access trace, see Chapter 18 in the uCosminexus Application Server Compatibility Guide.
- In HiRDB
-
The connection ID is output to the HiRDB_CONNECTION_ID column.
-
In Windows
*-------------------------------------------------------* *- DataBase Access Information (DRV) -* *- Date YYYY/MM/DD hh:mm:ss.nnnnnn -* *-------------------------------------------------------* DABroker Connect ID : AAAA(BBBBB) Process ID : CCCCC UserID : DDDD Client Name : EEEEE (information-output-for-each-DB) Lang Mode : GGGGG THREAD-ID CID EVT START-TIME END-TIME RETCODE BLOCKCNT (Windows QueryPerformance Counter) HiRDB_CONNECTION_ID (trace-information) (SQL)SS...SS (trace-information)
-
In UNIX
*-------------------------------------------------------* *- DataBase Access Information (DRV) -* *- Date YYYY/MM/DD hh:mm:ss.nnnnnn -* *-------------------------------------------------------* DABroker Connect ID : AAAAA(BBBBB) Process ID : CCCCC UserID : DDDDD Client Name : EEEEE (information-output-for-each-DB) Lang Mode : GGGGG THREAD-ID CID EVT START-TIME END-TIME RETCODE BLOCKCNT HiRDB_CONNECTION_ID (trace-information) (SQL)SS...SS (trace-information)
-
- In Oracle
-
The connection ID is output to the ORACLE_CONNECTION_ID column.
*-------------------------------------------------------------------* *- DataBase Access Information (ORACLE8i Driver) -* *- Date YYYY/MM/DD hh:mm:ss.nnnnnn -* *-------------------------------------------------------------------* DABroker Connect ID : AAAAAAAA(BBBBB) Process ID : CCCC UserID : DDDDDD Client Name : EEEEEE SQLNET : FFFFFF Lang Mode : GGGG *--------------------------------------------------------------------* THREAD-ID CID EVT START-TIME END-TIME RETCODE BLOCKCNT ORACLE_CONNECTION_ID (trace-information) (SQL)SS...SS (trace-information)