AW: Re: moved db files to new partition - problems

Hi,

perhaps you should not use a symlink. Use the "old" directory as mountpoi=
nt
and mount the new partion on it. Now there won't be any changes for the
database as it seems to be the same directory.
I did this several times and it worked fine all the time if I needed more=

space.

Regards,

Dirk

>-- Urspr=FCngliche Nachricht --
>Date: Tue, 7 Oct 2003 07:59:04 -0700 (PDT)
>From: Terry <[email protected]>
>To: Dan Behman <[email protected]>
>Cc: [email protected]
>Subject: Re: [suse-ibm-db2] 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 log
>
(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 ip
>s
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 question
>....
> 
> 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.
>og 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                         
>                                                     
>                               
>                       <td3201@yahoo.
>om        To:  
>     [email protected]                           
>                               
>                       >                        cc:  
>                                                     
>                               

>>                                               
> Subject:  [suse-ibm-db2] moved db files to new
> partition - problems                      
>                       10/07/2003 10:27              
>                                                 
>   
>                               
>                       AM                            
>                                                     
>                               
>                                                     
>          
>                                          
>                               
>                                                     
>                                                     
>                               
> 
> 
> 
> Hello,
> 
> 
> am seeing this error in my application:
> SQL1084C  Shared memory segments cannot be
> allocated.
> SQLSTATE=3D57019
> 
> 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]
> 
> 
> 

> 



=3D=3D=3D=3D=3D
Terry

__________________________________
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]




__________________________________________________________________
Turbospeed zum Turbopreis! Surfen Sie doch auch mit der DSL-Flatrate
von Tiscali. Nur 15,90 EUR im Monat.
Basiert auf T-DSL. Weitere Kosten Nicht =FCberall verf=FCgbar. 6 Monate
Mindestvertragslaufzeit.
Und falls Sie wider Erwarten im ersten Monat nicht zufrieden sein sollten=
,
gew=E4hrt Tiscali Ihnen ein sofortiges K=FCndigungsrecht und Sie erhalten=

Ihr Geld zur=FCck.

Klicken Sie hier:
http://registrierung.tiscali.de/produkte/1342_dslflatrate.php?akkcode=3D1=
0253