SAP Knowledge Base Article - Preview

2173781 - Request log file ( -zr output ) analysis in SAP IQ

Symptom

  • How to read and interpret the request log file in IQ ? 
  • The format of request log for is as follow:
=,>,1,PREPARE,0
+8505,<,1,PREPARE,grant connect to "testuser" identified by encrypted '***'
=,>,1,PREPARE,262163
+2,<,1,EXEC,262163
+66,>,1,EXEC
+13642,<,1,DROP_STMT,262163
=,>,1,DROP_STMT
=,<,1,PREPARE,grant resource to "testuser"
=,>,1,PREPARE,262164
=,<,1,EXEC,262164
+23,>,1,EXEC
+16631,<,1,DROP_STMT,262164
=,>,1,DROP_STMT
+47,<,1,PREPARE,grant all privileges on "GROUPO"."Employees" to "testuser"
=,>,1,PREPARE,262165
=,<,1,EXEC,262165
+12,>,1,EXEC
+12399,<,1,DROP_STMT,262165
=,>,1,DROP_STMT
=,<,1,PREPARE,call "sp_iqtable"()
=,>,1,PREPARE,262166
+3,<,1,OPEN,262166

or

0523 095954.807,[,1000000001,sp_iq_mpx_init,16,iq utilities status 1  +2,],1000000001,sp_iq_mpx_init,16
+1,[,1000000001,sp_iq_mpx_init,62,message STRING('IQ Server ',@@servername,'.') to console
+2,],1000000001,sp_iq_mpx_init,62

 


Read more...

Environment

  • SAP IQ 15.x
  • SAP IQ 16.x

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

'-z' , '-zr' , Reuqest log, trace file, , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.