Results 1 to 7 of 7
  1. #1
    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

  2. #2
    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

    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.

  3. #3
    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.

  4. #4
    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

    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.

  5. #5
    Join Date
    May 2003
    Posts
    369

    thanks will look into this

    Thanks for the feedback I need to investigate further.

  6. #6
    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.

  7. #7
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •