Process, thread, or swap space limit was reached.

  • varma
  • Novice
  • Novice
  • varma
  • Posts: 31
  • Loc: India

Post 3+ Months Ago

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
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

Post Information

  • Total Posts in this topic: 1 post
  • Users browsing this forum: No registered users and 39 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.