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 4.3.1(3) Setting the operation environment of Cosminexus DABroker Library (in Windows) in the uCosminexus Application Server Compatibility Guide, and for UNIX, see 4.3.2(4) Setting the operation environment of Cosminexus DABroker Library (in UNIX) in the uCosminexus Application Server Compatibility Guide. For details about the Cosminexus DABroker Library operation environment definition file, see 4.22 Cosminexus DABroker Library operation environment definition file 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 4.3.1(3) Setting the operation environment of Cosminexus DABroker Library (in Windows) in the uCosminexus Application Server Compatibility Guide, and for UNIX, see 4.3.2(4) Setting the operation environment of Cosminexus DABroker Library (in UNIX) in the uCosminexus Application Server Compatibility Guide. For details about the Cosminexus DABroker Library operation environment definition file, see 4.22 Cosminexus DABroker Library operation environment definition file 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 4.6.3(2) Extended database access trace 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)