Installing/configuring DB2 Connect V8.1

[Ed Stevens]

A tale of woe, and a question . . .

Last week my boss said to me "we've installed DB2 Connect on this
Solaris box. Make it work."

Now, I've barely seen DB2 Connect on Windows, having fumbled thru one
install and config, with a lot of handholding from IBM Support. I'm
comfortable in unix but have never dealt with DB2 Connect there. (my
main job is as an Oracle DBA, and most of my db's are on Solaris or
AIX) I've found the install docs to be pretty much worthless, and the
other on-line docs worse.

I went in thinking the product was functioning and all I needed to do
was catalog some nodes and remote databases, but immediately
discovered that the only thing done was that an SA had installed the
product. There was no relevent environment setup.

Digging thru another box that had v7 running on it, I finally traced
the settings back to a file called 'db2profile', to be sourced from
the user's .profile. (Where was THAT documented?). From there I
discovered that everything seemed to key off the setting of INSTHOME.
Only db2profile was read only (default from the installation) and
needed to be 'fixed' with this setting. Worked with the SA to get the
permissions to edit the file, and changed

INSTHOME=instan cehomedir

to

INSTHOME=/opt/IBM/DB2/v8.1

but then everything that key off of this, like additions to PATH,
appended '/sqllib' to it, and there is not directory
/opt/IBM/DB2/v8.1/sqllib. Going back to the working v7 installation,
I see that they have

INSTHOME=/local/home/db2inst1

which does have a directory 'sqllib', which contains mostly symlinks
back to /opt/IBMDB2/V7.1.

Now, I could figure out how to replicate all of that an make it work,
but I'm concerned that I'd be reinventing a wheel. I'd much rather do
it 'by the book' if I could only *FIND* the book! Can someone point
me to an on-line source or the proper html help file in the install
directory to explain how to REALLY set this up? Something that
explains required or assumed directories, environment setup, proper
config of them, etc., etc..

TIA.

[Jan M. Nelken]

Ed Stevens wrote:

A tale of woe, and a question . . .

Last week my boss said to me "we've installed DB2 Connect on this
Solaris box. Make it work."

Now, I've barely seen DB2 Connect on Windows, having fumbled thru one
install and config, with a lot of handholding from IBM Support. I'm
comfortable in unix but have never dealt with DB2 Connect there. (my
main job is as an Oracle DBA, and most of my db's are on Solaris or
AIX) I've found the install docs to be pretty much worthless, and the
other on-line docs worse.

I went in thinking the product was functioning and all I needed to do
was catalog some nodes and remote databases, but immediately
discovered that the only thing done was that an SA had installed the
product. There was no relevent environment setup.

Digging thru another box that had v7 running on it, I finally traced
the settings back to a file called 'db2profile', to be sourced from
the user's .profile. (Where was THAT documented?). From there I
discovered that everything seemed to key off the setting of INSTHOME.
Only db2profile was read only (default from the installation) and
needed to be 'fixed' with this setting. Worked with the SA to get the
permissions to edit the file, and changed

INSTHOME=instan cehomedir

to

INSTHOME=/opt/IBM/DB2/v8.1

but then everything that key off of this, like additions to PATH,
appended '/sqllib' to it, and there is not directory
/opt/IBM/DB2/v8.1/sqllib. Going back to the working v7 installation,
I see that they have

INSTHOME=/local/home/db2inst1

which does have a directory 'sqllib', which contains mostly symlinks
back to /opt/IBMDB2/V7.1.

Now, I could figure out how to replicate all of that an make it work,
but I'm concerned that I'd be reinventing a wheel. I'd much rather do
it 'by the book' if I could only *FIND* the book! Can someone point
me to an on-line source or the proper html help file in the install
directory to explain how to REALLY set this up? Something that
explains required or assumed directories, environment setup, proper
config of them, etc., etc..

TIA.

Definitely more reasonable approach would be to use product installation manuals
readily available on Internet:

Current version of DB2 UDB (and Connect) is V8.2 - whoich you can obtain by
installing V8.1 GA at least and applying FP7a.

Release Notes for V8.2:

ftp://ftp.software.ibm.com/ps/produc...S/db2ire88.pdf
Installation:

ftp://ftp.software.ibm.com/ps/produc...S/db2c6e81.pdf
ftp://ftp.software.ibm.com/ps/produc...S/db2h1e81.pdf
User Guide:

ftp://ftp.software.ibm.com/ps/produc...S/db2c0e81.pdf
Now - did you *tried* to find manuals at all?

Jan M. Nelken

[Mark A]

"Ed Stevens" <no****@noway.n ohow> wrote in message
news:nh******** *************** *********@4ax.c om...

A tale of woe, and a question . . .

Last week my boss said to me "we've installed DB2 Connect on this
Solaris box. Make it work."

Now, I've barely seen DB2 Connect on Windows, having fumbled thru one
install and config, with a lot of handholding from IBM Support. I'm
comfortable in unix but have never dealt with DB2 Connect there. (my
main job is as an Oracle DBA, and most of my db's are on Solaris or
AIX) I've found the install docs to be pretty much worthless, and the
other on-line docs worse.

I went in thinking the product was functioning and all I needed to do
was catalog some nodes and remote databases, but immediately
discovered that the only thing done was that an SA had installed the
product. There was no relevent environment setup.

Digging thru another box that had v7 running on it, I finally traced
the settings back to a file called 'db2profile', to be sourced from
the user's .profile. (Where was THAT documented?). From there I
discovered that everything seemed to key off the setting of INSTHOME.
Only db2profile was read only (default from the installation) and
needed to be 'fixed' with this setting. Worked with the SA to get the
permissions to edit the file, and changed

INSTHOME=instan cehomedir

to

INSTHOME=/opt/IBM/DB2/v8.1

but then everything that key off of this, like additions to PATH,
appended '/sqllib' to it, and there is not directory
/opt/IBM/DB2/v8.1/sqllib. Going back to the working v7 installation,
I see that they have

INSTHOME=/local/home/db2inst1

which does have a directory 'sqllib', which contains mostly symlinks
back to /opt/IBMDB2/V7.1.

Now, I could figure out how to replicate all of that an make it work,
but I'm concerned that I'd be reinventing a wheel. I'd much rather do
it 'by the book' if I could only *FIND* the book! Can someone point
me to an on-line source or the proper html help file in the install
directory to explain how to REALLY set this up? Something that
explains required or assumed directories, environment setup, proper
config of them, etc., etc..

TIA.

I don't know about DB2 Connect, but with DB2 Server the db2profile
automatically gets set up for the instance owner during the install. This
assumes that you follow all the installation instructions (which your SA
probably did not do).

I would go back to the installation instructions and see if the SA followed
all the steps. I don't know the exact name of the file with the installation
instructions, but it is probably on the root path of the product disk.

[Ed Stevens]

On Sat, 27 Nov 2004 13:44:31 -0700, "Mark A" <no****@nowhere .com>
wrote:

"Ed Stevens" <no****@noway.n ohow> wrote in message
news:nh******* *************** **********@4ax. com...

A tale of woe, and a question . . .

Last week my boss said to me "we've installed DB2 Connect on this
Solaris box. Make it work."

Now, I've barely seen DB2 Connect on Windows, having fumbled thru one
install and config, with a lot of handholding from IBM Support. I'm
comfortable in unix but have never dealt with DB2 Connect there. (my
main job is as an Oracle DBA, and most of my db's are on Solaris or
AIX) I've found the install docs to be pretty much worthless, and the
other on-line docs worse.

I went in thinking the product was functioning and all I needed to do
was catalog some nodes and remote databases, but immediately
discovered that the only thing done was that an SA had installed the
product. There was no relevent environment setup.

Digging thru another box that had v7 running on it, I finally traced
the settings back to a file called 'db2profile', to be sourced from
the user's .profile. (Where was THAT documented?). From there I
discovered that everything seemed to key off the setting of INSTHOME.
Only db2profile was read only (default from the installation) and
needed to be 'fixed' with this setting. Worked with the SA to get the
permissions to edit the file, and changed

INSTHOME=instan cehomedir

to

INSTHOME=/opt/IBM/DB2/v8.1

but then everything that key off of this, like additions to PATH,
appended '/sqllib' to it, and there is not directory
/opt/IBM/DB2/v8.1/sqllib. Going back to the working v7 installation,
I see that they have

INSTHOME=/local/home/db2inst1

which does have a directory 'sqllib', which contains mostly symlinks
back to /opt/IBMDB2/V7.1.

Now, I could figure out how to replicate all of that an make it work,
but I'm concerned that I'd be reinventing a wheel. I'd much rather do
it 'by the book' if I could only *FIND* the book! Can someone point
me to an on-line source or the proper html help file in the install
directory to explain how to REALLY set this up? Something that
explains required or assumed directories, environment setup, proper
config of them, etc., etc..

TIA.

I don't know about DB2 Connect, but with DB2 Server the db2profile
automaticall y gets set up for the instance owner during the install. This
assumes that you follow all the installation instructions (which your SA
probably did not do).

I would go back to the installation instructions and see if the SA followed
all the steps. I don't know the exact name of the file with the installation
instructions , but it is probably on the root path of the product disk.

As best I can tell, the SA followed all the steps. In the document
"DB2 Connect EE Quick Beginnings", Chapters 5 thru 8. There is quite
a bit of doco on hardware and software prereqs, but actual
installation on Solaris comes down to
1. mount the CD
2. run db2setup
3. Go thru the setup wizard.

A search thru that document turns up no hits on 'db2profile' nor on
some of the key env vars, such as 'DB2DIR', 'DB2INSTANCE', or
'INSTHOME'. Likewise, a search thru install.txt and release.txt from
the installation CD turned up no hits. A search of IBM.COM on 'DB2
Connect' turned up thousands of hits, futher filtering on any of the
above terms turned up either no hits or nothing of value. The only
hit I got was on 'db2profile'. A Redbook had the single comment that
a call to db2profile should be appended to the end of the user's
..profile. Well! That much I've already figured out, but still no
discussion of what values within db2profile need to be modified to
match the local installation or how the local installation must be
done to match db2profile ...

[Barbara von Euw]

Hello Ed

You're right, the DB2 Documentation to install DB2 on a Unix is very
bad - for example there's nowhere mentioned, that you need three user
and also three groups (look at the older doku, Db2 V6, there's more
documented).

When I interpret your problems correct, I assume, that your SA doesn't
install DB2 Connect correct (or only the first part...) Here's what
you should have (when I remeber the things correct):
user group
db2inst1 db2iadm1 -> that's the instance owner
db2fenc db2fadm1
db2as db2asgrp

During installation, the Instance db2inst1 should be created. You can
find out, if this instance exists, the following way: go to
/opt/IBM/DB2/v8.1/instance, and use this command: db2ilist
This command should show you at least one instance: db2inst1
When this instance is missing, you can create one: db2icrt (it has
some parameters, look into the Db2 command reference for that)

When this instance exists, you'll find in the db2inst1-home directory
the folder sqllib and also in the profile of db2inst1 the necessary
settings for db2.

After that, you jsut have to catalog the db2-databases and everything
should work. May be you have to update your services-file with the
correct prots for db2 - depending, which db2 you're accessing, on
port, 50000, should exists)

Regards
Barbara

Ed Stevens <no****@noway.n ohow> wrote in message news:<ff******* *************** **********@4ax. com>...

On Sat, 27 Nov 2004 13:44:31 -0700, "Mark A" <no****@nowhere .com>
wrote:

"Ed Stevens" <no****@noway.n ohow> wrote in message
news:nh******* *************** **********@4ax. com...

A tale of woe, and a question . . .

Last week my boss said to me "we've installed DB2 Connect on this
Solaris box. Make it work."

Now, I've barely seen DB2 Connect on Windows, having fumbled thru one
install and config, with a lot of handholding from IBM Support. I'm
comfortable in unix but have never dealt with DB2 Connect there. (my
main job is as an Oracle DBA, and most of my db's are on Solaris or
AIX) I've found the install docs to be pretty much worthless, and the
other on-line docs worse.

I went in thinking the product was functioning and all I needed to do
was catalog some nodes and remote databases, but immediately
discovered that the only thing done was that an SA had installed the
product. There was no relevent environment setup.

Digging thru another box that had v7 running on it, I finally traced
the settings back to a file called 'db2profile', to be sourced from
the user's .profile. (Where was THAT documented?). From there I
discovered that everything seemed to key off the setting of INSTHOME.
Only db2profile was read only (default from the installation) and
needed to be 'fixed' with this setting. Worked with the SA to get the
permissions to edit the file, and changed

INSTHOME=instan cehomedir

to

INSTHOME=/opt/IBM/DB2/v8.1

but then everything that key off of this, like additions to PATH,
appended '/sqllib' to it, and there is not directory
/opt/IBM/DB2/v8.1/sqllib. Going back to the working v7 installation,
I see that they have

INSTHOME=/local/home/db2inst1

which does have a directory 'sqllib', which contains mostly symlinks
back to /opt/IBMDB2/V7.1.

Now, I could figure out how to replicate all of that an make it work,
but I'm concerned that I'd be reinventing a wheel. I'd much rather do
it 'by the book' if I could only *FIND* the book! Can someone point
me to an on-line source or the proper html help file in the install
directory to explain how to REALLY set this up? Something that
explains required or assumed directories, environment setup, proper
config of them, etc., etc..

TIA.

I don't know about DB2 Connect, but with DB2 Server the db2profile
automaticall y gets set up for the instance owner during the install. This
assumes that you follow all the installation instructions (which your SA
probably did not do).

I would go back to the installation instructions and see if the SA followed
all the steps. I don't know the exact name of the file with the installation
instructions , but it is probably on the root path of the product disk.

As best I can tell, the SA followed all the steps. In the document
"DB2 Connect EE Quick Beginnings", Chapters 5 thru 8. There is quite
a bit of doco on hardware and software prereqs, but actual
installation on Solaris comes down to
1. mount the CD
2. run db2setup
3. Go thru the setup wizard.

A search thru that document turns up no hits on 'db2profile' nor on
some of the key env vars, such as 'DB2DIR', 'DB2INSTANCE', or
'INSTHOME'. Likewise, a search thru install.txt and release.txt from
the installation CD turned up no hits. A search of IBM.COM on 'DB2
Connect' turned up thousands of hits, futher filtering on any of the
above terms turned up either no hits or nothing of value. The only
hit I got was on 'db2profile'. A Redbook had the single comment that
a call to db2profile should be appended to the end of the user's
.profile. Well! That much I've already figured out, but still no
discussion of what values within db2profile need to be modified to
match the local installation or how the local installation must be
done to match db2profile ...

[Ed Stevens]

Barbara,

Thanks for the info. That squares pretty much with what I observed on
another system running Conect 7.something. I passed this whole thread
along to my SA, and pointed out your response. He will open a PMR
with support to get things resolved. One pointed question he and I
both have for support is "where was this documented?" I await the
answer with baited breath. ;-)

I thought it rather interesting that I follwed the links provided by
Jan Nelken (yes, I *had* tried to research this before posting!) and
ended up downloading every 'db2???8*.pdf file at that ftp site. Once
downloaded, I went thru every one that looked even remotely related
and searched on several of the key words, like 'db2profile' and
'INSTHOME' and got nothing of any value. Not exactly a star in IBM's
crown.

Thanks again for the lead.

On 30 Nov 2004 12:51:39 -0800, ba************@ mobi.ch (Barbara von
Euw) wrote:

Hello Ed

You're right, the DB2 Documentation to install DB2 on a Unix is very
bad - for example there's nowhere mentioned, that you need three user
and also three groups (look at the older doku, Db2 V6, there's more
documented).

When I interpret your problems correct, I assume, that your SA doesn't
install DB2 Connect correct (or only the first part...) Here's what
you should have (when I remeber the things correct):
user group
db2inst1 db2iadm1 -> that's the instance owner
db2fenc db2fadm1
db2as db2asgrp

During installation, the Instance db2inst1 should be created. You can
find out, if this instance exists, the following way: go to
/opt/IBM/DB2/v8.1/instance, and use this command: db2ilist
This command should show you at least one instance: db2inst1
When this instance is missing, you can create one: db2icrt (it has
some parameters, look into the Db2 command reference for that)

When this instance exists, you'll find in the db2inst1-home directory
the folder sqllib and also in the profile of db2inst1 the necessary
settings for db2.

After that, you jsut have to catalog the db2-databases and everything
should work. May be you have to update your services-file with the
correct prots for db2 - depending, which db2 you're accessing, on
port, 50000, should exists)

Regards
Barbara

Ed Stevens <no****@noway.n ohow> wrote in message news:<ff******* *************** **********@4ax. com>...

On Sat, 27 Nov 2004 13:44:31 -0700, "Mark A" <no****@nowhere .com>
wrote:

>
>"Ed Stevens" <no****@noway.n ohow> wrote in message
>news:nh******* *************** **********@4ax. com...
>> A tale of woe, and a question . . .
>>
>> Last week my boss said to me "we've installed DB2 Connect on this
>> Solaris box. Make it work."
>>
>> Now, I've barely seen DB2 Connect on Windows, having fumbled thru one
>> install and config, with a lot of handholding from IBM Support. I'm
>> comfortable in unix but have never dealt with DB2 Connect there. (my
>> main job is as an Oracle DBA, and most of my db's are on Solaris or
>> AIX) I've found the install docs to be pretty much worthless, and the
>> other on-line docs worse.
>>
>> I went in thinking the product was functioning and all I needed to do
>> was catalog some nodes and remote databases, but immediately
>> discovered that the only thing done was that an SA had installed the
>> product. There was no relevent environment setup.
>>
>> Digging thru another box that had v7 running on it, I finally traced
>> the settings back to a file called 'db2profile', to be sourced from
>> the user's .profile. (Where was THAT documented?). From there I
>> discovered that everything seemed to key off the setting of INSTHOME.
>> Only db2profile was read only (default from the installation) and
>> needed to be 'fixed' with this setting. Worked with the SA to get the
>> permissions to edit the file, and changed
>>
>> INSTHOME=instan cehomedir
>>
>> to
>>
>> INSTHOME=/opt/IBM/DB2/v8.1
>>
>> but then everything that key off of this, like additions to PATH,
>> appended '/sqllib' to it, and there is not directory
>> /opt/IBM/DB2/v8.1/sqllib. Going back to the working v7 installation,
>> I see that they have
>>
>> INSTHOME=/local/home/db2inst1
>>
>> which does have a directory 'sqllib', which contains mostly symlinks
>> back to /opt/IBMDB2/V7.1.
>>
>> Now, I could figure out how to replicate all of that an make it work,
>> but I'm concerned that I'd be reinventing a wheel. I'd much rather do
>> it 'by the book' if I could only *FIND* the book! Can someone point
>> me to an on-line source or the proper html help file in the install
>> directory to explain how to REALLY set this up? Something that
>> explains required or assumed directories, environment setup, proper
>> config of them, etc., etc..
>>
>> TIA.
>>
>I don't know about DB2 Connect, but with DB2 Server the db2profile
>automaticall y gets set up for the instance owner during the install. This
>assumes that you follow all the installation instructions (which your SA
>probably did not do).
>
>I would go back to the installation instructions and see if the SA followed
>all the steps. I don't know the exact name of the file with the installation
>instructions , but it is probably on the root path of the product disk.
>

As best I can tell, the SA followed all the steps. In the document
"DB2 Connect EE Quick Beginnings", Chapters 5 thru 8. There is quite
a bit of doco on hardware and software prereqs, but actual
installation on Solaris comes down to
1. mount the CD
2. run db2setup
3. Go thru the setup wizard.

A search thru that document turns up no hits on 'db2profile' nor on
some of the key env vars, such as 'DB2DIR', 'DB2INSTANCE', or
'INSTHOME'. Likewise, a search thru install.txt and release.txt from
the installation CD turned up no hits. A search of IBM.COM on 'DB2
Connect' turned up thousands of hits, futher filtering on any of the
above terms turned up either no hits or nothing of value. The only
hit I got was on 'db2profile'. A Redbook had the single comment that
a call to db2profile should be appended to the end of the user's
.profile. Well! That much I've already figured out, but still no
discussion of what values within db2profile need to be modified to
match the local installation or how the local installation must be
done to match db2profile ...

[Jan M. Nelken]

Ed Stevens wrote:

Barbara,

Thanks for the info. That squares pretty much with what I observed on
another system running Conect 7.something. I passed this whole thread
along to my SA, and pointed out your response. He will open a PMR
with support to get things resolved. One pointed question he and I
both have for support is "where was this documented?" I await the
answer with baited breath. ;-)

In one of the previous notes you mentioned:

"A search thru that document turns up no hits on 'db2profile' nor on
some of the key env vars, such as 'DB2DIR', 'DB2INSTANCE', or
'INSTHOME'."

Obviously this is not true; all you had to do was to search online
documentatopn available at:

http://publib.boulder.ibm.com/infoce...help/index.jsp

with 'db2profile' as search argument (without quotes) and you would find
multiple hits. Most relevant for your question is one titled:

"Setting up the UNIX environment"

where you would find:

Setting up the UNIX application development environment

You need to set environment variables for your database instance. Each
database manager instance has two files, db2profile and db2cshrc, which
are scripts to set the environment variables for that instance.
Procedure

Run the correct script for the shell you are using:

For bash or Korn shell:
. $HOME/sqllib/db2profile
For C shell:
source $HOME/sqllib/db2cshrc

where $HOME is the home directory of the instance owner.

If you include this command in your .profile or .login file, the command
runs automatically when you log on.

If you will be using ODBC, DB2 CLI, or Java, do the steps in one of the
following topics:

* Setting Up the UNIX ODBC Environment
* Setting Up the UNIX Java Environment

Related concepts

* UNIX environment variable settings

Related tasks

* Setting up the application development environment

Related reference

* AIX supported development software
* HP-UX supported development software
* Linux supported development software
* Solaris supported development software

This topic can be found in: Application Development Guide: Building and
Running Applications.

I put here complete quote for your convenience - but I really don't know
what else IBM should do to simplify your task:

IBM put documentation online, it is searchable and search does produce
an answer to your question.

What else in your opinion IBM should do?

Jan M. Nelken

[Darin McBride]

Barbara von Euw wrote:

Hello Ed

You're right, the DB2 Documentation to install DB2 on a Unix is very
bad - for example there's nowhere mentioned, that you need three user
and also three groups (look at the older doku, Db2 V6, there's more
documented).
http://www.ibm.com/db2

Click on "Support". First option in "Other resources" is "DB2 UDB
Version 8 Product Manuals". Click on that. It tells you that "[t]o
search DB2 UDB ... product manual information, go to the V8 InfoCenter
...." - so click there. That brings you to
http://publib.boulder.ibm.com/infoce...help/index.jsp . In the
contents pane, open Installing -> Database systems -> DB2 Universal
Database for Linux, UNIX, and Windows -> DB2 servers. Select a
product, then the platform, and you get all the information you need.

Since I think we started with DB2 Connect question - put 'install
"connect"' as your search terms, and, with 86%, I get a document called
"Installing DB2 Connect Enterprise Edition (AIX)" ... pretty much what
you want.
When I interpret your problems correct, I assume, that your SA doesn't
install DB2 Connect correct (or only the first part...) Here's what
you should have (when I remeber the things correct):
user group
db2inst1 db2iadm1 -> that's the instance owner
db2fenc db2fadm1
db2as db2asgrp
You can also name these anything you want.
During installation, the Instance db2inst1 should be created. You can
find out, if this instance exists, the following way: go to
/opt/IBM/DB2/v8.1/instance, and use this command: db2ilist
This command should show you at least one instance: db2inst1
When this instance is missing, you can create one: db2icrt (it has
some parameters, look into the Db2 command reference for that)

Yes, the DB2 documentation is pretty complete.
You may also be able to use db2isetup - it's the graphical installer,
but for instance setup only.

[Ed Stevens]

Jan,

I really don't want to get into a spitting match here, but allow me to
clarify a few things.

On Wed, 01 Dec 2004 16:17:44 -0500, "Jan M. Nelken"
<Un**********@I nvalid.Domain> wrote:

Ed Stevens wrote:

Barbara,

Thanks for the info. That squares pretty much with what I observed on
another system running Conect 7.something. I passed this whole thread
along to my SA, and pointed out your response. He will open a PMR
with support to get things resolved. One pointed question he and I
both have for support is "where was this documented?" I await the
answer with baited breath. ;-)

In one of the previous notes you mentioned:

"A search thru that document turns up no hits on 'db2profile' nor on
some of the key env vars, such as 'DB2DIR', 'DB2INSTANCE', or
'INSTHOME'."

Obviously this is not true; all you had to do was to search online
documentatop n available at:

http://publib.boulder.ibm.com/infoce...help/index.jsp

with 'db2profile' as search argument (without quotes) and you would find
multiple hits. Most relevant for your question is one titled:

"Setting up the UNIX environment"

where you would find:

Setting up the UNIX application development environment

You need to set environment variables for your database instance. Each
database manager instance has two files, db2profile and db2cshrc, which
are scripts to set the environment variables for that instance.
Procedure

Run the correct script for the shell you are using:

For bash or Korn shell:
. $HOME/sqllib/db2profile
For C shell:
source $HOME/sqllib/db2cshrc

where $HOME is the home directory of the instance owner.

If you include this command in your .profile or .login file, the command
runs automatically when you log on.

If you will be using ODBC, DB2 CLI, or Java, do the steps in one of the
following topics:

* Setting Up the UNIX ODBC Environment
* Setting Up the UNIX Java Environment

Related concepts

* UNIX environment variable settings

Related tasks

* Setting up the application development environment

Related reference

* AIX supported development software
* HP-UX supported development software
* Linux supported development software
* Solaris supported development software

This topic can be found in: Application Development Guide: Building and
Running Applications.

I put here complete quote for your convenience - but I really don't know
what else IBM should do to simplify your task:

IBM put documentation online, it is searchable and search does produce
an answer to your question.

What else in your opinion IBM should do?

Jan M. Nelken

Jan,

I really don't want to get into a spitting match here, but allow me to
clarify a few things.

First, as I mentioned in my opening post, I'm an Oracle DBA and have
only seen DB2 Connect enough to fumble thru one installation on a
Windows desktop. From that it is reasonable to understand that I am
not familiar with all of the various locations IBM might place on-line
assistance. I was literally starting with nothing but a browser and
my own wits, such as they are. With that I started my search at
www.ibm.com, and
http://www-306.ibm.com/software/data/db2/udb/support/.

And of course the SA who actually performed the install, knows nothing
about any of it. He is simply handed a CD and told "install this" so
he is working from a very limited set of documentation or knowledge of
where to find additional documentation.

Yes, we did find Instructions to run db2profile but that assumes that
db2profile has the values for DB2INSTANCE and INSTHOME hardcoded
within itself, and that the values there refer to directories that
have already been created and populated. So there needs to be
instructions to deal with that. We found none.

"This topic can be found in: Application Development Guide: Building
and Running Applications."

Ah, there it is! Now why in the world didn't the SA installing the
software think to himself "Even though this install.txt file and the
very clear installation instructions in "Quick Beginnings for DB2
Connect" look complete, I'll bet they are leaving out some important
steps. I wonder if I can find these unknown missing installation
steps in . . . . an application development guide!"

What else could IBM have done? Simple -- instead of expecting an SA
to intuit that the doco they were provided is incomplete and expecting
them to plumb the depths of a variety of on-line sites (even having to
guess where to start) they could have placed *ALL* of the necessary
setup and configuration steps in a single installation guide included
on the distribution CD. If there were things the 'setup' wizard
assumed, it should have been spelled out in the installation document.
It should have a page-by-page description of the setup Wizard -- what
each field and choice means. In other words, *everything* the
installer needs to know needs to be in a single installation document
included with the install CD. It's a simple concept that other
software vendors seem to have grasped.

[Darin McBride]

Ed Stevens wrote:

First, as I mentioned in my opening post, I'm an Oracle DBA and have
only seen DB2 Connect enough to fumble thru one installation on a
Windows desktop. From that it is reasonable to understand that I am
not familiar with all of the various locations IBM might place on-line
assistance. I was literally starting with nothing but a browser and
my own wits, such as they are. With that I started my search at
www.ibm.com, and
http://www-306.ibm.com/software/data/db2/udb/support/.

And of course the SA who actually performed the install, knows nothing
about any of it. He is simply handed a CD and told "install this" so
he is working from a very limited set of documentation or knowledge of
where to find additional documentation.

Yes, we did find Instructions to run db2profile but that assumes that
db2profile has the values for DB2INSTANCE and INSTHOME hardcoded
within itself, and that the values there refer to directories that
have already been created and populated. So there needs to be
instructions to deal with that. We found none.
There are no instructions for this, because it's not needed. From
Jan's note:

For bash or Korn shell:
. $HOME/sqllib/db2profile
For C shell:
source $HOME/sqllib/db2cshrc

Note how this is using the db2profile from the instance's home
directory, under sqllib. That copy of db2profile is set up exactly as
is required to get your environment set up for that instance. There
will be another copy under a second instance, if you have a second
instance, where the environment for that second instance is stored.
Choose your instance environment by using the right db2profile.
"This topic can be found in: Application Development Guide: Building
and Running Applications."

Ah, there it is! Now why in the world didn't the SA installing the
software think to himself "Even though this install.txt file and the
very clear installation instructions in "Quick Beginnings for DB2
Connect" look complete, I'll bet they are leaving out some important
steps. I wonder if I can find these unknown missing installation
steps in . . . . an application development guide!"
Your original note said:
Digging thru another box that had v7 running on it, I finally traced
the settings back to a file called 'db2profile', to be sourced from
the user's .profile. (Where was THAT documented?)
That is documented how Jan said - you knew what you were looking for,
so a quick search with the online library would have gotten you to a
document that may have seemed out of the way, but was still easily
accessible via search.

Now, that said, I have to wonder: do you even have *any* instance set
up? First, you should not be touching anything in /opt/IBM/db2/V8.1.
By messing around with that copy of db2profile, you will render it
impossible for db2 to properly create further instances. I suggest you
revert this file to its backup (since you said you're a DBA, I presume
you take backups of everything you do - any other newsgroup, I would
think this to be a far-fetched assumption).

Then, following the documentation here:

http://publib.boulder.ibm.com/infoce...t/t0007067.htm

you should be able to create your instance. Then you'll have an
instance-specific version of db2profile. Within this instance, you can
catalog your remote nodes, databases, etc.
What else could IBM have done? Simple -- instead of expecting an SA
to intuit that the doco they were provided is incomplete and expecting
them to plumb the depths of a variety of on-line sites (even having to
guess where to start) they could have placed *ALL* of the necessary
setup and configuration steps in a single installation guide included
on the distribution CD. If there were things the 'setup' wizard
assumed, it should have been spelled out in the installation document.
It should have a page-by-page description of the setup Wizard -- what
each field and choice means. In other words, *everything* the
installer needs to know needs to be in a single installation document
included with the install CD. It's a simple concept that other
software vendors seem to have grasped.

Not that you're bitter or anything ...

1) All the docs are there just fine. We don't document db2profile
during installation because, if you're following the rest of the
documentation, it gets created automatically and properly during
instance creation. If you don't create an instance (always a possible
choice on Solaris), you don't have any DB2 environment that you can
use.

2) All of the fields in the graphical installer are documented on the
CD - hit the "help" button at any time to get context-sensitive help.
Rather than fumbling through a very large document, we'll send you
directly to the page of interest. Most other software vendors seem to
have grasped this concept, too.

3) Once this whole thing is installed, you need to operate from the
instance environment. I highly suspect you weren't doing so, and this
drove your confusion. Once installation is complete, you're on to
configuring DB2 for your business purposes. In the documentation, I
went to the main topic of "Configurin g". In your case, we want to
configure a connection to another database system, so I selected
Database systems (first option), opened Database connections (first
option again), and clicked on "Adding database connections with the
CLP":

http://publib.boulder.ibm.com/infoce...t/t0007243.htm

From here, I see that I want to Catalog [a] TCP/IP node. So I click on
that.

http://publib.boulder.ibm.com/infoce...t/t0005621.htm

Step 2 of the procedure is ... using db2profile "where INSTHOME
represents the home directory of the instance."

I don't think I've used any information that you did not give me,
except perhaps for knowing precisely where the online documentation is
(although I posted a note yesterday on finding that - it's a few links,
a few more than many may like, but it's not really that well hidden
either).