473,659 Members | 2,934 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can't connect to database, missing log files

4 New Member
Hi all

Our server (DB2 UDB 9.1 fp4) crashed earlier today while running a job, after a reboot everything looked fine again, except that now the database is no longer accessible. The log files are missing in SQLOGDIR and I'm unable to restore them.

The error I'm getting is this one:

[IBM][CLI Driver] SQL1036C An I/O error occurred while accessing
the database. SQLSTATE=58030

Only solution I could find was to do a database restore which I'm not very keen on doing, since it's gonna rollback 5 days and I've done alot of work on the database the past few days.

Please tell me there is a way to force DB2 to ignore or recreate those logs so we can connect to the database again.

On a side note, I'm not very experienced with DB2, so be gentle :)

Thanks in advance
Jimmi
Mar 27 '08 #1
2 11931
SuperKuper
7 New Member
Call IBM - I recall they have a way to bypass crash recovery on startup. You send them one of the control files, they change it and send back to you. In the future you may want to consider using "mirror" logs.
Apr 5 '08 #2
Shashank1984
26 New Member
In this case you need to provide us/IBM SQLOGCTL.LFH.
Lemme give you what it's about ...
Resetting the SQLOGCT.LFH is a task which, allow you to connect to the
Database. We expect that you WILL export the data and REBUILD the
database via data imports. The reset is only done in cases where
customer do not have any backups and associated logs for roll forward.

In a reset of the LFH file we are essentially tricking the Database,
i.e. we change the consistency status to YES, and we also not look for
any transaction logs (Normally during crash recovery all the
transactions in active log files are read for replay purposes and they
should be available). So in essence we bypass crash recovery and
compromise with the database integrity.

Thanks,
Shashank Kharche
Apr 15 '08 #3

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

Similar topics

1
3498
by: webhead74 | last post by:
Hi, I've worked on this for a couple of days & can't figure out what I'm doing wrong. I'm trying to connect to a remote AS400 database using odbc & php. Here's my environment: Server: RedHat ES 2.1 IBM HTTP Server (was pre-built by IBM): Server version: IBM_HTTP_Server/2.0.47.1 Apache/2.0.47
0
3284
by: Ian | last post by:
Dear All, I just downloaded & installed MYSQL. It seemed to work and I can start it and enter my password and change a directory but that is about all. I have been ready and playing "hit & miss" all afternoon and it seems to have something to do with the "mysql_install_db" not being installed correctly -- I have tried multiple installs with multiple downloaws. My log. . .
4
4950
by: MJ | last post by:
I am using the following script to connect but keep getting <?php $conn = mysql_connect("", "mjohn", ""); mysql_select_db("testDB",$conn); ?> but keep getting this error Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\test.php on line 2
10
6454
by: Andy K | last post by:
Hi again , I've been trying to connect to a distant database with my control center on WinXp . I'm using a personnal edition DB2 v8.1.9.700 for the control center on WinXp. I've setup a node (a distant connection ) in order to reach this distant database but it doesn't seem to work ... The distant database
4
1649
by: sparks | last post by:
We have a database that reads in and formats raw data. We were using queries to format the data per person and outputing reports. The other database has the persons personal information. I changed the queries on the raw data to maketables, copied the reports into the personal info database and they have the reports from the raw data available for the reports. NOW they want the reports to be displayed as a new tab in the forms. I am not...
9
1729
by: Piccolo Pete | last post by:
This is a bit "wordy", but here is the scoop. I'm using Microsoft Visual Studio for VC++ in Windows 2000. I made an application which had no form in it. So when I ran the application, I just got a DOS box that showed some progress info. I then decided to add a form... So I made a new application and started with creating the form. Then I copied and pasted cpp code into places where I thought they should go - leaving out the stuff...
2
1306
by: mr_doles | last post by:
I am writing a Database application using Visual Studio 2005 and SQL Server Express 2005. I am trying to create a back up and year end back up plan within the program. The folder structure I want is as follows: The main level is c:\program files\app name\database with the following subfolders, 1) current - holds the current db (db.mdf), 2) backup - holds the backed up databases (db1.bak) and 3) archive - holds the year end...
1
2271
by: KayC | last post by:
Hi I use Access2002 I have created a simple form with 3 parameter UserID, Password & Database When a user enters values into these text boxes a passthrough query to a Sybase database is envoked with the connection string set to the form parameters My problem is that when an invalid username, password or database string is entered the passthrough query still works even though looking at the connect property this has changed to the form...
2
2092
by: =?Utf-8?B?UGFvbG8=?= | last post by:
Hope someone can help with this problem... Using SQL Server Express 2008 and SQL Server Management Studio Express 2008 running on a desktop PC. When I try to add a database via Management Studio there is no problem, the database appears in the Explorer. In Visual C# Express, when I try to 'Add Connection' as follows
0
8332
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
8746
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...
1
8525
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,...
0
7356
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
6179
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
5649
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();...
0
4175
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...
0
4335
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1975
muto222
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.