Prod. database availability on test env.
A user with Informix 7.13 on HP-UX wanted to make a copy of a production database available in a test environment, having only a level 0 archive, and asked whether dbexport/dbimport or something else was best. Replies explained the choice: if test is a separate machine with matching chunk devices/links, copy the ONCONFIG (changing DBSERVERNAME) and sqlhosts and simply restore the level 0 archive — but that only works for a whole, separate instance. To load the database into an existing test instance (or one on the same machine), you must use a migration tool such as dbexport/dbimport (specifying the target dbspace) or onunload/onload. The question was answered.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
We have an informix ver 7.13 production enviornment running on hp-unix 10.01.
I just wanted this production database to be available on our test enviornment.
I have a level 0 backup of our production Database.
can anybody advise me how to proceed and what would be the best way to make
this production Database available on our test enviornment.
dbexport/import or any other utility? and and how?
If your test instance is on a different server, you can just set up the
dbspaces the same as the production instance and use dbimport and dbexport.
Dbexport will copy the entire instance (all databases in the production
instance).
If your test instance is on the same server as production, you may want to try
'onunload' to copy over each database in the production instance that you want
copied over to test.
Larry
> To: ids@iiug.org
> From: djoshih@hotmail.com
> Subject: Prod. database availability on test env. [17324]
> Date: Mon, 5 Oct 2009 09:49:22 -0400
>
> We have an informix ver 7.13 production enviornment running on hp-unix 10.01.
> I just wanted this production database to be available on our test
> enviornment.
>
> I have a level 0 backup of our production Database.
>
> can anybody advise me how to proceed and what would be the best way to make
> this production Database available on our test enviornment.
>
> dbexport/import or any other utility? and and how?
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
If your test environment is on a separate machine and you can recreate the
chunk devices (or at least the links to them that IDS is using as chunk
paths), then you can simply copy over the ONCONFIG file from production,
change the server name, make a local sqlhosts file pointing to the test
server, and restore the archive on the test machine.
If they are sharing a machine, you will have to dbexport from the production
instance and dbimport the data into a test instance on that machine.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Mon, Oct 5, 2009 at 9:49 AM, DEEPAK JOSHI <djoshih@hotmail.com> wrote:
> We have an informix ver 7.13 production enviornment running on hp-unix
> 10.01.
> I just wanted this production database to be available on our test
> enviornment.
>
> I have a level 0 backup of our production Database.
>
> can anybody advise me how to proceed and what would be the best way to make
> this production Database available on our test enviornment.
>
> dbexport/import or any other utility? and and how?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0015173fe52aa24d650475314812
Thx, for the advise. One thing I would like to add.
In our test enviornment, IDS instance is running. In that case do I need to
create all the chunk devices or I will create a dbspace and use dbexport and
dbimport.
please advise me
It is still not clear if your test instance is on a separate server; however,
if it is, the following applies:
All you need to use your level 0 archive is to have the same links for your
dbspaces set up on your test server as you have on your production server.
Then you need to copy over your sqlhosts file as well as your $ONCONFIG file
(which you may need to modify your DBSERVERNAME). The dbimport will create the
dbspaces as they are on the production instance using the identical links to
chunks set up on the test server.
If you do not have identical links set up on your test server, you will have
to use something line dbexport/dbimport or onunload/onload.
With dbexport, you will set up the chunks and dbspaces for the database and
then run dbimport to create the database. There is an option for dbimport
where you can tell it which dbspace to use for creating the database.
Larry
> To: ids@iiug.org
> From: djoshih@hotmail.com
> Subject: Re: Prod. database availability on test env. [17332]
> Date: Mon, 5 Oct 2009 11:34:00 -0400
>
> Thx, for the advise. One thing I would like to add.
>
> In our test enviornment, IDS instance is running. In that case do I need to
> create all the chunk devices or I will create a dbspace and use dbexport and
> dbimport.
>
> please advise me
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
If you want to add the production database to an existing IDS instance on
test, then you have to use some migration tool like dbexport/dbimport. You
can only do an archive and restore if you want to bring this database up in
its own separate instance.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Mon, Oct 5, 2009 at 11:34 AM, DEEPAK JOSHI <djoshih@hotmail.com> wrote:
> Thx, for the advise. One thing I would like to add.
>
> In our test enviornment, IDS instance is running. In that case do I need to
> create all the chunk devices or I will create a dbspace and use dbexport
> and
> dbimport.
>
> please advise me
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001517475f1caf915b047532716d