asked on

DB2 Config Assistant on Linux (WITH LINUX CONSOLE (GNOME))

I tool kdo's advice and am now using the Desktop environment (Gnome) with Linux

(Actually it was there all the time, so I should have installed DB2 right on top of it).

I apologize for my apparent stubbornness)

Now that I have a Linux server console, I still do not understand how to invoke the Configuration assistant on Linux

Its easy on Windows, but I do not see a path to it on the Desktop

Does anyone know how to invoke the configuration assistant

(I am trying to connect WMB to DB2, and to do that I need to register a DB2 data source)

Kent Olsen

Hi Greensburo,

The Db2 objects should have been installed with an "owning" user. Log in as that user and search the user directory (and subdirectories) for a file setup, or setup.sh.

Once you find it, cd to that directory and run the setup script.

The xTerm hooks should already be in place for you.

Kent

Los Angeles1

ASKER

From the response file:

DAS_USERNAME       = db2user
DAS_GROUP_NAME       = dasadm1
DAS_HOME_DIRECTORY       = /home/db2user

Open in new window

and ...

inst1.NAME       = db2inst1
inst1.GROUP_NAME       = db2iadm1
inst1.HOME_DIRECTORY       = /home/db2inst1

Open in new window

(db2inst1 is the username I previously logged into to create a database and table)

So I performed the following:

[root@power730 ~]# su - db2inst1
[db2inst1@power730 ~]$ pwd
/home/db2inst1
[db2inst1@power730 ~]$ ls
catalog.sql  db2inst1  ipc.csv  sqllib
[db2inst1@power730 ~]$
[db2inst1@power730 ~]$ find . -name setup*
[db2inst1@power730 ~]$ find . -name *.sh

Open in new window

Just in case I misunderstood, I did the following:

[root@power730 ~]# su - db2user
[db2user@power730 ~]$ pwd
/home/db2user
[db2user@power730 ~]$ ls
das
[db2user@power730 ~]$
[db2user@power730 ~]$ find . -name setup*
[db2user@power730 ~]$ find . -name *.sh

Open in new window

1> Was db2inst1 the user you wanted me to search under

2> What did I do wrong ?

Thanks

Kent Olsen

Hi Greensburo,

db2inst1 is the name of the instance owner. It is probably not the name of the user that owns all of the db2 objects (executables, libraries, etc.)

You probably used a generic db2 name for that. If the db2icrt program exists, it should tell you the owner, which would be the installing user.

find / -name db2icrt

If the file is found,

ls -l {path}/db2icrt

Kent

Los Angeles1

ASKER

I found the db2icrt command:

[db2user@power730 V9.7_01]$ pwd
/opt/ibm/db2/V9.7_01
[db2user@power730 V9.7_01]$ find . -name db2icrt
./instance/db2icrt
[db2user@power730 V9.7_01]$ cd instance
[db2user@power730 instance]$ pwd
/opt/ibm/db2/V9.7_01/instance
[db2user@power730 instance]$ ls -l /opt/ibm/db2/V9.7_01/instance/db2icrt
-r-xr--r-- 1 root root 8747 Dec  8  2010 /opt/ibm/db2/V9.7_01/instance/db2icrt

Open in new window

Does this imply that root is the owner of db2

Kent Olsen

Root owns the objects that run db2.

Look in /opt/ibm/db2/V9.7_01 (and subdirectories) for the setup script.

Kent

Los Angeles1

ASKER

I do not seem to have this file anywhere on my system

[root@power730 V9.7_01]# pwd
/opt/ibm/db2/V9.7_01
[root@power730 V9.7_01]# ls
adm   conv     dsdriver  infopop   lib32    misc        security32
adsm  das      function  install   lib64    msg         security64
bin   dasfcn   gskit     instance  license  properties  tivready
bnd   desktop  ha        itma      logs     Readme      tools
cfg   doc      include   java      map      samples
[root@power730 V9.7_01]# whoami
root
[root@power730 V9.7_01]# find . -name setup.sh
[root@power730 V9.7_01]# find /opt/ibm/db2/V9.7_01 -name setup.sh
[root@power730 V9.7_01]# find / -name setup.sh
[root@power730 V9.7_01]#
[root@power730 V9.7_01]#

Open in new window

Is there a way to create this file ?

I googled the setup.sh DB2 file, Is this the the file that installs the accessories suite ?

Thanks

ASKER CERTIFIED SOLUTION

jackiechen858

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jackiechen858

oh, you said you have gnome console. then if you find db2ca, first login as root, run "xhost +" to allow access. then run
su - db2user
/thelocation/db2ca

Los Angeles1

ASKER

I can not find a db2ca file on my system (which I have db2 installed on):

[root@power730 /]# pwd
/
[root@power730 /]# find . -name db2ca
[root@power730 /]#

Open in new window

Nor is there a link to it once I log into db2user

[root@power730 /]# su - db2user
[db2user@power730 ~]$ db2ca
-bash: db2ca: command not found

Open in new window

Do I need to install the db2 client as well as the db2 server ?

SOLUTION

jackiechen858

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Los Angeles1

ASKER

I am running RHEL 5.6 with DB2, I did the following:

[db2user@power730 ~]$ whoami
db2user
[db2user@power730 ~]$ db2ca
-bash: db2ca: command not found
[db2user@power730 ~]$ ./db2ca
-bash: ./db2ca: No such file or directory
[db2user@power730 ~]$

Open in new window

Then I checked as you requested:

[root@power730 /]# su - db2inst1
[db2inst1@power730 ~]$ db2
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 9.7.3

Open in new window

BTW, I am using DB2 9.7 AESE

What is the command to create a ODBC DSN for a table ?