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

Create DB2 LOGS

Hi!

Is there a command that I can issue to create transaction logs prior to
connecting to the database? The connect itself can be a lengthy operation
if you have large transaction logs. :))

Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Mar 21 '07 #1
3 1329
Gregor Kovač wrote:
Hi!

Is there a command that I can issue to create transaction logs prior to
connecting to the database? The connect itself can be a lengthy operation
if you have large transaction logs. :))
Would the ACTIVATE DATABASE command be the right thing for you?

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Mar 21 '07 #2
Knut Stolze wrote:
Gregor Kovač wrote:
>Hi!

Is there a command that I can issue to create transaction logs prior to
connecting to the database? The connect itself can be a lengthy operation
if you have large transaction logs. :))

Would the ACTIVATE DATABASE command be the right thing for you?
Yes, it does sound promising. :)
If it also creates transaction logs if I issue ACTIVATE DATABASE right after
RESTORE then it is the right thing.

Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Mar 21 '07 #3
Gregor Kovač wrote:
Knut Stolze wrote:
>Gregor Kovač wrote:
>>Hi!

Is there a command that I can issue to create transaction logs prior to
connecting to the database? The connect itself can be a lengthy
operation if you have large transaction logs. :))

Would the ACTIVATE DATABASE command be the right thing for you?

Yes, it does sound promising. :)
If it also creates transaction logs if I issue ACTIVATE DATABASE right
after RESTORE then it is the right thing.
Yes, it does. ACTIVATE pretty much does everything explicitly what is done
implicitly during the first connect to the database.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Mar 21 '07 #4

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

Similar topics

5
by: yongsing | last post by:
I tried to create an index on a column of a table. It failed because the creation caused the transaction log to be full. What can I do? Should I export out the data in the table, then recreate the...
6
by: paul | last post by:
Hi, i made an attempt to restore a online backup made with include logs option. But when i rollforward the db, i can't pout it online because it always ned log file. I tried the option to...
9
by: Marc Miller | last post by:
Hi all, I have 2 dev. machines, the 1st is Win 2000 with .NET 7.0 and the 2nd is XP Pro with .NET 2003. My Web Server is Win 2000 Server with IIS 5.0. I can create a new project on my test...
2
by: dayjah | last post by:
Hi, We are in the process of setting my mysql replication on mysql ver 4.1.18. However we have noticed an odd bug that occurs every so often. Every hour we issue flush logs to mysql so that we...
2
by: rcamarda | last post by:
With help of others on this group, I've been learning and researching about indexes; an area I neglected. I see I can specify which filegroup I wish to create an index, which the default is...
4
by: aj | last post by:
DB2 LUW v8.2 FP 14 RHAS 2.1 I have a DB2 online DB backup that was done w/ the INCLUDE LOGS option. I am interested in restoring that backup, and rolling forward ONLY the logs contained in the...
4
by: madzambonis | last post by:
Here is the situation.... We have Primary Server A linked to Standby Server B via HADR. Primary Server A has recently installed LOGARCHMETH1 to archive logs and a 2nd homegrown script that...
2
by: Jabba | last post by:
I am ripping my hair out here trying to do something on a SQL Server 2000 box using TSQL that is a breeze in SQL 2005 but I can't make it work. I am trying to do this ... VERSION 1 SET...
0
by: shorti | last post by:
We are running DB2 UDB 8.1 fp 14 on AIX using archival logging and online backups. I was running some disaster tests and found my database restore was not restoring to the latest active log. ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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
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...
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 projectplanning, coding, testing,...

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.