IBM Support

Fenced User ID access rights for Net Search Extender index files

Question & Answer


Question

The fenced user ID must have at least read access for all Net Search Extender index files.

Answer

If you decide to have a different user ID from the DB2 instance owner to run the stored procedures and UDFs (determined by the ownership of the file ~/sqllib/adm/.fenced), you need to ensure that the fenced user has read access to all files in the index directory. To do this, correctly assign group membership and file permissions.

Note that the entire directory path to the index files must be read accessible to this user.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Extenders - Net Search","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.7;9.5;9.1;10.1;10.5","Edition":"Edition Independent","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEPFH","label":"Db2 Net Search Extender"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 June 2018

UID

swg21142173