Hi all,

I tried to install DB2 Administration Client (ADMCL) 8.1 on AIX.
After that I created the users "db2inst1", "db2fenc1" and the corresponding
user groups, etc.

However, when I tried to run /usr/opt/db2_08_01/bin/db2, I got a message:
SQL10007N Message "-1390" could not be retrieved. Reason code: "1".

Then I tried to re-install it but the problem occurred again.
I found some reference to tell me that I should add the
~<instance>/sqllib/db2profile in .profile.

The problem is, I didn't see any directory /home/db2inst1/sqllib ....
Finally I manually added the folder sqllib and copy the db2profile into it.
Then I got the below message:
SQL10007N Message "-5005" could not be retrieved. Reason code: "2".

Who can help? Thanks very much!

Regards,
Levin

Hi,

You have a problem related to already created instance. Check the instance name (command: db2ilist). If instance already exist, then drop the instance (command: db2idrop <instance_name>). Then try to install admin client again.

Hope this helps,
Grofaty

Hi grofaty,

I didn't find any instance by db2ilist but I did re-install the admin client
(more information: I used the db2_install script to install it).

After re-install, it still failed. There isn't any "sqllib" folder in /home/db2inst1

I tried copy the whole "sqllib" folder from another machine which has DB2 server installed, but the result was failed again...

Should I better re-install it by graphic mode (use the Wizard)?
Thanks anyway!!!

Regards,
Levin

from root cd /opt/IBM/db2/V8.1/instance
execute db2icrt -s client xxxx
this will create the client instance and sqllib.....
db2profile ....
Best Regards, Guy Przytula

i am getting this error

bash-2.05# db2
SQL10007N Message "-5005" could not be retrieved. Reason code: "3".

can anyone help me in this

i tried this

./db2icrt -u db2fenc1 db2inst1
DBI1082E The file or directory /export/home/db2inst1/sqllib already exists.

Explanation:

A file or directory that the command needs to create already
exists.

User Response:

Examine the specified file or directory. If the file or
directory exists as a result of a previous successful completion
of the command then no action is required. Otherwise, you will
need to either rename or remove the specified file or directory
before trying the command again.


DBI1079I Output is saved in the log file /tmp/db2icrt.log.4897.

Explanation:

All processed and failed operations have been saved into this log
file.

User Response:

Do not modify this file in any way. This file is for IBM
Technical Support reference.



I manually removed /export/home/db2inst1/ folder and tried again
./db2icrt -u db2fenc1 db2inst1
but still the above message came.

also db2ilist is showing nothing.
/export/home/db2inst1/sqllib folder has only

-rw-r--r-- 1 root other 89 Apr 11 21:37 global.reg
-rw-r--r-- 1 root other 0 Apr 11 21:37 .global.reg.lock
drwxr-xr-x 3 root other 512 Apr 11 21:37 ..
drwxr-xr-x 2 root other 512 Apr 11 21:37 .

Try use db2idrop in your db2 instance installation path and recreate instance by using db2icrt I Hope This Helps.

execute db2icrt/db2idrop from root
db2 and db2ilist from instance owner - never from root
do not copy manually any folder - always use db2icrt to create the environment for a user/instance