By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

CONNECT TO hangs, no response

P: n/a
Hello,

I am getting no response when trying to connect to one of our
databases. The funny thing is that it only happens when trying to
connect using a specific user. Other users are able to connect.

For example:
this connects: CONNECT TO MYDB USER ABC
this just hangs (no response): CONNECT TO MYDB USER XYZ

I cannot anything anywhere that can explain this. User XYZ has been
able to connect in the past (up until today). Anybody have any ideas??

Thanks much,
Paolo

Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
check the password.

if connecting remotely, then check the firewall settings if any, check
instance and db catalog settings..

regards,
dotyet

Paolo wrote:
Hello,

I am getting no response when trying to connect to one of our
databases. The funny thing is that it only happens when trying to
connect using a specific user. Other users are able to connect.

For example:
this connects: CONNECT TO MYDB USER ABC
this just hangs (no response): CONNECT TO MYDB USER XYZ

I cannot anything anywhere that can explain this. User XYZ has been
able to connect in the past (up until today). Anybody have any ideas??

Thanks much,
Paolo


Nov 12 '05 #2

P: n/a


Paolo wrote:
Hello,

I am getting no response when trying to connect to one of our
databases. The funny thing is that it only happens when trying to
connect using a specific user. Other users are able to connect.

For example:
this connects: CONNECT TO MYDB USER ABC
this just hangs (no response): CONNECT TO MYDB USER XYZ

I cannot anything anywhere that can explain this. User XYZ has been
able to connect in the past (up until today). Anybody have any ideas??

Thanks much,
Paolo


Somebody change the network settings for user XYZ?
Somebody add a duplicate user on the network name XYZ?
Somebody change the trust relationships (if any ) among the domain
controllers?
I suspect your problem related to changed network settings

Nov 12 '05 #3

P: n/a
Just a hunch.

Is it possible that this user was connected and running some
long-running process and he/she shut down his client or somehow
disconnected, leaving the thread on the server still running and
therefore leaving the resources on the server allocated and orphaned?

Larry Edelstein

Paolo wrote:
Hello,

I am getting no response when trying to connect to one of our
databases. The funny thing is that it only happens when trying to
connect using a specific user. Other users are able to connect.

For example:
this connects: CONNECT TO MYDB USER ABC
this just hangs (no response): CONNECT TO MYDB USER XYZ

I cannot anything anywhere that can explain this. User XYZ has been
able to connect in the past (up until today). Anybody have any ideas??

Thanks much,
Paolo

Nov 12 '05 #4

P: n/a
Thank you everyone for your responses. I thought I'd give a little
more info. I'm trying to connect from my local machine (Windows XP)
via CLP to a DB2 Connect Server on (Windows XP) to a DB2 database on
the Mainframe. Not sure if that sheds anymore light. Thanks again for
all your help.

Nov 12 '05 #5

P: n/a
Ok, I have resolved my issue. I did an UNCATALOG DATABASE MYDB then a
CATALOG DATABASE MYDB AT NODE MYNODE AUTHENITCATION SERVER
This seems to have done the trick. To get a list of database aliases
on my machine, I did a LIST DATABASE DIRECTORY. Same goes for nodes;
LIST NODE DIRECTORY. I just wish I knew what caused this to fail in
the first place. Thanks again for all your help.

Nov 12 '05 #6

P: n/a
DNS / DHCP address changes and no ipconfig /refresh on the client?

Since you're in a Windows environment, I recommend your using LDAP
cataloguing rather than local cataloguing. It eliminates these sorts of
maintenance issues.

"Paolo" <pd******@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
Ok, I have resolved my issue. I did an UNCATALOG DATABASE MYDB then a
CATALOG DATABASE MYDB AT NODE MYNODE AUTHENITCATION SERVER
This seems to have done the trick. To get a list of database aliases
on my machine, I did a LIST DATABASE DIRECTORY. Same goes for nodes;
LIST NODE DIRECTORY. I just wish I knew what caused this to fail in
the first place. Thanks again for all your help.

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.