Re: moved db files to new partition - problems

Thanks for your response:

1) DB21085I  Instance "db2inst1" uses DB2 code release
"SQL06010" with level
identifier "01080104" and informational tokens "DB2
v6.1.0.40", "s010216" and
"IP22244".

2) I am seeing the SQL1084C error in my apache logs
(from java).  They occur intermittently and I have no
clue what specifically generates the error.

3) Gzipped file attached (38M uncompressed)

4) Redhat 7.0 2.2.24 kernel (sorry, not my choice)

What other steps should be involved with the ipcs
command?   The database has been up and running in its
broken state since 9/26 so there are a lot of db2
resources laying around.  

Thanks!


--- Dan Behman <[email protected]> wrote:
> 
> 
> 
> 
> 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]
> 
> 
> 
> 



=====
Terry

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