DB2 Connection failure

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.
 
 
clickrajkumarAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

fantasy1001Commented:
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
clickrajkumarAuthor Commented:
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
fantasy1001Commented:
As far as I know, you need an account with Administrator access for this. Is your account in this kind?
0
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

clickrajkumarAuthor Commented:
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
fantasy1001Commented:
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
clickrajkumarAuthor Commented:
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
jmcgOwnerCommented:
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
SpazMODicCommented:
PAQed, with points refunded (50)

SpazMODic
EE Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Perl

From novice to tech pro — start learning today.