Skip to Content
avatar image
Former Member

com.sybase.scc.jmx.ManagedObjectGateway.err_invoke_op SCC agent db2v105:9999 does not know Sybase IQ version string. Something is wrong with the IQ Agent plug-in.

Hello All,

I am a student and just want to try my hands on SAP IQ. So i downloaded SAP for linux. I set up a Virtual machine on my windows and loaded the linux image onto the virtual machine. So far i have been successfully able to install SAP IQ, create database and so on. But I have only got as far as authenticating the agent after registering it. When i authenticate the agent it gives me the below error and obviously the authentication fails

"com.sybase.scc.jmx.ManagedObjectGateway.err_invoke_op SCC agent db2v105:9999 does not know Sybase IQ version string. Something is wrong with the IQ Agent plug-in."

So i searched on internet and followed the process mentioned in SAP info center under change request number 723112 however I am still unable to get it working. I would be really grateful if someone could help me ASAP. Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 06, 2014 at 10:37 AM

    Hallo All,

    I am doing some research of performance of sybase IQ. Could anyone please tell me how do I get the total IO cost for the query?

    Below is what I have so far. But it would be nice to get total cumulative IO cost. Appreciate your help Thanks in advance


    Add comment
    10|10000 characters needed characters exceeded

    • You can generate HTML query plans instead that contain more detail about a query by setting query_plan_as_html='on'; query_plan_after_run='on'; query_plan_detail='on'; etc.

      What you will get is the time it took to get the number of rows and the detail.

      As IQ is column-based, however, total IO cost is not the way to actually rank or rate IQ vs. other DBMS engines. What you really want is time to user, as other variables such as IQ indexing, disk configuration and memory can affect query performance.

      Chris

  • Sep 17, 2014 at 07:43 PM

    What is the version of IQ , SCC and OS ?
    I am assuming you have created the soft link as is suggested for cr 723112.

    Please indicate what you did exactly.

    Is IQ and SCC installed on the same machine , if so are they in the same $IQDIR directory or you have it under different main directory.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Harpreet Chaudhary

      I did this around 10 days back and i don't seem to have a problem ever since.. But i might need more help in the future so I will be active.. But thank you all for your help