Solved

ERROR ON DB CREATION

Posted on 2004-09-04
4
416 Views
Last Modified: 2010-08-05
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
Comment
Question by:k_murli_krishna
  • 2
  • 2
4 Comments
 
LVL 13

Expert Comment

by:ghp7000
ID: 11981300
do you need ldap support on the server? If no, from clp issue:

db2set DB2_ENABLE_LDAP=NO
0
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 11983178
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
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 11983180
Also, if I upgrade with fixpack 3 & 12, do I set DB2_ENABLE_LDAP=YES/NO
0
 
LVL 13

Accepted Solution

by:
ghp7000 earned 75 total points
ID: 11992673
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question