473,411 Members | 1,880 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,411 software developers and data experts.

Database Crash : Need some urgent help

Hi,

I faced a DB2 database crash because of the fact that the "home" directory was full.

I modified the log file path, but the message I got was: -->
SQL2161N : A damaged recovery history file could not be fixed. The specified action failed.

Please let me know how to take care of this.
It's a bit urgent.

Thanks so much!!!
Sarada Prasanna.
Feb 1 '08 #1
4 4222
docdiesel
297 Expert 100+
Hi,

with db2 error SQL2161N look for the files db2rhist.asc and db2rhist.bak of that crashed database. Try to
  1. rename db2rhist.asc to db2rhist.asc.in.doubt (to have it saved anyway)
  2. copy db2rhist.bak to db2rhist.asc
Maybe afterwards the db starts again. Be aware that with using a copy of the .bak file you may loose some of the information about administrative operations on the database (like backup or restore).

If both files are corrupted, then just perform step 1. Another way around this may be restoring the database from a backup but into a different database. Afterwards copy the db2rhist.asc from that restored db as step 2.

Good luck,

Bernd
Feb 2 '08 #2
Well, since the home directory is full, DB2 on my server has come to a standstill.
Please let me know what to do.
Now, I get the below error while accessing the database.

SQL22204N The DB2 Administration Server encountered a non-severe error while executing a request.

Please let me know what can be done on this.

Thanks,
Sarada Prasanna.
Feb 4 '08 #3
docdiesel
297 Expert 100+
Hi,

it's hard to tell what to do if the environment is unknown. Please let us know your OS, the DB2 version etc.

Most of all, give some space to your home directory! If you ran into full /home twice already, there's significantly something wrong with your partitioning, and you'll get a wide variety of colourful errors when /home runs full again.

Regards,

Bernd
Feb 5 '08 #4
DB2 v9.1,
OS: Linux(RHEL)
Feb 5 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: V.Balaji | last post by:
Hi All, I have a problem in one of the windows service which is created using .net. The Service frequently stops and there is no entry in the Event Log for a crash please help me in sorting. I...
15
by: Trapulo | last post by:
Very often my VS2005 pro crashes after a debug. I run ASP.NET debug, and all works well. Then I stop it, and all it's also ok. Then, when I try to edit some code, it crashes and I need to kill it,...
5
by: igotyourdotnet | last post by:
I'm trying to add a web part to my page and when I run my page with the web part I get this error: An error has occurred while establishing a connection to the server. When connecting to SQL...
2
by: Scott Jones | last post by:
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...
12
by: grace | last post by:
i am wondering why my database retrieval becomes too slow...we set up a new server (ubuntu, breezy badger) machine where we transferred all our files from the old server.. Our new server uses Asus...
9
by: star-italia | last post by:
Hi, I have a big problem: I am developing a WPF application on Windows Vista SP1 Based on the .NET Framework 3.5 and WPF. In my application I use a WIndowsFormsHost to (of course) host a...
7
by: =?Utf-8?B?TWF4R3J1dmVu?= | last post by:
I have a DLL that implements the Business and Data Layers for a number of different websites. That DLL uses a Strongly Typed DataSet to interface to the Data Source which is SQL Server. There...
9
by: =?Utf-8?B?TUNN?= | last post by:
I'm sure the answer to my question varies depending on the situation, but I am looking for a general "best practice". If I have an asp.net application and I load certain data from a database,...
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...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
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
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...
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,...
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...

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.