Re: Unloading a live database
En Alanoly Andrews va escriure el dia 4 Aug 99, a les 9:23:
Option 1:
from dbaccess do:
unload to "file" select * from <table name> --> this ininstance 1
load from "file" insert into <table_name> --> this in instance2
Option 2:
from dbaccess in instance 1 do:
insert into databasename@informixservername:table select *
from <table name>
Suggestion:
Put the database in the second instace WITH NO LOG.
To do that use ontape.
Be fun.
>
> Hi,
>
> I need to unload a "database" while the instance is running
> and accepting updates on the database. I see that the "onunload"
> utility of Informix takes a lock on the database and does not allow
> users to modify the Database during the unload process.
> The unloaded database is to be loaded into another instance
> which need not have the same DBspace configurations as the
> first instance. This seems to rule out the use of archiving utilities like
> "ontape" which require identical DBspace configurations for a restore.
>
> I'd appreciate your input into solving this problem.
>
> Thanks.
>
> Alanoly J. Andrews
>
---------------------------------------
Isidre PONS ROCA
BASE - Gesti' d'Ingressos Locals
(Diputacio de Tarragona)
Servei de Sistemes de Informacio
Av President Lluis Companys 12-C
43005 - Tarragona
SPAIN
Tel # +34 977 236731
Fax # +34 977 227302
http://www.altanet.org
ipons@dtgna.altanet.org
---------------------------------------