Marshall,
You can use "db2iupdt -u" command to do this. And I guess that is the only straight
forward way you can change this assignment once the instance is created. Fenced id is
used at run time and any
resource required by the fenced object is allocated out of this instance's stack/heap.
This will prevent the db2 address space accidentally getting corrupted by a buggy
program. Price you pay is the
performance degradation caused by the additional handshakes involved.
Regards,
Ajith
-----Original Message-----
From: Marshall Fuqua [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 14, 2001 5:31 PM
To: [EMAIL PROTECTED]
Subject: DB2EUG:
Platform: DB2 UDB V7.1 running under AIX 4.3.3
When a DB2 instance was created, the installer (not me) did not explicitly
specify a user ID to be used for running fenced stored procedures & UDFs. My
question: is it possible to add a fenced user ID for an instance after the
instance is created? I can't find anything in the DB2 documentation or the
listserv archives on this subject. I'm guessing that you would create the ID &
associated group under AIX & then execute the 'db2iupdt' command with the '-u'
parameter to specify the user ID. Is this correct? If not, what is the correct
way
to accomplish this?
Thanks for your assistance.
Marshall
=====
Marshall Fuqua
[EMAIL PROTECTED]
__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
