Skip to Content

IQ log .iqmsg file did not update until stop server

Hi,

We use SAP IQ16 SP8 for data warehouse. We found that the .iqmsg did not change anything since IQ server started.

It only bulk update all activities when we stop the server.

This make us very difficult to find out what's happening.

Cause we are try tuning our ETL.

Best regards,

Chupong

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 10, 2016 at 01:43 PM

    IQ continually adds to the .iqmsg log.

    In Linux/Unix, you can 'tail -f' the file to watch entries add to it.

    For Windows, the file is locked exclusively until the IQ server quits.  It is still growing, but you cannot see it.

    There may be ways to see the file in Windows as it grows, using some OS features (I think you can play wtih pipes, the user starting the service and powershell, but do not know specifics).

    What platform are you on?

    Chris

    Add comment
    10|10000 characters needed characters exceeded

    • What ETL tool are you using?  In their bulk loader, is it actually calling the IQ bulk loader?

      As far as the IQMSG is concerned, there are tools that can see the file as it is changing.  It's been a while, but I seem to remember using Cygwin 'tail' (specifically tail -f) to see the changes to the tail.

      You may want to grab the open source Cygwin tools that give you more Linux like commands and control.

      Mark