Connection information in the iqmsg file

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.

NoteTo correlate connection information in the -zr log file with that in the .iqmsg file, see “Correlating connection information” on page 43 Sybase IQ Troubleshooting and Error Messages Guide.