Question & Answer
Question
What method can be used to determine the fenced user id that was used during instance creation?
Answer
To determine the fenced user id, use one of the following methods:
- View the contents of the instance owner's $HOME/sqllib/ctrl/.fencedID file. For example:
cat /home/db2inst1/sqllib/ctrl/.fencedID
db2fenc1
- Issue the grep command against the db2fmp processes:
`ps -ef | grep -i [db2]fmp`
corrente 3448928 3801126 0 Nov 09 - 0:00 db2fmp
johncorf 3453130 3715122 0 Nov 08 - 0:00 db2fmp
In this example output, there are two different fenced users corresponding to two different instances on this server. The parent process id of the db2fmp process will correspond to the PID of the db2sysc process for that instance.
- As of DB2® Universal Database™ (DB2 UDB) Version 8.1 FixPak 12 and above the following command can be used to show the fenced user id:
db2pd -fmp
Example output is as follows:
Database Partition 0 -- Active -- Up 0 days 00:18:50
FMP:
Pool Size: 1
Max Pool Size: 426
Keep FMP: YES
Initialized: YES
Trusted Path: /home/db2inst1/sqllib/function/unfenced
Fenced User: db2fenc1
Related Information
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Instance","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.5;9.1;8;7","Edition":"Enterprise Server;Express;Personal;Personal Developer's;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21166020