?
Solved

Multiple DB2 Instance

Posted on 2001-06-29
2
Medium Priority
?
475 Views
Last Modified: 2006-11-17
Hi,

I want to use more one instance of UDB v7 on my Windows NT
server, but i can't because the environment variable
DB2INSTANCE support only one param.

What can i do ?


Thanks.
0
Comment
Question by:ThierryBertin
2 Comments
 

Accepted Solution

by:
gregnash earned 60 total points
ID: 6376746

DB2INSTANCE applies to the current or default instance.  You can create many instances, but any database connection can operate only within one instance at a time.
Once you've created your extra instances, use
SET DB2INSTANCE=xyz
to set which one you intend to use in the current session.

Different instances will need different IP ports for incoming connections, too.
0
 

Author Comment

by:ThierryBertin
ID: 6379624
Thanks,

It's work fine.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question