If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > copying dbspaces between instances

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-23-08, 08:57
joachimv joachimv is offline
Registered User
 
Join Date: Sep 2008
Posts: 1
copying dbspaces between instances

hello,

recently i was testing the creation of multiple instances (of which i can't realy find much more than a few lines of information under "multiple residency" in the IBM info).
I created a new instance, created the dbspaces like they are in the original instance on the same system and then i did an export from the original instance with option -ss and imported the db's into the new instance.

I was wondering if you do an ontape -s -L 0 on the first instance and instead of creating the new instance with it's dbspaces, you just create the new instance and do a "touch 'dbspacesnames'" (on linux/unix) and then an ontape -r into the new instance, would that make the dbspaces of the two instances interfere?
I mean, if you create dbspaces with onspaces, i suppose they are taking their own independent space in the system. But if you just create your instance (and automatically your rootdbspace) without creating the other dbspaces, just making sure the cooked files exist on system level and then restoring the original dbspaces and renaming them (with ontape -r restore -f filenamewithrestoreinfo) would make them independent too?

another question is what to do with the SHMBASE address for instances on the same system. Do they all have to get the same system specific SHMBASE-address or do they need a different SHMBASE address something like (instance 1 : SHMBASE1, instance 2 : SHMBASE1 +- SHMTOTAL2 , etc)

thanks in advance and sorry if my english isn't super

J

Last edited by joachimv; 12-23-08 at 09:01.
Reply With Quote
  #2 (permalink)  
Old 12-24-08, 17:31
ibm.ids ibm.ids is offline
Registered User
 
Join Date: Nov 2008
Posts: 64
Searching for multiple residency in IDS documentation set returns for me:
Documents found:
6
Total instances found:
91

So, there are 6 different peaces of documentation, with total 91 appearances of "multiple residency".

You can play with renaming chunks during restore, but I do not think you'll achieve what you want. (I do not understand your middle paragraph)

When you are using multiple residency, you must have unique onconfig parameters: ROOTPATH, SERVERNUM, SERVERNAME (also ALIASES).
There are some other parameters that you want to have them unique (MSGPATH, ...)
SHMBASE parameter is not supposed t obe unique - based on SERVERNUM and SHMBASE, IDS calculates shared memory ids (shmid) for each instance.

HTH
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On