Menu

IQ Status table not being populated for one IQ instance

Help
2025-08-19
2025-08-20
  • Piers Collins

    Piers Collins - 2025-08-19

    Hi JP,
    we have several IQ 16.1 instances under asemon. However one of them I'm having issues getting all of the required statistical information. For example these are not being populated

    server1_AmStats
    server1_IQCnx
    server1_IQMPXInfo
    server1_IQSQL
    server1_IQStatus
    server1_IQSysmon1
    server1_IQSysmon2
    server1_IQSysmon3
    server1_IQTblSize

    But these are

    server1_IQCtx
    server1_IQDbSpace
    server1_IQIdxUse
    server1_IQTblUse
    server1_IQXacts

    I see no errors in the logs explaining why and the logger has full privs. I can run sp_iqstatus as the logger account in the IQ server for example.

    The config file has the required enable for each of the collectors.

    Is there extra tracing I can switch on to find out why these aren't being populated ?

    We are running V3.2.4

    Thanks

    Piers

     

    Last edit: Piers Collins 2025-08-20
  • Piers Collins

    Piers Collins - 2025-08-20

    Hi,
    ignore this.. I managed to get it to start collecting. It was a latency issue with the collectors returning results.

    Regards

    Piers

     

Log in to post a comment.