Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2004

    Unanswered: Failed to run DB2 command for ADMCL

    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!


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 1

    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,

  3. #3
    Join Date
    Nov 2004
    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!!!


  4. #4
    Join Date
    Nov 2004


    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
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified

  5. #5
    Join Date
    Apr 2007

    SQL10007N Message "-5005" could not be retrieved. Reason code: "3"

    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.


    A file or directory that the command needs to create already

    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.


    All processed and failed operations have been saved into this log

    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 .

  6. #6
    Join Date
    Feb 2010


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

  7. #7
    Join Date
    Apr 2006
    Provided Answers: 11
    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
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts