Hi,
An expert opinion is requested on the following:
I am a DBA and new to Sun Solaris. I have installed the DB2 8.1 on a Sun Solaris 9. It is having 512 MB ram. I have created the instance and able to start & stop the instance.
When I am trying to create a database, it is giving the following error:
------
SQL1225N The request failed because an operating system process, thread, or swap space limit was reached. SQLSTATE=57049
------
I give below the information got from the db2diag.log file
=============================
2005-06-15-07.30.33.622426 Instance:db2inst1 Node:000
PID:654(db2ipccm 0) TID:1 Appid:none
oper system services sqloInitializeWaitlist Probe:10
SysV semget failed with errno:
0xFFBFB9E0 : 0x0000001C ....
2005-06-15-07.30.33.627520 Instance:db2inst1 Node:000
PID:654(db2ipccm 0) TID:1 Appid:none
oper system services sqloFreeShrEDUWaitElem Probe:12
sqloInitializeWaitlist failed, zrc=
0xFFBFBA5C : 0x850F0081 ....
2005-06-15-07.30.33.632854 Instance:db2inst1 Node:000
PID:654(db2ipccm 0) TID:1 Appid:none
oper system services sqloCreateEDU Probe:3
DiagData
0x0193E094 : 7371 6C6F 4765 7453 6872 4544 5557 6169 sqloGetShrEDUWai
0x0193E0A4 : 7445 6C65 6D20 6661 696C 6564 tElem failed
2005-06-15-07.30.33.637903 Instance:db2inst1 Node:000
PID:654(db2ipccm 0) TID:1 Appid:none
base sys utilities sqle_create_agent Probe:25
DIA8336C Requested too many semaphores.
ZRC=0x850F0081
2005-06-15-07.30.33.640558 Instance:db2inst1 Node:000
PID:654(db2ipccm 0) TID:1 Appid:none
base sys utilities sqleGetAgentFromPool Probe:30
DiagData
0xFFBFBD98 : 0xFFFFFB37 ...7
2005-06-15-07.30.33.645362 Instance:db2inst1 Node:000
PID:654(db2ipccm 0) TID:1 Appid:none
base sys utilities sqleGetAgent Probe:70
Agent not allocated, sqlcode = -1225
=============================
Can any one guide me step by step process to overcome this.
Thanks
Varma