By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,083 Members | 2,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,083 IT Pros & Developers. It's quick & easy.

"db2ilist" and "profiles.reg" Question

P: n/a
Hi,
I have 2 related questions.
DB2 UDB ESE v8.x (8.1 till 8.2 FP2 - all fixpaks included) on AIX 5.4.x
__________________________________________________ ___________________________
(QUESTION 1)
Output of "db2ilist" does not list all the instances on my AIX box.
DB2 functions normally - I do not get any unexpected errors.
Any ideas what configuration has been missed out?
__________________________________________________ ___________________________

__________________________________________________ ___________________________
(QUESTION 2)
I have this file "profiles.reg" in "/var/db2/v81/".
"cat" of this file shows me the instances on my AIX box.
I have encountered this situation - I have created 1 server instance
and 1 client instance. "db2ilist" or "cat profiles.reg" does not show
the client instance.
For the sake of keeping things working (which otherwise were working
fine, except for some failover scripts), I just edit "profiles.reg" and
things behave just as expected.
__________________________________________________ ___________________________

So, effectively the questions are -
(1) When does DB2 make an entry of instance name to "profiles.reg";
(2) Does "db2ilist" read directly from "profiles.reg"?;
(3) Of course I want to know what configuration step is being
missed out that db2ilist does not list all my active DB2
instances and "profiles.reg" does not contain entries of all
my DB2 instances.

Regards..........Anurag

Nov 29 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Anurag wrote:
Hi,
I have 2 related questions.
DB2 UDB ESE v8.x (8.1 till 8.2 FP2 - all fixpaks included) on AIX 5.4.x
__________________________________________________ ___________________________ (QUESTION 1)
Output of "db2ilist" does not list all the instances on my AIX box.
DB2 functions normally - I do not get any unexpected errors.
Any ideas what configuration has been missed out?
Somehow, /var/db2/v81/profiles.reg wasn't updated during db2icrt. I've
never seen this fail, so I'm not sure why.
__________________________________________________ ___________________________ (QUESTION 2)
I have this file "profiles.reg" in "/var/db2/v81/".
"cat" of this file shows me the instances on my AIX box.
I have encountered this situation - I have created 1 server instance
and 1 client instance. "db2ilist" or "cat profiles.reg" does not show
the client instance.
For the sake of keeping things working (which otherwise were working
fine, except for some failover scripts), I just edit "profiles.reg" and
things behave just as expected.
That is extremely curious. I actually expect that your server instance was
registered properly during db2start rather than db2icrt. db2start
re-registers an instance just to provide a backup of doing this, but
db2icrt should have already updated the profiles.reg.
__________________________________________________ ___________________________
So, effectively the questions are -
(1) When does DB2 make an entry of instance name to "profiles.reg";
db2icrt, db2start
(2) Does "db2ilist" read directly from "profiles.reg"?;
Indirectly, but yes, durin the db2ilist process, profiles.reg is opened and
read.
(3) Of course I want to know what configuration step is being
missed out that db2ilist does not list all my active DB2
instances and "profiles.reg" does not contain entries of all
my DB2 instances.


It should be done during db2icrt. I'm not sure what is different in your
environment that is preventing this from working.
Nov 29 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.