Why IIS worker process w3wp.exe is experiencing "Access is denied." in DB2 ?
Biswarup(Bis)Mukherjee 120000HKTY Visits (12450)
One example of the access denied issue from w3wp.exe could be experienced with following db2diag.log messages,
The most common reason of similar problem is incorrect setting of the user accessing the database.
DB2 is trying to perform a lower level windows operation using underlying filesystem and experiencing an access denied situation.
Sometimes reinstalling db2 and/or complaining product might resolve the issue as the install steps might guide to use correct settings.
This can happen if the user using w3wp.exe is not part of groups DB2USERS or DB2ADMNS
To determine which user runs w3wp.exe open Task Manager and look at the process details.
If the extended security DB2_EXTSECURITY is set (default setting is YES)
One group at a time could be included and tested to perform minimal required changes.
Appropriate actions should be taken if the issue is still not fixed after adding to the groups.