473,840 Members | 1,594 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Database Marked Bad

Hello,

In an attempt to save disk space, I went in and gzipped all of the log
files for my database running DB2 version 7.2 . This resulted in the
database being marked bad because a log file was no longer found (I
think).

Here is an excerpt from db2diag.log:

String Title:sqleMarkD Bad: PID:7980 Node:000
Marking the database bad.

2007-05-10-05.44.26.211513 Instance:db2ins t1 Node:000
PID:7980(db2age nt (V1DB)) Appid:C0A80A21. 95D2.0705101242 02
relation_data_s erv sqlrr_signal_ha ndler Probe:10 Database:V1DB
DIA7107I Execution of a component signal handling function has begun.
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:APM COMMON INFO
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:PACKAGE ENTRY
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:USED_IN_UO W BIT
VECTOR
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:Recursive
dump_sect
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:SECTION NUMBER
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:SECTION DIR
ENTRY
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:cache cb

I have a backup that is pretty old and all of the log files so I can
rollforward, but was wondering if there is a way since I actually HAVE
the ability to recover -- it just may take me a while.

Is there a way that I can use the dump files that are mentioned in the
line after the "marking the database bad" error message in order to
make my log file useable again? Every time I attempt to connect to
the database, I get a generic system error:
SQL1042C An unexpected system error occurred. SQLSTATE=58004

It apparently tries to do a crash recovery but fails:
007-05-10-11.37.19.131481 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
base_sys_utilit ies sqledint Probe:0 Database:V1DB

Crash Recovery is needed.

2007-05-10-11.37.19.195627 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpresr Probe:1 Database:V1DB
DIA3908W Crash recovery has been initiated. Lowtran LSN is
"00054BB9D2 A3",
Minbuff LSN is "00054BB9D2 A3".

2007-05-10-11.37.19.200298 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlprecm Probe:125 Database:V1DB

Using parallel recovery with 3 agents 3 QSets 21 queues and 2 chunks

2007-05-10-11.37.19.225329 Instance:db2ins t1 Node:000
PID:29404(db2ag nsc (V1DB)) Appid:C0A80A32. EB88.0705101528 51
data_protection sqlpgrlg Probe:170 Database:V1DB

ThisLsn: 0005 4bb9 d2a3 ..K...

Dump File:/home/db2inst1/sqllib/db2dump/29404.000 Data:SQLP_DBCB

2007-05-10-11.37.19.232828 Instance:db2ins t1 Node:000
PID:29404(db2ag nsc (V1DB)) Appid:C0A80A32. EB88.0705101528 51
data_protection sqlpgrlg Probe:0 Database:V1DB

Error -6899 when reading LSN 0005 4BB9 D2A3 from log file S0001187.LOG

2007-05-10-11.37.19.237101 Instance:db2ins t1 Node:000
PID:29404(db2ag nsc (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpPRecReadLog Probe:50 Database:V1DB
DIA3714C Logging can not continue due to an error.

ZRC=0xFFFFE50D

2007-05-10-11.37.19.315427 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpresr Probe:10 Database:V1DB
DIA3910W Crash recovery completed. Return Code = "-6899"

2007-05-10-11.37.19.316331 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpresr Probe:10 Database:V1DB

ThisLsn: 0005 4bb9 d2a3 ..K...

Dump File:/home/db2inst1/sqllib/db2dump/29404.000 Data:SQLP_DBCB

2007-05-10-11.37.19.232828 Instance:db2ins t1 Node:000
PID:29404(db2ag nsc (V1DB)) Appid:C0A80A32. EB88.0705101528 51
data_protection sqlpgrlg Probe:0 Database:V1DB

Error -6899 when reading LSN 0005 4BB9 D2A3 from log file S0001187.LOG

2007-05-10-11.37.19.237101 Instance:db2ins t1 Node:000
PID:29404(db2ag nsc (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpPRecReadLog Probe:50 Database:V1DB
DIA3714C Logging can not continue due to an error.

ZRC=0xFFFFE50D

2007-05-10-11.37.19.315427 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpresr Probe:10 Database:V1DB
DIA3910W Crash recovery completed. Return Code = "-6899"

2007-05-10-11.37.19.316331 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpresr Probe:10 Database:V1DB

Recovery started on log file: 5330 3030 3131 3837 2e4c
4f47 S0001187.LOG
2007-05-10-11.37.19.320371 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
base_sys_utilit ies sqlesrsu Probe:16 Database:V1DB

DiagData
0de5 ffff ....
2007-05-10-11.37.19.324473 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
base_sys_utilit ies sqlesrsu Probe:16 Database:V1DB

RIDS/sqlesrsu MS/UNK_REC_ERR PRCS/160de5
ffff ....
2007-05-10-11.37.19.328607 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
base_sys_utilit ies sqlesrsu Probe:110 Database:V1DB

Restart failed with sqlcode: eefb ffff
If there is a way to fix the current database, using some of these
dump files, that'd be wonderful. Thanks for any suggestions anyone
has.

Sincerely,

Scott

May 10 '07 #1
2 5425
Scott Jones wrote:
Hello,

In an attempt to save disk space, I went in and gzipped all of the log
files for my database running DB2 version 7.2 . This resulted in the
database being marked bad because a log file was no longer found (I
think).
What happens if you stop the database, unzip the logfiles and start the
db again?

/Lennart

>
Here is an excerpt from db2diag.log:

String Title:sqleMarkD Bad: PID:7980 Node:000
Marking the database bad.

2007-05-10-05.44.26.211513 Instance:db2ins t1 Node:000
PID:7980(db2age nt (V1DB)) Appid:C0A80A21. 95D2.0705101242 02
relation_data_s erv sqlrr_signal_ha ndler Probe:10 Database:V1DB
DIA7107I Execution of a component signal handling function has begun.
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:APM COMMON INFO
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:PACKAGE ENTRY
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:USED_IN_UO W BIT
VECTOR
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:Recursive
dump_sect
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:SECTION NUMBER
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:SECTION DIR
ENTRY
Dump File:/home/db2inst1/sqllib/db2dump/7980.000 Data:cache cb

I have a backup that is pretty old and all of the log files so I can
rollforward, but was wondering if there is a way since I actually HAVE
the ability to recover -- it just may take me a while.

Is there a way that I can use the dump files that are mentioned in the
line after the "marking the database bad" error message in order to
make my log file useable again? Every time I attempt to connect to
the database, I get a generic system error:
SQL1042C An unexpected system error occurred. SQLSTATE=58004

It apparently tries to do a crash recovery but fails:
007-05-10-11.37.19.131481 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
base_sys_utilit ies sqledint Probe:0 Database:V1DB

Crash Recovery is needed.

2007-05-10-11.37.19.195627 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpresr Probe:1 Database:V1DB
DIA3908W Crash recovery has been initiated. Lowtran LSN is
"00054BB9D2 A3",
Minbuff LSN is "00054BB9D2 A3".

2007-05-10-11.37.19.200298 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlprecm Probe:125 Database:V1DB

Using parallel recovery with 3 agents 3 QSets 21 queues and 2 chunks

2007-05-10-11.37.19.225329 Instance:db2ins t1 Node:000
PID:29404(db2ag nsc (V1DB)) Appid:C0A80A32. EB88.0705101528 51
data_protection sqlpgrlg Probe:170 Database:V1DB

ThisLsn: 0005 4bb9 d2a3 ..K...

Dump File:/home/db2inst1/sqllib/db2dump/29404.000 Data:SQLP_DBCB

2007-05-10-11.37.19.232828 Instance:db2ins t1 Node:000
PID:29404(db2ag nsc (V1DB)) Appid:C0A80A32. EB88.0705101528 51
data_protection sqlpgrlg Probe:0 Database:V1DB

Error -6899 when reading LSN 0005 4BB9 D2A3 from log file S0001187.LOG

2007-05-10-11.37.19.237101 Instance:db2ins t1 Node:000
PID:29404(db2ag nsc (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpPRecReadLog Probe:50 Database:V1DB
DIA3714C Logging can not continue due to an error.

ZRC=0xFFFFE50D

2007-05-10-11.37.19.315427 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpresr Probe:10 Database:V1DB
DIA3910W Crash recovery completed. Return Code = "-6899"

2007-05-10-11.37.19.316331 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpresr Probe:10 Database:V1DB

ThisLsn: 0005 4bb9 d2a3 ..K...

Dump File:/home/db2inst1/sqllib/db2dump/29404.000 Data:SQLP_DBCB

2007-05-10-11.37.19.232828 Instance:db2ins t1 Node:000
PID:29404(db2ag nsc (V1DB)) Appid:C0A80A32. EB88.0705101528 51
data_protection sqlpgrlg Probe:0 Database:V1DB

Error -6899 when reading LSN 0005 4BB9 D2A3 from log file S0001187.LOG

2007-05-10-11.37.19.237101 Instance:db2ins t1 Node:000
PID:29404(db2ag nsc (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpPRecReadLog Probe:50 Database:V1DB
DIA3714C Logging can not continue due to an error.

ZRC=0xFFFFE50D

2007-05-10-11.37.19.315427 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpresr Probe:10 Database:V1DB
DIA3910W Crash recovery completed. Return Code = "-6899"

2007-05-10-11.37.19.316331 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
recovery_manage r sqlpresr Probe:10 Database:V1DB

Recovery started on log file: 5330 3030 3131 3837 2e4c
4f47 S0001187.LOG
2007-05-10-11.37.19.320371 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
base_sys_utilit ies sqlesrsu Probe:16 Database:V1DB

DiagData
0de5 ffff ....
2007-05-10-11.37.19.324473 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
base_sys_utilit ies sqlesrsu Probe:16 Database:V1DB

RIDS/sqlesrsu MS/UNK_REC_ERR PRCS/160de5
ffff ....
2007-05-10-11.37.19.328607 Instance:db2ins t1 Node:000
PID:17871(db2ag ent (V1DB)) Appid:C0A80A32. EB88.0705101528 51
base_sys_utilit ies sqlesrsu Probe:110 Database:V1DB

Restart failed with sqlcode: eefb ffff
If there is a way to fix the current database, using some of these
dump files, that'd be wonderful. Thanks for any suggestions anyone
has.

Sincerely,

Scott
May 11 '07 #2


If you have a backup copy of your database before the problem, you
may restore the backup copy..
If you dont, check with system restore(in case of windows..) you can
take backup copy and restore it !

@Ekta.

May 14 '07 #3

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

Similar topics

2
2937
by: lawrence | last post by:
A very strange bug. www.monkeyclaus.org is run by a cms I'm developing. One of types of users we allow is "justTestingTheSite", a type of user I developed to give demo's to prospective clients. The purpose of this level of security is to let someone log in and see everything as if they were root, and yet not be able to update or delete anything, as they have no real priveledges at all. I just logged in as root and created such an...
6
1858
by: kurotsuke | last post by:
Hi, I restored my Windows XP system and discovered that I cannot access a MSDE DB that was saved in D: drive (I restored my primary partition in C). How can I restore it? Thanks a lot.
62
4135
by: SAN3141 | last post by:
There doesn't seem to be consensus about when to put code in the database or in the middle tier. There was a long discussion about this in an Oracle newsgroup (message ID: ULcQb.466$KU5.37@nwrddc02.gnilink.net). Elsewhere there's been discussion about Microsoft SQL Server 2005 adding the CLR to support stored procedures in languages such as C#. A scan of the Web and discussion forums finds differing opinions about this.
1
3659
by: Mark Barinstein | last post by:
Hello. W2k, db2 wse v8.1.4. Here is ddl that creates small test database (3 tables and 1 view). (i can't attach zip file with ixf files and loading script - it has ~ 1.3MB size, but if anybody want to get it i can download it on your site, mail me to __mark(at)mail.ru). --- CREATE DATABASE TEST ON C:;
5
3604
by: Mark Barinstein | last post by:
Hello. db2v8 fp3 or fp4. ftp://adm-gw.vsi.ru/pub/db2v8crash/files.zip In this zip file (~1.4M) there are: 1. script for creating a small test database with 3 tables and 1 view. 2. 3 ixf files and loading script for loading these 3 tables. 3. file with select statement that makes this test db bad.
3
2774
by: Nitin | last post by:
I am using access database for my application, whenever I insert records the size of the data base increases, But when I delete the records the database size does not decrease. What is the problem??? ThanX Nitin
3
10299
by: Martin B | last post by:
Hallo! I'm working with C# .NET 2.0, implementing Client/Server Applications which are connecting via Network to SQL-Server or Oracle Databases. To stay independent from the underlaying Database I use System.Data.Common.DBConnection and .DBCommand. How can I keep aware from connection losses (network not availeable, db-server not available...)? Are there any strategies to detect this broken connections, and how can I
25
2572
by: Colin McKinnon | last post by:
Hi all, There's lots of DB abstraction layers out there, but a quick look around them hasn't turned up anything which seems to met my requirements. Before I go off and write one I thought I'd ask here if anyone knows of such a beast... I want some code where I present an array of data, and the corresponding primary key and let the code work out whether to INSERT or UPDATE it, I also want to be able to present the data from a QBF or...
0
3451
by: Fausto Guerini | last post by:
On my Microsoft sql server 2000 i have a database named Lp marked suspect, the last backup il long time ago so i'm trying to recover the current database. The start up log of sql is: An error occurred while processing the log for database 'Lp' I've also tried dbcc CHECKDB ('lp') and got the answer: Server: Msg 945, Level 14, State 2, Line 1 Database 'Lp' cannot be opened due to inaccessible files or insufficient memory or disk space. ...
0
9861
marktang
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...
0
9699
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,...
0
10605
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 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...
0
10301
tracyyun
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...
0
9444
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7839
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 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...
0
5685
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...
2
4078
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3139
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.