473,320 Members | 1,949 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,320 software developers and data experts.

Starting DB2 unix when Log Files Accidently Deleted

I was doing a redirected restore in test from a backup of a prod DB. The application was stopped for the restore, the restore was to a DB called ABC.

I deactivated the ABC DB, and went to delete the logs files. I cut & paste the log location from a comment in the restore redir job by mistake and it had the wrong DB name in it, so I ended up deleting the log files for DB ABC2. Now that DB is dead :(

Is the only solution to restore the ABC2 DB?

Since there was no activity on the DB whose logs I deleted isn't there some way to get DB2 to create a new log file and go forward?

We never do roll forward restores, so we don't need the logs I deleted for restores.
Feb 23 '18 #1
2 2821
Luuk
1,047 Expert 1GB
Is the error the same as given here?:
https://bytes.com/topic/db2/answers/...sing-log-files
Feb 25 '18 #2
Similar. We had to restore the DB we hadn't planned on restoring. I don't like this process of manually deleting the log files, which seams extremely risky. I'm finding it hard to believe this is IBM's design to manually delete the transaction log files to do a restore but I'm new to DB2 on Unix and never did this on mainframe (where all my experience is).
Feb 26 '18 #3

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

Similar topics

0
by: Mike VB | last post by:
I am having trouble backing up 2 files. They are: enterprisesec.config.cch.xxxx.xxxxxxxxx and security.config.cch.xxxx.xxxxxxxxx. Can these files be safely deleted? When I try to view the security...
3
by: Jerry Sievers | last post by:
Hello. I have session files stored in a special tmp directory specific to a virtual host instance. The Max_lifetime is long 86400 (1 day) which I don't suppose is the problem. Anyway the...
1
by: khan | last post by:
I want QTY on hand to be updated when record in detail sale is deleted. can any one help
1
by: Henry Stock | last post by:
I am not really sure what news group this should be posted to. It has to do with a visual studio install project for a c# application. We have noticed that if any of the files installed by the...
3
by: anand.ba | last post by:
Hi, I need to port some C code from UNIX SGI to Windows (MS VC++ compiler). The following header files arent available in windows: #include <sys/param.h> #include <sys/ioctl.h> #include...
14
by: DavidOwens | last post by:
Hi there everybody iv designed a database, curently when the delete button is pushed, it deletes the record completly, but i dont want that i want it to just disable the dispenser. iv crreated,...
4
by: CoRrRan | last post by:
I would like to know how I can check, prior to opening a textfile, for DOS/UNIX/MAC formatting of the file. Is there a way to do this, or is it impossible? Thx, CoRrRan
3
by: Benry | last post by:
Without having a reference to a specific folder, is there a way that Windows fires an event when files in a folder are modified? I'm using C++.NET 2.0 for programming a service, and would like...
2
osward
by: osward | last post by:
Hi, everyone, When I want to delete a table from a database today, I accidently click drop button from phpmyadmin and the database was gone without a normal confirmation to delete message. Is...
17
computerfox
by: computerfox | last post by:
Hello everyone, I'm losing my mind with this current situation and was wondering if anyone could shed some light on this subject. i have a computer that had a virus. the documents were either...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.