Correlating connection information

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 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. The following procedure tells you how to correlate the connection identifiers in the .srvlog and  .iqmsg files to find relevant information.

StepsCorrelating connection information between the .srvlog and .iqmsg files

  1. 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
    
  2. 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.