473,416 Members | 1,784 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,416 software developers and data experts.

"db2ilist" and "profiles.reg" Question

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
1 4910
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Mohammed Mazid | last post by:
Can anyone please help me on how to move to the next and previous question? Here is a snippet of my code: Private Sub cmdNext_Click() End Sub Private Sub cmdPrevious_Click() showrecord
4
by: Mohammed Mazid | last post by:
Can anyone please help me on how to move to the next and previous question? Here is a snippet of my code: Private Sub cmdNext_Click() End Sub Private Sub cmdPrevious_Click() showrecord
0
by: John Wilson | last post by:
Hello, I have the following code which populates as table data from a SQL Server 2000 stored proc (RSByDemoID2). Below that is the view and stored procedure which takes @DemoID as input to match...
65
by: perseus | last post by:
I think that everyone who told me that my question is irrelevant, in particular Mr. David White, is being absolutely ridiculous. Obviously, most of you up here behave like the owners of the C++...
3
by: Stevey | last post by:
I have the following XML file... <?xml version="1.0"?> <animals> <animal> <name>Tiger</name> <questions> <question index="0">true</question> <question index="1">true</question> </questions>
9
by: Dave H | last post by:
Hello, I have a query regarding definition lists. Is it good practice semantically to use the dt and dd elements to mark up questions and answers in a frequently asked questions list, or FAQ? ...
7
by: nospam | last post by:
Ok, 3rd or is it the 4th time I have asked this question on Partial Types, so, since it seems to me that Partial Types is still in the design or development stages at Microsoft, I am going to ask...
3
by: Ekqvist Marko | last post by:
Hi, I have one Access database table including questions and answers. Now I need to give answer id automatically to questionID column. But I don't know how it is best (fastest) to do? table...
56
by: spibou | last post by:
In the statement "a *= expression" is expression assumed to be parenthesized ? For example if I write "a *= b+c" is this the same as "a = a * (b+c)" or "a = a * b+c" ?
6
semanticnotion
by: semanticnotion | last post by:
Hi sir i want to transform the data of one table into another through foreign key but the following error come to my browser Here is my code and data base structure. CREATE TABLE IF NOT...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.