DB2 Crash in the weekend

richardshen

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(db2sys cs.exe) TID:284 Appid:*LOCAL.DB 2.00C6C8205429
base sys utilities sqleFirstConnec t Probe:100 Database:test

DiagData
0x184B8188 : 0xFFFFFBA3 £ûÿÿ

2004-07-18-16.54.30.292000 Instance:DB2 Node:000
PID:1180(db2sys cs.exe) TID:284 Appid:*LOCAL.DB 2.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(db2sys cs.exe) TID:284 Appid:*LOCAL.DB 2.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(db2sys cs.exe) TID:284 Appid:*LOCAL.DB 2.00C6C8205430
recovery manager sqlpForwardReco very Probe:720 Database:test

Invoking database rollforward forward recovery,
lowtranlsn 0000000784FCE00 C minbufflsn 0000000784FCE00 C

2004-07-18-16.54.30.370000 Instance:DB2 Node:000
PID:1180(db2sys cs.exe) TID:284 Appid:*LOCAL.DB 2.00C6C8205430
recovery manager sqlpForwardReco very Probe:1990 Database:test

nextLsn 0000000784FCE00 C

2004-07-18-16.54.30.401000 Instance:DB2 Node:000
PID:1180(db2sys cs.exe) TID:284 Appid:*LOCAL.DB 2.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(db2sys cs.exe) TID:284 Appid:*LOCAL.DB 2.00C6C8205430
recovery manager sqlpForwardReco very Probe:2210 Database:test

Invoking database rollforward backward recovery, nextLsn: 0000000784FCE00 C

2004-07-18-16.54.30.432000 Instance:DB2 Node:000
PID:1180(db2sys cs.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(db2sys cs.exe) TID:284 Appid:*LOCAL.DB 2.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(db2sys cs.exe) TID:284 Appid:C0A8644C. E30D.0407182054 36
PSM - SQL Procedure psm_recover_all _procs Probe:10 Database:test

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

2004-07-18-16.59.13.641000 Instance:DB2 Node:000
PID:1180(db2sys cs.exe) TID:284 Appid:C0A8644C. E30D.0407182054 36
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(db2sys cs.exe) TID:284 Appid:C0A8644C. E30D.0407182054 36
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(db2sys cs.exe) TID:1700 Appid:none
data protection sqlpghck Probe:1390

ExtNum 24281, state 401, baselsn 0000000784FCE00 0 nextlsn 000000078502C3D E

2004-07-18-17.00.55.080000 Instance:DB2 Node:000
PID:1180(db2sys cs.exe) TID:284 Appid:*LOCAL.DB 2.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(db2sys cs.exe) TID:284 Appid:*LOCAL.DB 2.005888210054
database utilities sqlubcka Probe:130 Database:test

Backup Complete.

2004-07-18-18.22.23.690001 Instance:DB2 Node:000
PID:1180(db2sys cs.exe) TID:1660 Appid:C0A864E7. J904.018FC82122 19
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(db2sys cs.exe) TID:1660 Appid:C0A864E7. J904.018FC82122 19
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(db2sys cs.exe) TID:1660 Appid:C0A864E7. J904.018FC82122 19
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_DES C
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(db2sys cs.exe) TID:1660 Appid:C0A864E7. J904.018FC82122 19
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(db2sys cs.exe) TID:1660 Appid:C0A864E7. J904.018FC82122 19
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\11 801660.000

Nov 12 '05 #1

Subscribe Reply

3580

Similar topics

13454

Weekend date for given a date

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 weekend date for any given date. Any information is appreciated. Thanks, Aditya.

DB2 Database

1681

netware popup causing access to crash?

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 netware pop up shows and declares which printer the file is going to and when printing completes, Access crashes. This is really starting to tick off the client users. I see that there may be two possible solutions - first, I have some way of...

Microsoft Access / VBA

1806

David's Plan for next weekend?

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 thing I was. But I just got in a bit ago. I take it you are still in a hotel this weekend? I hate that...I was really hoping you would be home this weekend. But oh well, you have to do what you have to do, I guess...:) I am not what you would call...

C# / C Sharp

1305

req kb915038 (Visual Studio 2005 hotfix - compiler crash bug)

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 @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- -

.NET Framework

1764

Weekend dates

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 called THEDATE which is what we need to search and in the format MM/DD/YYYY. Thanks!

ASP / Active Server Pages

4980

Recovering from a DB2 Crash

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 was restarted after this. DB2 has completed the forward phase of crash recovery but the rollback phase is taking time. We are using circular logging.

DB2 Database

1911

Set criteria to find date records for this coming weekend

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 Weekday(QueryCases.StartDate) In ('1','7') returns any weekend records, how do i set criteria to only show weekend records for this coming weekend. Thanks in advance

Microsoft Access / VBA

979

REMINDER: Python Sprint Weekend This Weekend!

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, 18:52, Trent Nelson wrote:

Python

3050

Ajax and IE crash

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 and IE8. There is no issue when the controls are allowed to complete loading. Can you please tell me the best practice that handles this? Thanks.

ASP.NET

3222

count days including weekend

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 should see 4 business days and 2 weekend days. How can I get that result? I'm getting 4 business days but its not counting the weekend days?

C# / C Sharp

9521

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9333

Changing the language in Windows 10

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9945

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9900

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9765

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7324

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6599

Couldn’t get equations in html when convert word .docx file to html file in C#.

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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5214

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5361

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET