Moving checkpoint location

>Jim Atherton  writes:

>
>Running Ingres 6.4/04 (on a Sequent Unix box) is it posible to simply
>change the checkpoint location without having to go to the trouble of:
>
>1) unloading the database
>2) destroying the database
>3) (re)creating the database (with different checkpoint location)
>4) reloading the database
>
>For a large database this is somewhat time-consuming, to 
>put it mildly!
>
>There seems no flexibility with this whereas with the actual data 
>more than one location can be employed with the prospects of moving 
>data "on the fly" using modify xxxxxx to reorganize/relocate, etc.
>
>Any ideas anyone.
>

Jim,

  There is no supported way to do this, other than the method you mentioned.
Of course, you could upgrade to OpenIngres, which has the "relocatedb" 
command.

Cheers,

|--------------------------------------------------------------------------|
| Michael Leo            | The Ingres FAQ is at ftp.adc.com, /pub/ingres.  |
| York & Associates, Inc.| Also check out /pub/ingres/utilities/NAIUA for  |
| Minneapolis, MN, USA   | the NAIUA Tool Kit.  Lastly, access all this via|
| (612) 921-8083 (voice) | WWW at http://www.adc.com/ingres/ing-top.html.  |
| mal@winternet.com      | All constructive suggestions/criticism welcome. |
|--------------------------------------------------------------------------|
Ingres Q & A
To William's Home Page
Email William