Solved

ERROR ON DB CREATION

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

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

856 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