473,395 Members | 1,574 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

multiple DB2 instances under one OS userid?

It appears that normally each DB2 instance runs under a separate
Unix/Linux userid. Is it possible to run *multiple* DB2 instances
under a *single* userid?

If so, how can you identify which instance each top-level db2sysc
process is associated with?

I've traced the db2_local_ps, db2nps, and db2gdeps commands without
finding a solution.

ADVthanksANCE
Steve

Nov 12 '05 #1
3 2394
Ian
sthand wrote:
It appears that normally each DB2 instance runs under a separate
Unix/Linux userid. Is it possible to run *multiple* DB2 instances
under a *single* userid?


I don't think it's possible, but then again why would you want to?

The point of having a unique ID per instance is to prevent instances
from trouncing on each other. Similar to the idea of using a separate
ID for fenced processes.
Nov 12 '05 #2
I think you're right, it's not possible. I tried to do it with the
db2isetup utility and got the following error message: "The user you
selected already has an sqllib directory in their home directory. This
user cannot be used as the instance-owning user."

I was exploring this because it was reported to me that a particular
DB2 machine was set up this way, but they must have been wrong.
Thanks,
Steve

Nov 12 '05 #3
I saw a similar question in a quiz i was undergoing:

How many UDB Instances can a single userid own at anytime on a single
system?

a) None
b) One
c) More than One
d) As defined in db2 "get dbm cfg"
Correct answer is b).

regards,
dotyet

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Ramses van Pinxteren | last post by:
hello, I have a PHP/Javascript problem. If I want to make a multiple select like this one: $html .= "<td><select name='userid' onChange='changeuserinfo()' multiple size='10'>"; $html .=...
1
by: Martin V. | last post by:
Hello, Is the multiple instances capability of SQL2K mature enough for a Production system? We're looking at upgrading our hardware but the proposed solution calls for consolidating two...
1
by: Sindhu | last post by:
Any help is very much appreciated.. Little background.. * I am trying to install V8.1 on a Sun box. * Already there is a V7.2 running on this box. * V7.2 installed under userid "db2usr1",...
3
by: evolve | last post by:
in the trace information i am getting the following: userID 81 username nick....... projID 1 ProjName Jupiter inDus 4F2EA4......... ASP.NET_SessionId 0vg5mca..... ProjID 2
2
by: Sudheer | last post by:
Hi All, We need to restrict multiple users login to the system. If one user is online with one userID, we need to show the message "This user already logs in to the system" to the other user who...
4
by: Yavuz Bogazci | last post by:
Hi, i have created a treeview and this works nice. I have now a problem: I want to store 2 more Information to each Treeview Node like UserID and CompanyID. How can i do that? Thanks Yavuz...
6
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...
4
by: sjohnson1984 | last post by:
Hello all, I have a form which is generated using a database query - the recordset is filled with agent details, login time and the like, and there are as many rows in the table as records in the...
1
by: chocciies | last post by:
Hi! I want to delete multiple record via checkboxes. However, with no success. Is there sthg wrong with the value of my checkbox? Your help will be greatly appreciated. Thanks! <form...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.