Are there any potential problems running onunload to move a complete
database from one instance to another on identical hardware.
I have already seen that new datatypes for version 9 are not
transferred. Anything else?

Any help much appreciated.

Malcolm

"malcolm" <malcolm.weallans@btopenworld.com> wrote in message
news:3efc1745.0404050735.46e12b80@posting.google.c om...
> Are there any potential problems running onunload to move a complete
> database from one instance to another on identical hardware.
> I have already seen that new datatypes for version 9 are not
> transferred. Anything else?
>
> Any help much appreciated.
>
> Malcolm

Which release of IDS?
Most demand that you have identical dbspace names available on the target
instance as the source. The dbspace override flag is only effective for
data.

In message <3efc1745.0404050735.46e12b80@posting.google.com >, malcolm
<malcolm.weallans@btopenworld.com> writes
>Are there any potential problems running onunload to move a complete
>database from one instance to another on identical hardware.
>I have already seen that new datatypes for version 9 are not
>transferred. Anything else?

And indexes either detached, or in a dbspace other than that the
database was created in, need assigning a new dbspace with the '-fi'
load option. There is now an SQL at oninit.com to find them....

Also I think you would have problems if the versions of IDS were
different as onunload output data pages.


>
>Any help much appreciated.

A better idea I now think is to use dbexport...... :-(


>
>Malcolm

--
Five Cats
Email to: cats_spam at uk2 dot net

In message <c4s111$2m6qdh$1@ID-162943.news.uni-berlin.de>, Neil Truby
<neil.truby@ardenta.com> writes
>"malcolm" <malcolm.weallans@btopenworld.com> wrote in message
>news:3efc1745.0404050735.46e12b80@posting.google. com...
>> Are there any potential problems running onunload to move a complete
>> database from one instance to another on identical hardware.
>> I have already seen that new datatypes for version 9 are not
>> transferred. Anything else?
>>
>> Any help much appreciated.
>>
>> Malcolm
>
>Which release of IDS?
>Most demand that you have identical dbspace names available on the target
>instance as the source. The dbspace override flag is only effective for
>data.

As I have been finding recently, you have to use the '-fi' flags to deal
with indexes elsewhere. The customer is reloading tomorrow so watch
this space, but we found 167 indexes (or so) not in the database dbspace
so there are a lot of lines starting '-fi' in the script they are going
to run....
>
>

--
Five Cats
Email to: cats_spam at uk2 dot net

In message <3efc1745.0404050735.46e12b80@posting.google.com >, malcolm
<malcolm.weallans@btopenworld.com> writes
>Are there any potential problems running onunload to move a complete
>database from one instance to another on identical hardware.
>I have already seen that new datatypes for version 9 are not
>transferred. Anything else?

Have now found that there is some kind of bug preventing my customer
using onload even with a pile of '-fi' flags. The chaps at support have
managed to reproduce the problem but a fix will be far off I suspect....
:-(

(back to dbexport....)

>
>Any help much appreciated.
>
>Malcolm

--
Five Cats
Email to: cats_spam at uk2 dot net