Re: ontape restore to new storage problem

david@xxxxxxxxxxxxx wrote:
On 21 Feb, 08:10, ro...@xxxxxxxxxxxxxxx wrote:
Hello , my box ids 7.31 like to switch all dbspace&chunks to a new
storage. Unfortunatelly , all chunks set to direct device name(not
link name). How could I migrate all db to new storage by ontape
safely and quickly?
I would rather not consider dbexport/dbimport or unload/load.
It take too long to finish and unstable .

Do a redirected restore if you version supports it.

IDS 7.31 does not support directed restore.

Upgrade might be an answer, but probably isn't.

The mirroring idea is interesting; the difficulty is switching the names of the primary and mirror chunks once the mirror is created. Running with the primary chunks permanently down is not appealing.

My first choice recommendation would be export/import or load/unload, but that is ruled out by the question. My second choice recommendation is don't build a server so that the chunk names refer to physical devices, but that too is ruled out by the question. Or maybe those two choices would be reversed...


--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@xxxxxxxxxxxxx, jleffler@xxxxxxxxxx
Guardian of DBD::Informix v2007.0914 -- http://dbi.perl.org/

publictimestamp.org/ptb/PTB-2582 ripemd128 2008-02-22 06:00:07
75E279979E93FC9BD13A98A70DE02319

.

Relevant Pages

  • Re: MM Benchmarks oddities
    ... No line split penalties, because I copy 8 byte aligned data chunks from/to 8 ... byte aligned storage and 4 byte data chunks to/from 4 byte aligned storage. ... All the code that copies the result around on the stack is using movsd. ...
    (borland.public.delphi.language.basm)
  • Query: (open source) tool to audit files on multiple fileservers, locate dups (etc)
    ... number of servers in a small workgroup, and to help with migrating / ... -client app runs on <all machines to be audited>, ... put large chunks of duplicate data out of the picture; ... lower-performance storage. ...
    (comp.os.linux.misc)
  • Storage information
    ... in the dump describing what chunks of storage have been ... SUBPOOL 229 KEY 05 SHARED BY TCB 00ADAC48 ...
    (bit.listserv.ibm-main)
  • Re: Moving databases to other Storage
    ... IFF you have use symbolic links for chunk paths then you can shutdown the instance, copy the chunks from the original structures to the new ones using DD or other OS level tools, recreate the chunk links to point to the new locations instead of the original ones, then restart the instance. ... If you are using a version prior to IDS 10.00 and have used physical paths instead of symbolic links for the chunk paths, then Neil's suggestion of using mirrors is the easiest solution. ... I've to move my DBs from the actual Storage to the new Storage. ...
    (comp.databases.informix)
  • Re: ontape restore to new storage problem
    ... all chunks set to direct device name(not ... How could I migrate all db to new storage by ontape ... Create a mirror of the chunk you want to move on the new storage, ...
    (comp.databases.informix)