[Info-ingres] [Info-Ingres] relocating a work location

[Ingres Forums]

=?iso-8859-1?Q?Laframboise=2C_Andr=E9?=;25979 Wrote: 
> I did something similar last week but for a new journal location
> (ii_journal_2).
> 
> I did the same steps as you except for the extenddb part. (defined in
> accessdb/locations, then relocatedb -new_journal_location).
> 
> Looks like extenddb just 'added' your new work location to the existing
> one.
> 
> ________________________________
> 
> From: info-ingres-bounces at kettleriverconsulting.com
> [mailto:info-ingres-bounces at kettleriverconsulting.com] On Behalf Of
> Martin Bowes
> Sent: May 27, 2009 10:36 AM
> To: info-ingres at kettleriverconsulting.com
> Subject: [Info-Ingres] relocating a work location
> 
> 
> 
> Hi All,
> 
> 
> 
> I've defined an alternate work location (ii_work_2).
> 
> 
> 
> I'd like to alter a database to use just that work location and not the
> standard under II_WORK.
> 
> 
> 
> So having defined the work location to the installation, I thought a
> simple relocatedb would work...
> 
> relocatedb bowtest -new_work_location=ii_work_2
> 
> Wed May 27 15:26:27 2009 E_DM1503_RELOC_NEWLOC_NOTFOUND New location not
> found.
> 
> Wed May 27 15:26:27 2009 E_DM1507_RELOC_ERR     Error occurred while
> processing the WORK relocation request.
> 
> 
> 
> >From RTFM, I found that I have to first use extenddb to make this a
> known work location for the database and then I can relocate to
> it...which is unlike moving the checkpoint, dump or journal.
> 
> So...
> 
> extenddb bowtest -Uwork -lii_work_2
> 
> relocatedb bowtest -new_work_location=ii_work_2
> 
> 
> 
> Which works without error, but when I check with infodb the database has
> both work locations defined.
> 
> 
> 
> Am I doing something wrong, or have I misinterpretted what relocatedb
> -new_work_location does?
> 
> 
> 
> Ingres Version is: II 9.0.4 (a64.lnx/105)NPTL + p12707
> 
> 
> 
> Martin Bowes
Please reply, me too facing the same issue.. my partiction is full i
dont want to extend but have to relocate complete data folder to other
partition.


-- 
anvijrocks
------------------------------------------------------------------------
anvijrocks's Profile: http://community.actian.com/forum/member.php?userid=121881
View this thread: http://community.actian.com/forum/showthread.php?t=10701