Oninit cdi / Archive
Talk to an expert →

onload and onunload default properties for load

Posted in 2017

Topics: Storage & Space Management, Migration, Import/Export & Data Conversion, Platform-Specific Issues

LARRY SORENSEN — — source: IIUG Forums & Mailing Lists

Solaris 10 SPARC IDS 11.50.FC5 I have 2 databases in an instance that I need to copy occasionally. 1 database is all in the same dbspace, so I use the -d option and name that dbspace during the "onload". The other database is half in one dbspace and half in another dbspace with a larger pagesize. I would like the "onload" to load the data into the proper dbspaces. My question is what is the default action of "onload". Is there information in the "onunload" that will tell the "onload" where it should put the tables? I don't want to specify a dbspace with the "-d" option if all the tables will go into it to the exclusion of the other dbspace. Ideas? Thank you. Larry

↪ replying to LARRY SORENSEN
Kern Doe — — source: IIUG Forums & Mailing Lists

Larry,My experience with onunload and onload a while back ago with version 10 on AIX that if your database's tables reside in different dbspaces with different pagesizes, onunload "appears" to work, meaning it will finish without an error, but it will fail when you do theonload. I guess the reason being that onload will reload everything in one given dbspace (there are exceptions which I'm not going to it since it's not related to your question) -- so of course there'll be a mismatched dbspace pagesize situation. I do not know if this is still true with IDS 11.50 and I don't have time to test it out yet.Kern -- Let's go GreenThis email contains 100% recycled electrons. From: LARRY SORENSEN <LSORENSEN25@msn.com> To: ids@iiug.org Sent: Wednesday, May 17, 2017 12:13 PM Subject: onload and onunload default properties for load [39223] Solaris 10 SPARC IDS 11.50.FC5 I have 2 databases in an instance that I need to copy occasionally. 1 database is all in the same dbspace, so I use the -d option and name that dbspace during the "onload". The other database is half in one dbspace and half in another dbspace with a larger pagesize. I would like the "onload" to load the data into the proper dbspaces. My question is what is the default action of "onload". Is there information in the "onunload" that will tell the "onload" where it should put the tables? I don't want to specify a dbspace with the "-d" option if all the tables will go into it to the exclusion of the other dbspace. Ideas? Thank you. Larry ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary