Troubleshooting
Problem
SQL0970N and "ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"" error in db2diag.log, when attempting to connect to DB2 database on Linux
Symptom
When attempting to connect to a DB2 database on LINUX ONLY, a SQL0970N error will be returned at the connection prompt and the following error will appear in the db2diag.log
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1130
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code was "".
Cause
Linxu anit-virus was running against DB2
Environment
This technote applies to LINUX ONLY
Diagnosing The Problem
Verify if any anti-virus software is running.
Resolving The Problem
The command /etc/init.d/nails stop will turn off McAfee LinuxShield, then restart DB2 instance.
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Database","Platform":[{"code":"PF016","label":"Linux"}],"Version":"9.8;9.7;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21968636