Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2003
    Posts
    2

    Unanswered: Database is getting shutdown frequently

    Hay All,

    My DB2 database is going frequenctly down. What may be the reason?

    I am getting the following message from services

    "The DB2 - DB2-0 service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 0 milliseconds: No action. "

    But I am not able to start this service also and needs to restart my server box.

    Please let me know why this is happening ?

    Thanks in Advance.

    Karthik.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    This is punishment for not reading the "Read Me: Must Read before posting thread.

  3. #3
    Join Date
    Sep 2002
    Posts
    456

    Re: Database is getting shutdown frequently

    Hi Karthi:

    Please provide some information about your operating system, db2 version and fix pak and some sort of log content if any. It's hard to help without any specific information.

    dollar

    Originally posted by karthi_keyand
    Hay All,

    My DB2 database is going frequenctly down. What may be the reason?

    I am getting the following message from services

    "The DB2 - DB2-0 service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 0 milliseconds: No action. "

    But I am not able to start this service also and needs to restart my server box.

    Please let me know why this is happening ?

    Thanks in Advance.

    Karthik.

  4. #4
    Join Date
    Jul 2003
    Posts
    2

    Re: Database is getting shutdown frequently

    Hai dollar,

    I am using DB2 UDB "DB2 v8.1.0.36" for windows 2000 32 bit with fixpack 0, It is a trial version downloaded from IBM site.

    Whenever I am trying to call some procedures, server is going down.
    but most of procedures it is responding fine.

    I have checked db2diag.log file, but there is no information related to shutdown.

    Thanks in Advance.

    - Karthik.


    Originally posted by dollar489
    Hi Karthi:

    Please provide some information about your operating system, db2 version and fix pak and some sort of log content if any. It's hard to help without any specific information.

    dollar

  5. #5
    Join Date
    Sep 2002
    Posts
    456

    Re: Database is getting shutdown frequently

    I haven't worked much with V8 but heard that going to latest fixpak will resolve most of your issues. The download for fixpak is free and their installation on windows is plain and simple. Try that and see if you still having the same problem. Here is the link:

    http://www-3.ibm.com/cgi-bin/db2www/...ist.d2w/report

    dollar

    Originally posted by karthi_keyand
    Hai dollar,

    I am using DB2 UDB "DB2 v8.1.0.36" for windows 2000 32 bit with fixpack 0, It is a trial version downloaded from IBM site.

    Whenever I am trying to call some procedures, server is going down.
    but most of procedures it is responding fine.

    I have checked db2diag.log file, but there is no information related to shutdown.

    Thanks in Advance.

    - Karthik.

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't know if you are interested, but the DB2 for Windows Fixpaks (V8) can be installed directly without the base code having been installed. Obviously, they can also be installed over the base code and any previous fixpaks. I believe this option is only available for the DB2 for Windows platform.

Posting Permissions

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