?
Solved

DB2 Connection failure

Posted on 2003-10-21
8
Medium Priority
?
538 Views
Last Modified: 2008-03-04
Hi Experts,

     Previousely  I've tried to connecting (AIX based) DB2 databases from my linux box thru perl module were sucessful, but when try to connect (Win based) DB2 database I'm getting the following errors.

    "TLMA" is my DB2 db.
 
       "SQL1403N  The username and/or password supplied is incorrect.  SQLSTATE=08004"

Here are my configurations :-

  Database Directory List :-

      $ db2 list database directory
                  Database alias                     = TLMA
                  Database name                   = TLMA
                  Node name                         = TLMA
                  Database release level         = 9.00
                  Comment                           =
                  Directory entry type             = Remote
                  Catalog node number          = -1

  Node Listing :-

      $ db2 list node directory

                  Node name                       = TLMA
                  Comment                         =
                  Protocol                           = TCPIP
                  Hostname                        = 172.20.80.84
                  Service name                   = 50000

     I feel I'm not connected with the above error, but I don't know where the error lies on. I'm Sure the username and password are correct.

Plz. Help me on this.
Click.
 
 
0
Comment
Question by:clickrajkumar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 5

Expert Comment

by:fantasy1001
ID: 9597340
Your logged on userid is not authorised to connect to the database.

Try these commands from the db2 shell.

d:> db2cmd

e:> db2 connect to "yourdatabase" user "youruserid" using "yourpassword"

The default DB2 installation on a winnt machine only grants access rights to the local administrator
on the machine i.e the "administrator" userid.

If you are logged on via an NT domain log off the domain, log back on to the local machine as
"administrator"(you must know the password). Once logged in either add your domain userid to the
LOCAL administrators group or create a new local id for yourself. If you choose the former you can
access DB2 from the domain, choose the latter and you must log on locally to the machine to access
DB2. Once you have administrator rights you can add domain users to DB2 group objects and restrict
access rights.
0
 

Author Comment

by:clickrajkumar
ID: 9597501
Hi,

   I'm trying to Connect DB2 database in a Win2000 Server and 'm having myown userid (other than Administrator) which has proper access privileges.

   I've tried connecting to the DB thru DB2 Connect from my Linux Box it throws the following.


[db2inst1@AAA db2inst1]$ db2 connect to TLMA user db2 using db2admin
SQL1403N  The username and/or password supplied is incorrect.  SQLSTATE=08004
[db2inst1@AAA db2inst1]$

   Even I'm getting the same error when try to connect by my perl module.

  What I've to do more on this???

Click
0
 
LVL 5

Expert Comment

by:fantasy1001
ID: 9597569
As far as I know, you need an account with Administrator access for this. Is your account in this kind?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:clickrajkumar
ID: 9597709
Yep Fantasy,

   I've also tried with both (As by my userid aswell as with Admin id), Still the same problem is choking my neck.

Click
0
 
LVL 5

Expert Comment

by:fantasy1001
ID: 9597753
From others sources:

Check the ownership and permissions on the db2ckpw program. They should look like this:
bash$ ls -al ~/sqllib/security/db2ckpw
-rwsr-s--x    1 root     build       15989 Oct 17 07:22 sqllib/security/db2ckpw*
 
If this program is not owned by root, then do the following as root:
bash# chown root db2ckpw
bash# chmod ug+s db2ckpw
 
0
 

Author Comment

by:clickrajkumar
ID: 9597897
Yes Fantasy,
   I've read same answer from IBM site itself, and when I try to search for db2ckpw file in the 2000 Server (Win) Machine I was unable to get it. It seem the above soluiton is only fit for Linux Flavoured Servers...

Click
0
 
LVL 20

Expert Comment

by:jmcg
ID: 10030553
Nothing has happened on this question in over 2 months. It's time for cleanup!

My recommendation, which I will post in the Cleanup topic area, is to
PAQ, refund points (unanswered, but some interesting steps along the way).

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jmcg
EE Cleanup Volunteer
0
 

Accepted Solution

by:
SpazMODic earned 0 total points
ID: 10078697
PAQed, with points refunded (50)

SpazMODic
EE Moderator
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

Question has a verified solution.

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

On Microsoft Windows, if  when you click or type the name of a .pl file, you get an error "is not recognized as an internal or external command, operable program or batch file", then this means you do not have the .pl file extension associated with …
A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (http://www.mongodb.org/downloads),  installed and started the daemon, and had a console window open. After an hour or two of playing at the command …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Six Sigma Control Plans
Suggested Courses

765 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