• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 429
  • Last Modified:

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.

0
k_murli_krishna
Asked:
k_murli_krishna
  • 2
  • 2
1 Solution
 
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
 
ghp7000Commented:
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now