473,471 Members | 2,017 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

DB2 Crash in the weekend

Any suggestion about this?
DB2 V8.1.5 WorkGroup Edition on Windows Professional 2000.
Thanks.

Message in DB2Diag.log

2004-07-18-16.54.29.479000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:*LOCAL.DB2.00C6C8205429
base sys utilities sqleFirstConnect Probe:100 Database:test

DiagData
0x184B8188 : 0xFFFFFBA3 £ûÿÿ

2004-07-18-16.54.30.292000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:*LOCAL.DB2.00C6C8205430
data protection sqlufrol Probe:980 Database:test

ADM1602W Rollforward recovery has been initiated.

2004-07-18-16.54.30.307000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:*LOCAL.DB2.00C6C8205430
data protection sqlufrol Probe:1210 Database:test

ADM1603I DB2 is invoking the forward phase of the database rollforward
recovery.

2004-07-18-16.54.30.323000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:*LOCAL.DB2.00C6C8205430
recovery manager sqlpForwardRecovery Probe:720 Database:test

Invoking database rollforward forward recovery,
lowtranlsn 0000000784FCE00C minbufflsn 0000000784FCE00C

2004-07-18-16.54.30.370000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:*LOCAL.DB2.00C6C8205430
recovery manager sqlpForwardRecovery Probe:1990 Database:test

nextLsn 0000000784FCE00C

2004-07-18-16.54.30.401000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:*LOCAL.DB2.00C6C8205430
data protection sqlufrol Probe:2120 Database:test

ADM1605I DB2 is invoking the backward phase of database rollforward recovery.

2004-07-18-16.54.30.417000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:*LOCAL.DB2.00C6C8205430
recovery manager sqlpForwardRecovery Probe:2210 Database:test

Invoking database rollforward backward recovery, nextLsn: 0000000784FCE00C

2004-07-18-16.54.30.432000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:1704 Appid:none
data protection sqlpgCallGIFL Probe:1520

New log extent 24281, PId 1090025203, FirstLSN
0x1C3FF81C : 0007 84FC E000 ..„üà.

2004-07-18-16.54.31.245000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:*LOCAL.DB2.00C6C8205430
data protection sqlufrol Probe:8180 Database:test

ADM1611W The rollforward recovery phase has been completed.

2004-07-18-16.59.13.610000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:C0A8644C.E30D.040718205436
PSM - SQL Procedure psm_recover_all_procs Probe:10 Database:test

SQL procedure executables recovery has been initiated.
0x18ABCEFC : 0x202020454E524F4C test

2004-07-18-16.59.13.641000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:C0A8644C.E30D.040718205436
PSM - SQL Procedure psm_recover_all_procs Probe:40 Database:test

Executables not restored because INDEXREC not set to RESTART

2004-07-18-16.59.13.641001 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:C0A8644C.E30D.040718205436
PSM - SQL Procedure psm_recover_all_procs Probe:900 Database:test

SQL procedure executables recovery ended. RC:
0x18ABCEE4 : 0x00000000 ....

2004-07-18-17.00.37.940000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:1700 Appid:none
data protection sqlpghck Probe:1390

ExtNum 24281, state 401, baselsn 0000000784FCE000 nextlsn 000000078502C3DE

2004-07-18-17.00.55.080000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:*LOCAL.DB2.005888210054
database utilities sqlubcka Probe:0 Database:test

Starting a full database backup.

2004-07-18-17.10.07.200000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:284 Appid:*LOCAL.DB2.005888210054
database utilities sqlubcka Probe:130 Database:test

Backup Complete.

2004-07-18-18.22.23.690001 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:1660 Appid:C0A864E7.J904.018FC8212219
buffer pool services sqlbcres Probe:25 Database:test

DiagData
0x1B5EBF68 : 0x000E1F77 w...

2004-07-18-18.22.23.815000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:1660 Appid:C0A864E7.J904.018FC8212219
buffer pool services sqlbcres Probe:1100 Database:test

DIA8426C A invalid page checksum was found for page "".
ZRC=0x86020019ÿ

2004-07-18-18.22.23.831000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:1660 Appid:C0A864E7.J904.018FC8212219
buffer pool services sqlbcres Probe:1100 Database:test

Obj={pool:2;obj:777;type:1} State=x27 Parent={2;777}, EM=2816, PP0=2832

PID:1180 TID:1660 Node:000 Title: SQLB_OBJECT_DESC
0x17FD6A00 : 0200 0903 0200 0903 0100 0000 0004 489D .. ... .......H.
0x17FD6A10 : 593A 0000 0000 0000 000B 0000 0000 0000 Y:..............
0x17FD6A20 : 100B 0000 0201 0000 2700 0000 0000 0000 ........'.......
0x17FD6A30 : 0010 0000 1000 0000 0100 0000 0200 0902 .............. .
0x17FD6A40 : 20C7 3A00 Ç:.

2004-07-18-18.22.23.862000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:1660 Appid:C0A864E7.J904.018FC8212219
buffer pool services sqlbcres Probe:10 Database:test

Important: CBIT Error
0x1B5EBEE4 : 0x00000001 ....

2004-07-18-18.22.23.877000 Instance:DB2 Node:000
PID:1180(db2syscs.exe) TID:1660 Appid:C0A864E7.J904.018FC8212219
buffer pool services sqlbcres Probe:15 Database:test

userByte:
0x1B5EBEE8 : 0x08 .

PID:1180 TID:1660 Node:000 Title: SQLB_PAGE
Dump File:C:\PROGRA~1\SQLLIB\DB2\11801660.000
Nov 12 '05 #1
0 3534

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: AdityaK | last post by:
Is there a way to find Weekend date for a given date using a DB2 query? I see that there are scalar functions such as DAY, DAYOFMONTH, DAYOFWEEK,etc are available...but couldn't find one to get a...
7
by: Jamma | last post by:
Hello, I have an Access 2000 file working on XP machines and a NT network. The files are split and 95% of the time all is well and stable. The main issue arises when the app prints,a novell...
3
by: William Ryan | last post by:
Good evening :), I got out this afternoon and tried to get a bit of X-mas shopping done and a few other things taken care of...not a whole lot of luck, though...tons of people doing the same...
0
by: smellymutant | last post by:
Please could someone supply KB915038 hotfix file - it's the weekend so I can't get hold of MS. Thanks -- --------------------------------- --- -- - Posted with NewsLeecher v3.8 Beta 1 Web @...
2
by: Joey Martin | last post by:
I have a sql database and ASP pages. How do I find out the DATES of THIS WEEKEND (fri-sun). If today is Tuesday, I want to show information posted for THIS WEEKEND. My table has a field...
3
by: subhbhav | last post by:
Hi, Is there any way to get a db2 9.1 Windows UDB database which is in inconsistent state to start without recovery? We were loading data from a source and the database crashed. The Server...
3
by: darnnnel | last post by:
Hey guys, i have this code: SELECT * FROM QueryCases WHERE Weekday(QueryCases.StartDate) In ('1','7') AND QueryCases.Completed = False ORDER BY QueryCases.StartDate; the WHERE...
0
by: Trent Nelson | last post by:
Just a friendly reminder that this weekend is the Python sprint weekend! Look forward to seeing everyone on #python-dev irc.freenode.net over the course of the weekend! Trent. On 16 Apr,...
11
by: =?Utf-8?B?R2VyaGFyZA==?= | last post by:
I have run into a situation that if a page/tab that uses the Ajax toolkit (using .net version 3.5) is closed before the Ajax enable controls complete loading, then IE locks up. Does it in both IE7...
7
by: Mike | last post by:
I have a routine that's calculating business days but its not counting the weekend days that are between the start date and end date. If my start date is 9/26/08 and my end date is 10/01/08, I...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.