"db2ilist" and "profiles.reg" Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anurag - 29 Nov 2005 09:18 GMT

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

Reply to this Message

Darin McBride - 29 Nov 2005 20:35 GMT

> 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/".
[quoted text clipped - 5 lines]
> 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.

Reply to this Message