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 > DB2 > Multiple Instance

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-02-11, 05:25
alwayssathya alwayssathya is offline
Registered User
 
Join Date: Aug 2010
Location: Chennai India
Posts: 161
Question Multiple Instance

Hi ,

I have a RHEL 5.5 32 bit OS and Db2 9.7 ESE installed, i have created one instance ... now i want to create one more instance, this is just for testing purpuse ..

if i try with db2icrt instance_name it throws error
DBI1111E The FencedID parameter must be specified using -u flag with
this command.

Can some one suggest me how do i create one more instance in the same server.
Reply With Quote
  #2 (permalink)  
Old 03-02-11, 05:34
Mathew_paul Mathew_paul is offline
Registered User
 
Join Date: Oct 2007
Posts: 200
give the fenced user id while creating the instance
db2icrt -a server -u Fenceduserid Instance_name

for fenced user id check /etc/passwd search for fence

regds
Paul
Reply With Quote
  #3 (permalink)  
Old 03-03-11, 02:37
alwayssathya alwayssathya is offline
Registered User
 
Join Date: Aug 2010
Location: Chennai India
Posts: 161
Hi i have created the instance successfully, But if i want to use both the instance actively how do i do... and if i create a db in this instance will it be active ??
Reply With Quote
  #4 (permalink)  
Old 03-03-11, 03:02
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
sorry, not clear .. subject to resources, you can have many instances on the same server .. all of them can be active and each of the instances can have their own database and all of them can be active to ..
Quote:
if i want to use both the instance actively
what do you want to do with them?
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #5 (permalink)  
Old 03-03-11, 04:24
alwayssathya alwayssathya is offline
Registered User
 
Join Date: Aug 2010
Location: Chennai India
Posts: 161
your answer made it clear, i have 2 different applications interacting to the 2 database in different instance, ....

Can the DB in instance A interact with DB in instance B.
Reply With Quote
  #6 (permalink)  
Old 03-03-11, 04:29
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
I guess you are after Federation

Sathyaram
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
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