onload
IDS 11.50.FC5
Solaris 10
I sent this in a couple of days ago, but I never saw it posted.
---
I created an onunload copy of a database on a server. The original database is
housed in two difference dbspaces, a 2k and an 8k for smaller and larger table
respectively.
Questions
Does the unload contain any dbspace information? How does it know to send the
tables to the different dbspaces?
If I specify a dbspace with -d that is 2k pages, it appears to want to put
everything there.
If I specify the dbspace that is 8k pages, I receive an error message after a
while that says either my unload is corrupt or I have set the wrong page size.
If I do not specify a dbspace, it appears to fill up the rootdbs.
I have used this same unload previously and it appeared to load correctly. I
am not sure what I need to do.
Larry
Larry:
The post went out. I didn't respond because I don't use onunload/onload.
Don't know why others didn't.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. 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 Wed, Feb 15, 2017 at 8:30 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> IDS 11.50.FC5
>
> Solaris 10
>
> I sent this in a couple of days ago, but I never saw it posted.
>
> ---
>
> I created an onunload copy of a database on a server. The original
> database is
> housed in two difference dbspaces, a 2k and an 8k for smaller and larger
> table
> respectively.
>
> Questions
>
> Does the unload contain any dbspace information? How does it know to send
> the
> tables to the different dbspaces?
>
> If I specify a dbspace with -d that is 2k pages, it appears to want to put
> everything there.
>
> If I specify the dbspace that is 8k pages, I receive an error message
> after a
> while that says either my unload is corrupt or I have set the wrong page
> size.
>
> If I do not specify a dbspace, it appears to fill up the rootdbs.
>
> I have used this same unload previously and it appeared to load correctly.
> I
> am not sure what I need to do.
>
> Larry
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--94eb2c1b6e0605f5f405489c9496