ERROR ON DB CREATION

1) I have installed db2 7.2 on windows 2000 system.

2) C:\PROGRA~1\SQLLIB\BIN>db2sampl
SQL3274W  The database was created successfully. However, the database was not cataloged in the LDAP directory. SQLCODE = "SQL3282".

C:\PROGRA~1\SQLLIB\BIN>db2 ? SQL3274W

SQL3274W The database was created successfully. However, the database was not cataloged in the LDAP directory.
SQLCODE = "<sqlcode>".

Explanation:  The database was created successfully. However, the database could not be cataloged in the LDAP directory because there was an error occurred during the operation.

User Response:  Correct the error as indicated in the SQLCODE. Then catalog the database in the LDAP directory using the CATALOG LDAP DATABASE command.


C:\PROGRA~1\SQLLIB\BIN>db2 ? SQL3282

 SQL3282N The supplied credentials are not valid.

Explanation:  Either or both the distinguished name (DN) of the
user and the password that were specified were not valid.

User Response:  Resubmit the command using valid values for both the distinguished name (DN) of the user and the password.

What could be valid values for both the distinguished name (DN) of the user and the password.

LVL 17
k_murli_krishnaAsked:
Who is Participating?
 
ghp7000Connect With a Mentor Commented:
when ldap=yes, you have to catalog the database as ldap.
http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/core/r0002444.htm?

when you install new fixpack, the registry settings should be migrated as well. To check this, after installing fixpack, issue:
db2set -all
0
 
ghp7000Commented:
do you need ldap support on the server? If no, from clp issue:

db2set DB2_ENABLE_LDAP=NO
0
 
k_murli_krishnaAuthor Commented:
Thank you, ghp7000. This is okay for me. Just for curiosity, can you try & tell me how to make the error disappear event when DB2_ENABLE_LDAP=YES
0
 
k_murli_krishnaAuthor Commented:
Also, if I upgrade with fixpack 3 & 12, do I set DB2_ENABLE_LDAP=YES/NO
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.