The connection handle and database user name, shown in the last line of the output example, are printed after the first transaction begins and before the next transaction starts. This information is printed only once per database connection.
You can use this connection information to match query plans in the iqmsg file with query text. Run the stored procedure sp_iqcontext to determine what statement each connection is executing at a given moment.
To correlate connection information in the -zr log
file with that in the .iqmsg file, see “Correlating
connection information”in the Sybase IQ Troubleshooting and Recovery Guide.
