CONNECT TO hangs, no response

[Paolo]

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

[dotyet]

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

[fyi85]

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

[Larry]

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

[Paolo]

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.

[Paolo]

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.

[Mark Yudkin]

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.