Skip to Content

Does SAP IQ can have 2 instances (DEV,UAT) in a single host?


I am new in SAP Sybase IQ and I am not a DBA. Could anyone please tell me on these questions.

1. Can we have a single Windows host that have 2 SAP IQ for DEV and for UAT instances or servers running together? How? Because they should not need much efficiency.

If it MS-SQL, I will have to install it 2 times for the 1st and the 2nd instance in difference instance's name and folder. These instances may have difference setting and able to start, stop them independence.

2. Does it need 2 licenses if we have 2 instances in same host?

Thanks in advance.


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Apr 07, 2016 at 05:13 PM

    It is possible to run two IQ servers on the same host. You should be able to create two different directories with your IQ database files, and start up an IQ server against each database. (You only need to install IQ binaries once.) You can specify individual server and database options for the two instances. You can also run IQ virtualized, and run 2 VMs on the physical machine.

    IQ licenses are keyed to the machine. The number of IQ instances does not matter. You will need enough core licenses to match the number of cores on the machine.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 08, 2016 at 04:27 PM


    you can create and run 2 (or more) IQ instances with the same binaries. So you run the installer once and create 2 instances (create database command). Upgrading IQ to a higher version affects the binaries; so an IQ upgrade will bring both IQ instances to the new version. (Of course you can do some rework and install the higher version in parallel. Then you will be able to upgrade one IQ instance only.)

    Or you can start with a different approach and install IQ software twice.

    Best regards,


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.