Looking for a way to write to the IQmsg file (errorlog) from within IQ

[Former Member]

In ASE, we have dbcc logprint ("some string") to write to the ASE errorlog from within ASE. I'm looking for a way to do the same for IQ.  I can't just do a "echo some_string >> instance.iqmsg" because what actually gets inserted may be garbled because of the massive number of writes IQ does by just sitting there.

[Former Member · Accepted solution]

I'm not sure why do you want to insert in the .iqmsg, but you can use the MESSAGE statement (see link SyBooks Online) to print a message in the server log (smaller, easy to read, easy to parse if needed)

[saroj_bagai · Accepted solution]

you can use sp_iqlogtoiqmsg ()

[saroj_bagai · Accepted solution]

DBA)> sp_iqlogtoiqmsg ('Test to print to iqmsg')
Execution time: 0.004 seconds

or

(DBA)> sp_iqlogtoiqmsg "Test to print to iqmsg2"
Execution time: 0.002 seconds

(DBA)> commit
Execution time: 0.004 seconds

I. 02/11 13:33:04. 0000042506 PostCmt 0

I. 02/11 13:33:06. 0000042500 Txn 12176689 0 12176689

I. 02/11 13:33:06. 0000042500 Test to print to iqmsg

I. 02/11 13:33:06. 0000042507 Txn 12176690 0 12176690

I. 02/11 13:33:06. 0000042507 Cmt 12176691

I. 02/11 13:33:52. 0000042530 PostCmt 0

I. 02/11 13:33:53. 0000042500 Test to print to iqmsg2

I. 02/11 13:33:54. 0000042531 Txn 12176738 0 12176738