If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 V8.2 (FP8a) on Solaris 8: Shared memory segments cannot be allocated.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-26-05, 11:21
dsusendran dsusendran is offline
Registered User
 
Join Date: Apr 2004
Location: Inside Intel
Posts: 165
Angry DB2 V8.2 (FP8a) on Solaris 8: Shared memory segments cannot be allocated.

Hi all,

DB2 V8.2 Fixpak 8a on Solaris 8
64 bit instance

I recently installed 8.2 Connect Unlimited Edition and applied fixpak 8a. I created a 64 bit instance and two test databases on it. The problem is when i open the control center, it does not allow me to make concurrent connections to both databases. It says :

[IBM][CLI Driver] SQL1084C Shared memory segments cannot be
allocated. SQLSTATE=57019

What i tried:
Increased DBHEAP 4 times than default
Reset the Kernel parameter values in the System file using recommended values from db2osconf

I still get this error. Any pointers?

Thanks in Advance,
Newbie
Reply With Quote
  #2 (permalink)  
Old 10-26-05, 11:58
juliane26 juliane26 is offline
Registered User
 
Join Date: Oct 2005
Posts: 109
first of all: how to create a database with only DB2 Connect installed?

you try to connect to a remote db or you installed something else?
__________________
Juliane
Reply With Quote
  #3 (permalink)  
Old 10-26-05, 12:00
juliane26 juliane26 is offline
Registered User
 
Join Date: Oct 2005
Posts: 109
does the same occur when connecting from a shell?
like having two sessions, one saying
'> db2 connect to dbname1',
the other
'> db2 connect to dbname2'

??
__________________
Juliane
Reply With Quote
  #4 (permalink)  
Old 10-26-05, 12:07
dsusendran dsusendran is offline
Registered User
 
Join Date: Apr 2004
Location: Inside Intel
Posts: 165
Not sure what you meant by
"how to create a database with only DB2 connect installed?"

DB2 Connect is one of the available editions. I am guessing that you got confused with the word Connect...

The Error occurs on the DB2 server as well as when i try to access it remotely through control center (admin client).



'> db2 connect to dbname1'

Connects Successfully. But when i try...

'> db2 connect to dbname2'

SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019

'>connect reset'

No database connection found to reset connection!

Any pointers?

Thanks,
Newbie
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On