Re: moved db files to new partition - problems

Dan Behman <[email protected]> Tue, 7 Oct 2003 10:47:55 -0400
Newsgroups gmane.linux.suse.db2
Message-ID <[email protected]>



Hi Terry,

A couple of questions....

1)  What version of DB2 are you using?  (what is the output of the
"db2level" command?)
2)  Exactly what were you doing when you saw the SQL1084C?  A db2start?
3)  Please attach the instance's $HOME/sqllib/db2dump/db2diag.log file
4)  What is the distro version that you're using?

One possibility now that I think more about it, is that you didn't clean up
all the IPC resources after moving your db2inst1 directory and before
restarting.  Do an ipcs -a and make sure that all unnecessary resources are
removed and try again.

----------
Dan Behman
DB2 for Linux Platform Development
----------



                                                                                                                                        
                      Terry                                                                                                             
                      <[email protected]        To:       [email protected]                                                          
                      >                        cc:                                                                                      
                                               Subject:  [suse-ibm-db2] moved db files to new partition - problems                      
                      10/07/2003 10:27                                                                                                  
                      AM                                                                                                                
                                                                                                                                        
                                                                                                                                        



Hello,

I am seeing this error in my application:
SQL1084C  Shared memory segments cannot be allocated.
SQLSTATE=57019

Here is what I did to probably cause this:
I shut down db2, moved the db2inst1 directory to a
partition with more space, and created a symlink from
the original location to the new location.

Could this be causing my problems or is it simply
coincidence?  I am on a 2.2.24 kernel.

Thanks!

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

--
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]