473,320 Members | 1,859 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,320 software developers and data experts.

Fenced user/instance question

Running DB2 8.2 on AIX 5.2.

If you have more than one instance on a box is there a way that can be
used to determine which is the name for the fenced user for a
particular instance?

Thanks in advance.

Gerry

Nov 12 '05 #1
2 1874
da*******@yahoo.com wrote:
Running DB2 8.2 on AIX 5.2.

If you have more than one instance on a box is there a way that can be
used to determine which is the name for the fenced user for a
particular instance?

Thanks in advance.

Gerry


Check the owner of ~InstanceID/sqllib/adm/.fenced file

(if it's not adm, look into bin or misc directories)

Keith Ponnapalli
IBM Certified Advanced Database Administrator - DB2 UDB V8.1 for
Linux,UNIX, and Windows
INFORMIX Certified Database Administrator

Nov 12 '05 #2
Thanks Keith.
That worked.

Nov 12 '05 #3

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

Similar topics

60
by: Fotios | last post by:
Hi guys, I have put together a flexible client-side user agent detector (written in js). I thought that some of you may find it useful. Code is here: http://fotios.cc/software/ua_detect.htm ...
4
by: Fan Ruo Xin | last post by:
I can truncate a version8 table by using "import from /dev/null ... replace into ..." when I use version8 client. But I failed to truncate the same table by using the same way if I connect from a...
1
by: NG | last post by:
Hi All, I am trying to create a new db2instance using db2icrt command. It has a parameter -u FENCED USER ID. I want to use same FENCED USER ID as that of our existing DB2INSTANCES. I...
5
by: Jeff | last post by:
I have question about differences in fenced sql procedures and fenced stored procedures. Do fenced sql procedures take up an extra memory segment when executed? Reason I ask is we have several...
2
by: NU2_UDB | last post by:
I have been assigned a few UDB instances to maintain. I would like to find out the name of the fenced user used when the instance was created. Is it possible to get that information by using...
7
by: jsale | last post by:
I'm currently using ASP.NET with VS2003 and SQL Server 2003. The ASP.NET app i have made is running on IIS v6 and consists of a number of pages that allow the user to read information from the...
5
by: Doug Handler | last post by:
Hi, I have a form (Form1) that contains a tab control which one tab has a customer user control (UserControl1). When the user double-clicks on the grid hosted there a new user control is...
0
by: th_maran | last post by:
Hi What is the difference between Fenced and Unfenced in DB2 UDB Thanks in a dv thirumaran
0
by: pcdb22009 | last post by:
Hi there, I would like to know if we can use the same fenced owner user id which is used with existing db2 instance of db2 version V9.1 for a new instance of db2 version V9.5, (both copies exist...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.