Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL0902C on db2 connect

361 views
Skip to first unread message

Christian Welzel

unread,
Nov 29, 2009, 11:55:30 AM11/29/09
to
Hi there,

I have a problem with the connect to db2...
Whenever i call "db2 connect to DB" on the system where the db2 runs,
i get the following error:

SQL0902C A system error (reason code = "") occurred. Subsequent SQL
statements cannot be processed.

Connects from other machines, where the db is registered as remote system
work fine. (DB2 9.7 Express-C on Linux/Amd64)

Where can i find informations, what the cause of this issue can be?

--
MfG, Christian Welzel aka Gawain@Regenbogen

GPG-Key: http://www.camlann.de/key.asc
Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15

Sawan

unread,
Nov 29, 2009, 6:55:17 PM11/29/09
to


Hi Christian

Have you checked db2diag.log ?

Regards,
Sawan Gupta

Christian Welzel

unread,
Dec 1, 2009, 12:39:36 PM12/1/09
to
Sawan wrote:

> Have you checked db2diag.log ?

Thanks for that hint!

Now i know this: DIA8336C Requested too many semaphores.
From looking into the google it seems this should cause the seen
behaviour... know i only need to fix the vserver.

Thanks!

jaithilak

unread,
Feb 6, 2014, 7:34:55 PM2/6/14
to
I was unable to connect to the tam db form control center. I Am getting the same error. I have checked the db2diag.log and got the below message.

2013-03-04-05.36.20.591000-300 E34198451H363 LEVEL: Error (OS)
PID : 2416 TID : 2832 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloImpersonateLocalSystem, probe:10
MESSAGE : ZRC=0x83000005=-2097151995
CALLED : OS, -, OpenProcess
OSERR : 5 "Access is denied."

2013-03-04-05.36.20.591000-300 I34198816H282 LEVEL: Severe
PID : 2416 TID : 2832 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, common communication, sqlccGetIPCs, probe:20
RETCODE : ZRC=0x83000005=-2097151995

2013-03-04-05.36.20.606000-300 I34199100H350 LEVEL: Severe
PID : 2416 TID : 2832 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
MESSAGE : User ID
DATA #1 : Hexdump, 4 bytes
0x02B7FAC0 : 0000 0000 ....

2013-03-04-05.36.20.606000-300 I34199452H466 LEVEL: Severe
PID : 2856 TID : 3032 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcCommConnect, probe:10
MESSAGE : ZRC=0x82360001=-2110390271=SQLJC_ERROR_ICE "SYSTEM ERROR"
DIA8532C An internal processing error has occurred.
DATA #1 : String, 11 bytes
CCI Error:
DATA #2 : unsigned integer, 4 bytes
81

What could be the issue? What should I change? Any one pls help on this issue.

Thanks in advance


Iam Ram

unread,
Nov 4, 2014, 6:15:39 AM11/4/14
to
Can you please check file access permissions for db2 related files...
0 new messages