Hi all,

Iam using DB2 UDB 8 with fixpack 4 and solaris and when iam trying to connect to database iam getting the following error,

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

The following is the diaglog.log,


2005-01-28-10.04.58.027576 Instance:db2inst Node:000
PID:18332(db2ipccm 0) TID:1 Appid:none
common communication sqlccGetIPCs Probe:50

DIA8336C Requested too many semaphores.
ZRC=0x850F0081ÿ

PID:18332 TID:1 Node:000 Title: IPC Semaphore Set ID
0xFFBFC358 : 0000 0000 0000 0000 0000 0000 FFFF FFFF ................
0xFFBFC368 : FFFF FFFF 0000 0000 0000 0000 ............

2005-01-28-10.06.11.683790 Instance:db2inst Node:000
PID:18332(db2ipccm 0) TID:1 Appid:none
common communication sqlccGetIPCs Probe:50

DIA8336C Requested too many semaphores.
ZRC=0x850F0081ÿ

PID:18332 TID:1 Node:000 Title: IPC Semaphore Set ID
0xFFBFC358 : 0000 0000 0000 0000 0000 0000 FFFF FFFF ................
0xFFBFC368 : FFFF FFFF 0000 0000 0000 0000 ............

Can anyone please help me in this case this is very urgent...will be appreciated,

Thanks in advance..

do you have intra_parallelism set to yes or extshm is set to on?

or this might happen when an application is running Concurrent Transactions ..means application is connecting to multiple databases at a time or trying for different connections to same database.

Thanks chavadb2 , yes its been set to yes...and also if i list applications also its giving the same error......can u please help me in this matter.

Make sure that Solaris kernel parameters are set to the proper values. "Quick Beginnings" lists the procedure. In short, you should run db2osconf and compare its recommendations with the values in /etc/system.

i have run db2osconf utility it gave me 2 updates msginfo_msgmni and shminfo_shmmni .If i change these parameters will help me in resolving the problem....thanks in advance.

Well, given your error message I would also have a serious look at the semaphors-related parameters.

http://www.princeton.edu/~psg/unix/s...tml#semaphores

this is the error iam getting,

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

my diaglog.log shows the following,

2005-01-28-16.16.05.946260 Instance:fttpdevp Node:000
PID:18332(db2ipccm 0) TID:1 Appid:none
common communication sqlccGetIPCs Probe:50

DIA8336C Requested too many semaphores.
ZRC=0x850F0081ÿ

PID:18332 TID:1 Node:000 Title: IPC Semaphore Set ID
0xFFBFC358 : 0000 0000 0000 0000 0000 0000 FFFF FFFF ................
0xFFBFC368 : FFFF FFFF 0000 0000 0000 0000 ............

2005-01-28-16.21.44.609975 Instance:fttpdevp Node:000
PID:18332(db2ipccm 0) TID:1 Appid:none
common communication sqlccGetIPCs Probe:50

DIA8336C Requested too many semaphores.
ZRC=0x850F0081ÿ

PID:18332 TID:1 Node:000 Title: IPC Semaphore Set ID
0xFFBFC358 : 0000 0000 0000 0000 0000 0000 FFFF FFFF ................
0xFFBFC368 : FFFF FFFF 0000 0000 0000 0000 ............

what might be the problem?
thanks in advance

SQL0902C A system error occurred.