Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


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 > db2ilist

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-07-04, 11:11
Koz Koz is offline
Registered User
  
Join Date: May 2002
Posts: 43
Question db2ilist
Does anyone know where db2ilist stores the list of Instances? I am trying to figure out if when I run the db2istrt command from rc.db2 if it pulls the information from a system directory (/var or /usr) or from an application database directory.......

This is in prep for running HACMP on our UDB server.....

Koz
Reply With Quote
  #2 (permalink)  
Old 04-07-04, 12:56
sathyaram_s sathyaram_s is offline
Super Moderator
  
Join Date: Aug 2001
Location: UK
Posts: 4,534
Re: db2ilist
On a V7 system,
/var/db2/v71/profiles.reg

Cheers
Sathyaram


Quote:
Originally posted by Koz
Does anyone know where db2ilist stores the list of Instances? I am trying to figure out if when I run the db2istrt command from rc.db2 if it pulls the information from a system directory (/var or /usr) or from an application database directory.......

This is in prep for running HACMP on our UDB server.....

Koz
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #3 (permalink)  
Old 07-30-10, 16:47
sdsu sdsu is offline
Registered User
  
Join Date: Dec 2009
Posts: 22
Can we edit this file....It says readonly.

The problem for me when i run the db2ilist it is pointing to a instance which is either deleted or not doesnot exist.

there is an instance db2inst1 ....but how can i make this to point to that instance ??
Reply With Quote
  #4 (permalink)  
Old 08-03-10, 16:16
MarkhamDBA MarkhamDBA is offline
Registered User
  
Join Date: Dec 2008
Location: Toronto, Canada
Posts: 381
Quote:
Originally Posted by sdsu View Post
Can we edit this file....It says readonly.

The problem for me when i run the db2ilist it is pointing to a instance which is either deleted or not doesnot exist.

there is an instance db2inst1 ....but how can i make this to point to that instance ??
export DB2INSTANCE=instance_name

and then run db2profile for this instance:
. ~db2v8i1/sqllib/db2profile
__________________
DB2 v9.5 ESE on AIX v6.1/ v9./10 on z/OS
Reply With Quote
  #5 (permalink)  
Old 08-07-10, 00:06
db2girl db2girl is offline
∞∞∞∞∞∞
  
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Quote:
Originally Posted by sdsu View Post
Can we edit this file....It says readonly.

The problem for me when i run the db2ilist it is pointing to a instance which is either deleted or not doesnot exist.

there is an instance db2inst1 ....but how can i make this to point to that instance ??

Check the content of profile.reg under db2 installation dir. This file contains a list of instance for the <installation dir>. For example:

<-instv9-> db2ilist
instv9

<-instv9-> more /opt/ibm/db2/V9.1/profiles.reg
instv9



What you can try to do is to stop the instance, rename this file and then restart the instance. DB2 should recreate this file.


I believe this file no longer exists starting with v9.7
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.