Correlating Connection Information Between the .srvlog and .iqmsg Files

Technical Support may ask you to set the -zr option on the start_iq command in your configuration file.

This server startup option sets the request logging level to track statements sent to the server. Parameters are ALL, NONE, or SQL. The option produces a log file named for the server with the suffix .srvlog.

In the SAP Sybase IQ message file .iqmsg, each connection to the server is identified by a connection handle. The .iqmsg message file records the errors, warnings, and tracing information for each connection.

To correlate the connection identifiers in the .srvlog and .iqmsg files to find relevant information.

In the .iqmsg file, locate a connection of interest. For example:

Connect:  SA connHandle: 1000000061

These lines show the .iqmsg log file contents for this connection:

16:14:59. 0000000062 Connect:  SA connHandle: 1000000061
          SA connID: 31  IQ connID: 0000000062  User: DBA
03/17 16:15:00. 0000000062 Cmt 12064
03/17 16:15:00. 0000000062 PostCmt 0
03/17 16:15:00. 0000000000 Disconnect:  SA connHandle: 1000000061
                SA connID: 31  IQ connID: 0000000062  User: DBA

Isolate all of the lines for the connection by searching the .srvlog file for the number that follows “SA connHandle” in the .iqmsg file.

For example, search the .srvlog file for “1000000061”:

16:14:59. [,1000000061,sp_iqdbspace,48,select
str_replace(dbspaceName,'"',null) into dbspaceName_literal
03/17 16:14:59. P,1000000061,[S][0]DUMMY<seq>
03/17 16:14:59. ],1000000061,sp_iqdbspace,48
03/17 16:14:59. P,1000000061,[1]ISYSIQDBFILE<seq> JNL dbf<ISYSDBFILE>
JNL ISYSDBSPACE<ISYSDBSPACE>
03/17 16:14:59. [,1000000061,sp_iqdbspace,58,execute immediate with
quotes on   'iq utilities main into iq_dbspace_temp dbspace info
' || dbspaceName
03/17 16:14:59. P,1000000061,[S]INSERT ROWS
03/17 16:14:59. P,1000000061,[S]INSERT ROWS
03/17 16:14:59. P,1000000061,[S]INSERT ROWS
03/17 16:14:59. P,1000000061,[S]INSERT ROWS03/17 16:14:59. P,1000000061,[S]INSERT ROWS
03/17 16:14:59. ],1000000061,sp_iqdbspace,58
03/17 16:14:59. [,1000000061,sp_iqdbspace,60,select d.dbspace_name as DBSpaceName,   min(SegType) as DBSpaceType,...
03/17 16:15:00. ],1000000061,sp_iqdbspace,60
03/17 16:15:00. P,1000000061,Work[ Sort[ GrByH[ dbf<seq> JNL
ISYSIQDBSPACE<ISYSIQDBSPACE> JNL ISYSDBSPACE<ISYSDBSPACE> JH*
iq_dbspace_temp<seq> ] ] ] : ISYSIQPARTITIONCOLUMN<seq> :
idx<seq> : tab<seq>
03/17 16:15:00. [,1000000061,sp_iqdbspace,105,drop table
dbo.iq_dbspace_temp
03/17 16:15:00. ],1000000061,sp_iqdbspace,105
03/17 16:15:00. P,1000000061,[1]Work[ Sort[ sp_iqdbspace<call> ] ]

The connection handle in this example is 1000000061.