Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2014
    Posts
    3

    Unanswered: The database is damaged. All applications processing the database have been stopped

    Dear pro

    I had an issue for my DB Server

    Yesterday our Db2 server had a problem. One Table locked as below



    HTML Code:
    		  Agent        Object              Lock     Object     Lock       Lock     Is      Locked   Tablespace                                  
                      Id(State)    Name                Mode     Type       Status     Count    Blocker By       Name                                        
                      ------------ ---------------------------------------- -------- ---------- ---------- -------- ------- -------- ------------------------------              
                          23325(*) DWH.ABC[2]           Z        Table part Granted        1785      No        - STAGING_201306                              
                          23325(*) DWH.ABC              Z        Table      Granted        1785      No        - -                                           
                          23325(*) DWH.ABC[18]          Z        Table part Granted        1785      No        - STAGING_201306                              
                          23325(*) DWH.ABC[27]          Z        Table part Granted        1785      No        - STAGING_201306                              
                          23325(*) DWH.ABC[36]          Z        Table part Granted        1785      No        - STAGING_201306                              
                          23325(*) DWH.ABC[45]          Z        Table part Granted        1785      No        - STAGING_201306                              
                          23325(*) DWH.ABC[159]         Z        Table part Granted        1785      No        - STAGING_201311                              
                          23325(*) DWH.ABC[54]          Z        Table part Granted        1785      No        - STAGING_201306                              
                          23325(*) DWH.ABC[249]         Z        Table part Granted        1785      No        - STAGING_201402                              
                          23325(*) DWH.ABC[168]         Z        Table part Granted        1785      No        - STAGING_201311                              
                          23325(*) DWH.ABC[63]          Z        Table part Granted        1785      No        - STAGING_201308                              
                          23325(*) DWH.ABC[258]         Z        Table part Granted        1785      No        - STAGING_201402                              
                          23325(*) DWH.ABC[177]         Z        Table part Granted        1785      No        - STAGING_201311                              
                          23325(*) DWH.ABC[72]          Z        Table part Granted        1785      No        - STAGING_201308                              
                          23325(*) DWH.ABC[267]         Z        Table part Granted        1785      No        - STAGING_201402                              
                          23325(*) DWH.ABC[186]         Z        Table part Granted        1785      No        - STAGING_201312                              
                          23325(*) DWH.ABC[81]          Z        Table part Granted        1785      No        - STAGING_201308                              
                          23325(*) DWH.ABC[276]         Z        Table part Granted        1785      No        - STAGING_201403                              
                          23325(*) DWH.ABC[195]         Z        Table part Granted        1785      No        - STAGING_201312                              
                          23325(*) DWH.ABC[90]          Z        Table part Granted        1785      No        - STAGING_201308                              
                          23325(*) DWH.ABC[285]         Z        Table part Granted        1785      No        - STAGING_201403                              
                          23325(*) DWH.ABC[294]         Z        Table part Granted        1785      No        - STAGING_201403                              
                          23325(*) DWH.ABC[1]           Z        Table part Granted        1785      No        - STAGING_201306                              
                          23325(*) DWH.ABC[17]          Z        Table part Granted        1785      No        - STAGING_201306                              
                          23325(*) DWH.ABC[26]          Z        Table part Granted        1785      No        - STAGING_201306                              
                          23325(*) DWH.ABC[35]          Z        Table part Granted        1785      No        - STAGING_201306                              
                          23325(*) DWH.ABC[44]          Z        Table part Granted        1785      No        - STAGING_201306          
    And this cause a serious issue. Any sessions not only perform DML also Select didn’t work, log was:

    Error 4/21/2014 4:12:16 PM 0:00:00.253 DB2 Database Error: ERROR [58031] [IBM][DB2/LINUXX8664] SQL1034C The database is damaged. All applications processing the database have been stopped. SQLSTATE=58031

    OS: Linux 2.6.18-194.el5 x86_64
    DB: DB2 v9.7.0.4
    Fix Pack: 4

    DB create FODC_DBMarked... folder, but im not familiar with this.
    Anyone had this before ? please advise me anything to find out more informate ? what's root cause?

    Many thanks

  2. #2
    Join Date
    Apr 2012
    Posts
    156
    Normally you receive the SQL1034C when there is a hardware failure, or someone removes db2's underlying files etc. At least that has been the case for me. First thing I would do is make sure all your file systems are there, then try a restart database. If that does not work you ware probably going to end up restoring your database. Whenever I am in your situation I basically plan on restoring the db. Take a look at the following link:
    IBM How to troubleshoot an SQL1034C The database is damaged... message - United States

  3. #3
    Join Date
    Apr 2014
    Posts
    3
    Thanks your reply Azready .

    At this time, i have tried this one

    tail -100000 db2diag.log | grep bad ---> to find out something in your concern ( like DIA8400C A bad page was encountered)

    But the result was nothing to return. So, do you think this issue still relate to cause
    "The most common cause of this problem is a disk subsystem hardware problem" ?

  4. #4
    Join Date
    Apr 2012
    Posts
    156
    Will the database start? If so I would do the following:
    1. rename the diag log
    2. Start the db
    3. Check the diag log for any errors, page through it since it should be small
    4. Run a list tablespaces looking for any non-zero conditions.

    If the db will not start you can run a db2dart or restore it. From the sounds of it you have been down for a bit so might be just as easy to restore and be done with it.

  5. #5
    Join Date
    Apr 2014
    Posts
    3
    Quote Originally Posted by azready View Post
    Will the database start? If so I would do the following:
    1. rename the diag log
    2. Start the db
    3. Check the diag log for any errors, page through it since it should be small
    4. Run a list tablespaces looking for any non-zero conditions.

    If the db will not start you can run a db2dart or restore it. From the sounds of it you have been down for a bit so might be just as easy to restore and be done with it.
    Thanks your advise.

    Our DB has started. But db2stop didn't work, we have used db2_all db2_kill for this situation

    Im focus in folder: FODC_DBMarked.... Did you try to look at this before ?

Posting Permissions

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