Solved

ERROR ON DB CREATION

Posted on 2004-09-04
4
409 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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now