If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > db2 connect hangs need help

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: May 2003
Posts: 369
db2 connect hangs need help

When I try to connect to db2 using 'db2 connect to databasename'
it hangs. I can run other db2 commands like 'db2 list applications'
without errors. However when I run the list node command I get the following message:


db2inst2@av2: /i3stage1/db2dump >
# db2 list node directory
SQL1027N The node directory cannot be found.

Would this cause my db2 connect to fail? Thanks

Scott
Reply With Quote
  #2 (permalink)  
Old
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,649
Re: db2 connect hangs need help

I don't think that your sql1027n error and not able to connect are related ...

A look into your db2diag.log may give information ....

Also, check the system resources ... Creating a new connection requires resources ...


As additional bit of information :

When an instance is created, there is no node directory (as in your case)

When you catalog the first node, the node directory is created .. Subsequently if you uncatalog that node, the node directory will be 'empty' ...

Cheers

Sathyaram

Quote:
Originally posted by mixxalot
When I try to connect to db2 using 'db2 connect to databasename'
it hangs. I can run other db2 commands like 'db2 list applications'
without errors. However when I run the list node command I get the following message:


db2inst2@av2: /i3stage1/db2dump >
# db2 list node directory
SQL1027N The node directory cannot be found.

Would this cause my db2 connect to fail? Thanks

Scott
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: May 2003
Posts: 369
thanks and update

Actually I find no errors in db2diag log file and the node directory issue has nothing to do with connection problems to db2. Found out that I may need to run the db2 activate database command to have more stable connection state for db2. But weird to have the db2 connect run so slowly.
Reply With Quote
  #4 (permalink)  
Old
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,649
Re: thanks and update

Was it the first connection ? Then, obviously, it will be quiet slow because db2 has to allocate memory resources+ primary log files for the dataabse ....

Another reason for the first connection taking longer time is Crash Recovery (which has not, in your case, as, with diaglevel 3, crash recover writes info to db2diag.log)

One other reason can be INDEXREC parm set to restart ... If so, invalid indexes will be rebuilt on the activation of the database (Not sure whether this will write to db2diag.log, but would assume so ... ) .. This parameter being set to restart is what I would recommend .. The other option is access , in which case, the index will be rebuild during the first access to the object , therby, making the query 'hang'

HTH

Sathyaram

Quote:
Originally posted by mixxalot
Actually I find no errors in db2diag log file and the node directory issue has nothing to do with connection problems to db2. Found out that I may need to run the db2 activate database command to have more stable connection state for db2. But weird to have the db2 connect run so slowly.
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: May 2003
Posts: 369
thanks will look into this

Thanks for the feedback I need to investigate further.
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Nov 2002
Location: Delaware
Posts: 186
Re: db2 connect hangs need help

You may also want to check your rhosts file, and /etc/servcies files to make sure the ports are defined.
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: May 2003
Posts: 369
thanks

I will look at these configurations on our system. However I fear the issue is due to poor system performance at the AIX Unix O/S level, I checked paging space and the AIX O/S has issues. Informed our Unix guy and he will look into it. Thanks again.

Scott
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On