Re:
In article <908302376.13262@wren.supernews.com>, Subhash
<address@in.sig> writes
>What next Wonder Boy, I may even start up a company
>
>On Tue, 13 Oct 1998 14:42:25 +0100, "Neil Truby" <ntruby@netcomuk.co.uk> wrote:
>>Is this your day job or night job?
>>
>>Subhash wrote in message <908218199.23526@wren.supernews.com>...
>>>I am using Informix Universal Server 9.14UC2 on Solaris 2.5.1. I have a
>>database
>>>which has tables spread across 9 dbspaces and two of them are smart blob
>>>spaces.
>>>
>>>What I would like to do is to unload each dbspace, copy the file to another
>>>instance of online to restore into a dbspace which is setup with the same
>>name
>>> and size.
>>>
>>>I cannot use ontape to restore the database because the chunk names are not
>>the
>>>same and there is alreay a another instance of Online setup which has the
>>same
>>>chunk names. Also I tried to dbexport the database but some the tables have
>>>corrupt data and the export crashes about half way through.
If you have corruption then try oncheck -- and run all the -c options
oncheck -cr (or is it oncheck -cR under 9.14??)
oncheck -ce
oncheck -cc <database>
oncheck -CI <database>
oncheck -CD <database>
Nothing will work until you fix the corruption.
You could use dbaccess to unload each table seperately:-
unload to "myfile" select * from mytable;
Then transfer myfile to the new machine and in dbaccess do
load from "myfile" insert into mytable;
>>>
>>>Does anyone know which informix utility I can utilise to do this ?
>>>
>>>thanks in advance for any help.
>>>
>>>
>>>Subhash Rehan
>>>
>>>srehan@bigfoot.com
>>>
>>>
>>>
>>>
>>> -**** Posted from Supernews, Discussions Start Here(tm) ****-
>>>http://www.supernews.com/ - Host to the World's Discussions & Usenet
>>
>>
>
>
>
> -**** Posted from Supernews, Discussions Start Here(tm) ****-
>http://www.supernews.com/ - Host to the World's Discussions & Usenet
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care