View Single Post
  #5 (permalink)  
Old 04-11-07, 08:05
enjoyabhay enjoyabhay is offline
Registered User
 
Join Date: Apr 2007
Posts: 1
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.

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 .
Reply With Quote