Solved

My db2 database crashed last night

Posted on 2010-08-19
7
1,540 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
  • 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 500 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

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 (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now