?
Solved

My db2 database crashed last night

Posted on 2010-08-19
7
Medium Priority
?
1,702 Views
Last Modified: 2012-05-10
HiAll.
My db2 database crashed last night is it to do with the disk full or locking issue;My error log is:

2010-08-18-18.19.13.481000+060 I131553H601        LEVEL: Severe
PID     : 6780                 TID  : 3136        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : CDB
APPHDL  : 0-990                APPID: 192.168.0.35.31236.100814040042
AUTHID  : PCMS_DATA_MANAGER
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1141
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
          DIA8312C Disk was full.
DATA #1 : <preformatted>
Failed to read page from disk on attempt number 2.
Retrying operation. Only subsequent failures will be logged.
 
2010-08-18-18.19.13.497000+060 I132156H387        LEVEL: Error
PID     : 6780                 TID  : 1812        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
          DIA8511C A locked file was encountered.
 
2010-08-18-18.19.13.544000+060 I132545H2385       LEVEL: Severe
PID     : 6780                 TID  : 1812        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x13744A04 : 0301 0000 0000 0000 0080 3900 0000 0000    ..........9.....
0x13744A14 : 0000 0000 0000 0000 947C 576E 6088 900E    .........|Wn`...
0x13744A24 : E049 7413 0000 0000 4431 7413 00C0 F70E    .It.....D1t.....
0x13744A34 : 0010 0000 500F 0000 0000 0000 90E0 7F02    ....P...........
0x13744A44 : 0000 0000 0200 0000 0E00 0F87              ............
0
Comment
Question by:hraja77
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 1

Author Comment

by:hraja77
ID: 33473139
can the disk full cause db2 to crash ?
0
 
LVL 4

Expert Comment

by:gmarino
ID: 33476689
This is the same issue you had before that you posted in ID: 26405595

The error suggests that there is another process locking the database files - this time the file is the one that contains your data instead of the file used for Logging.  This could occur when using
a)  Virus Checking software - in which case you need to make sure the  folder defined in LOGPATH is excluded from the RealTime virus checking  process AND blocked from use from any other user other than the db2  instance/admin id
-OR-
b) Backup software where the software locks the file while it is taking a back up of the file.

For more information on this issue and how to resolve it, read this:

http://www-01.ibm.com/support/docview.wss?uid=swg21225179


You obviously need to get this 3rd Party software problem resolved.

- Greg
0
 
LVL 4

Accepted Solution

by:
gmarino earned 2000 total points
ID: 33476712
Sorry - cut-n-past error above...here's what I should have posted:


This could occur when using
a)  Virus Checking software - in  which case you need to make sure the  folder where the database's tablespace containers are defined in is  excluded from the RealTime virus checking  process AND blocked from use  from any other user other than the db2  instance/admin id
-OR-
b) Backup software where the software locks the file while it is taking a back up of the file.

- Greg
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 1

Author Comment

by:hraja77
ID: 33483114
thanks greg - i appreciate what your saying its just that the sysadmins did not exclude all the files for o/s backups - they have done that as of today - i just want to check one point before assiging points - can the disk full error message above cause a db crash ?
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
          DIA8312C Disk was full.

thanks
H
0
 
LVL 1

Author Comment

by:hraja77
ID: 33483130
i'll assign the points anyway as you have been very helpfull - so thanks for that - but i would appreciate an answer to the comment about the disk full error above

thanks
H
0
 
LVL 1

Author Closing Comment

by:hraja77
ID: 33483133
thanks
0
 
LVL 4

Expert Comment

by:gmarino
ID: 33487123
It seems that in THIS case, DB2 crashed.  But that was due to the LACK OF ACCESS to the file, not because the disk was full.  (FILE LOCKED behaves similar to DISK FULL.)

In this case it seems the BufferPool's IO Cleaners (sqlbClnrAsyncWriteCompletion) could not write "dirty" pages (pages with changes to the data on them) out to the tablespace's files/containers.  

I can see how thissituation would cause DB2 to crash - if the Bufferpool's space was needed for another SQL process and those BP pages could not be accessed because they contained data that needed to be first written to disk before they could be reused.

- Greg
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question