OSERR : 5 "Access is denied."
in [DB2]
|
From: Odd B Andersen on 1 Apr 2008 05:38 I get this message in the db2diag.log. 2008-04-01-10.41.37.174000+120 E13321H539 LEVEL: Error (OS) PID : 3528 TID : 144 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : XDKD01 APPHDL : 0-3541 APPID: 139.108.97.170.43026.0804010841 EDUID : 144 EDUNAME: db2agent (XDKD01) 0 FUNCTION: DB2 UDB, oper system services, sqloAuthzGetInformationFromSid, probe:10 MESSAGE : ZRC=0x83000005=-2097151995 CALLED : OS, -, AuthzInitializeContextFromSid OSERR : 5 "Access is denied." The message seems to occur every hour or so (hh.41.ss) with some stray occurences from time to time (2 stray occurences up until now today). Seems to me that this is a security/authentication issue, but I have not been able to pinpoint exactly what is happening and causing the error message. Does anyone have a clue as to what this is, or a suggestion to how I can take a snapshot or monitor the database in the hope to catch the events that is the explanation for this? DB2 ESE 9.5 Windows Server 2003 Enterprise Edition (SP2). -- Regards Odd Bj�rn Andersen ErgoGroup AS Postboks 4364 Nydalen, N-0402 Oslo, Norway Telefon +4723 14 50 00, Telefaks +4723 14 50 01 Mobilnr +47970 84597 www.ergogroup.no
From: The Boss on 1 Apr 2008 18:52 Odd B Andersen wrote: > I get this message in the db2diag.log. > > 2008-04-01-10.41.37.174000+120 E13321H539 LEVEL: Error (OS) > PID : 3528 TID : 144 PROC : db2syscs.exe > INSTANCE: DB2 NODE : 000 DB : XDKD01 > APPHDL : 0-3541 APPID: 139.108.97.170.43026.0804010841 > EDUID : 144 EDUNAME: db2agent (XDKD01) 0 > FUNCTION: DB2 UDB, oper system services, > sqloAuthzGetInformationFromSid, probe:10 > MESSAGE : ZRC=0x83000005=-2097151995 > CALLED : OS, -, AuthzInitializeContextFromSid > OSERR : 5 "Access is denied." > > The message seems to occur every hour or so (hh.41.ss) with some stray > occurences from time to time (2 stray occurences up until now today). > Seems to me that this is a security/authentication issue, but I have > not been able to pinpoint exactly what is happening and causing the > error message. > Does anyone have a clue as to what this is, or a suggestion to how I > can take a snapshot or monitor the database in the hope to catch the > events that is the explanation for this? > > DB2 ESE 9.5 > Windows Server 2003 Enterprise Edition (SP2). It is an Operating System (authentication) error, in your case in Windows in function "AuthzInitializeContextFromSid". http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.pd.doc/pd/c0020819.htm I have no/very limited experience with DB2 on Windows, but I would suggest first to have a look at Windows' Event Viewer for any additional clues (both in the System Event Log and in the Security Event Log). And you might google searching for "AuthzInitializeContextFromSid"+"access denied", which will give you quite a number of hits from Microsoft and related forums. Obviously, I didn't research all of them, but I came accross this one giving some explanation on the function: http://msdn2.microsoft.com/en-us/library/aa376309(VS.85).aspx HTH. -- Jeroen
|
Pages: 1 Prev: Get current SQL for a job Next: heavy inserts and bufferpool |