Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: db2 seems to crash and not allow connections to the database

    We are running db2 v7.2 fixpack 6 with WebSphere 4.0. Just recently it has started to act a little flaky.

    WebSphere will time out in it's connection to DB2 and shutdown its services however on AIX the ps -ef |grep command still shows the processes as running.

    This is the only thing that gets written to the db2diag.log file

    2003-05-20-10.10.05.656549 Instance:wasproda Node:000
    PID:13388(db2spmrm) Appid:none
    oper_system_services sqloopenp Probe:36

    errno: 0000 0011

    I have already set the SPM NAME to null

    SPM name (SPM_NAME) = null
    SPM log size (SPM_LOG_FILE_SZ) = 256
    SPM resync agent limit (SPM_MAX_RESYNC) = 20
    SPM log path (SPM_LOG_PATH) =

    But I have noticed that the log path is /home/instacnename/sqllib/spmlog and stuff is still being written to this directory

    I was wondering if this could possibly be part of the problem?

    thanks

    I may need to give you guys some more info, just let me know and I will supply it

    mark

  2. #2
    Join Date
    May 2003
    Location
    Phoenix, US
    Posts
    39
    Hi,

    During this time will you be able to connect to the DB from command prompt.
    What happens is when you execute db2 "force applications all" command,
    the database crashes sometimes and some of the DARI processes will still be running as zombie processes . In this case no new connections will be allowed to the DB.
    Untill you clear all the process and as well as the shared memory.

    Thanks
    Sateesh

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: db2 seems to crash and not allow connections to the database

    You can try db2kill and db2ipclean ( you might need to spell them correctly) ...

    The former kills of all processes (used if db2stop won't work) and the latter for cleaning the inter-process communication residues ...

    sqloopenp is a generic message which is recorded when db2 is not running ...

    HTH

    Cheers

    Sathyaram

    Originally posted by mark_maz
    We are running db2 v7.2 fixpack 6 with WebSphere 4.0. Just recently it has started to act a little flaky.

    WebSphere will time out in it's connection to DB2 and shutdown its services however on AIX the ps -ef |grep command still shows the processes as running.

    This is the only thing that gets written to the db2diag.log file

    2003-05-20-10.10.05.656549 Instance:wasproda Node:000
    PID:13388(db2spmrm) Appid:none
    oper_system_services sqloopenp Probe:36

    errno: 0000 0011

    I have already set the SPM NAME to null

    SPM name (SPM_NAME) = null
    SPM log size (SPM_LOG_FILE_SZ) = 256
    SPM resync agent limit (SPM_MAX_RESYNC) = 20
    SPM log path (SPM_LOG_PATH) =

    But I have noticed that the log path is /home/instacnename/sqllib/spmlog and stuff is still being written to this directory

    I was wondering if this could possibly be part of the problem?

    thanks

    I may need to give you guys some more info, just let me know and I will supply it

    mark

  4. #4
    Join Date
    Jan 2004
    Posts
    12

    Re: db2 seems to crash and not allow connections to the database

    sqloopenp is a generic message which is recorded when db2 is not running ...


    Sathyaram, I have a similar problem with DB2 Connect at a client site. We are getting identical message in the db2diag.log but it is in a continuous loop dumping and the message is displayed over and over.

    We are able to get data back through the DB2 Connect gateway even though we are getting sqloopenp messages. Does that then mean that we are getting data through a DB2 Connect that is not running?

    My client worked with IBM for about 6 months on this and IBM's answer was it was a network problem. Any help you can provide would be much appreciated.

    Chad Breiner

Posting Permissions

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