473,513 Members | 2,708 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

rollforward problems understanding CUT

Hi,
Please help. I am having big problems trying to do a restore to a
point in time.
I have a restore with a time stamp of:20040512153945
Taken at about 15:40. I want to roll forward the logs to a point in
time, but the logs that is rolled forward contains the bad data, I
think I need to convert to CUT. I need to roll forward to about the
time of the backup. Using the $TZ var I get:
GMT0BST,M3.5.0,M10.5.0

How on earth do I convert the GMT to the CUT ? Once I understand that
I think it will work.

thanks
Peter.S
Nov 12 '05 #1
1 1571
Peter Sands <pe*********@techemail.com> wrote:
Please help. I am having big problems trying to do a restore to a
point in time.
I have a restore with a time stamp of:20040512153945
Taken at about 15:40. I want to roll forward the logs to a point in
time, but the logs that is rolled forward contains the bad data, I
think I need to convert to CUT. I need to roll forward to about the
time of the backup. Using the $TZ var I get:
GMT0BST,M3.5.0,M10.5.0

How on earth do I convert the GMT to the CUT ? Once I understand that
I think it will work.


CUT and GMT mean essentially the same thing to anyone who isn't an
astronomer. If your timestamp is 15:39:45 BST, that will work out to
be 14:39:45 CUT.

dave
Nov 12 '05 #2

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

Similar topics

2
2600
by: Raquel | last post by:
I have asked a similar question before, but am still not very clear on this......expecting some insights on this one.... Ok, so these are the two pieces of information regarding archived logs...
1
9529
by: Steven | last post by:
Ok W2K DB2 v8.1 fix pack 5. On production I took a an online backup of production and copied it over to my staging environment. restored the production database on top of staging database...
1
2074
by: Juan Norton | last post by:
Got DB2 v8.2 WUE -Machine A runnig XP -Machine B " 2003 server I have the following error trying to do a hand rollforward on machice B: db2 => rollforward database BD to end of logs...
2
3083
by: shenanwei | last post by:
DB2 V8.1.5 on Windows. When I execute ROLLFORWARD after a Restore. C:\db2 ROLLFORWARD db sample to END OF LOGS overflow log path(C:\LOGS\) Rollforward Status Input database alias ...
3
3377
by: t2581 | last post by:
Hi , I run restore with rollforward In job in output, last commited transaction time less then backup image time Is it normal ? RESTORE DATABASE PRICE_V8 FROM "E:\BACKUP" TAKEN AT...
3
13905
by: jadionne | last post by:
I am doing a rollforward and want to query the status of the rollforward. I issue the command: DB2 Rollforward database namdwh query status. I get the following error: C:\Documents and...
3
2502
by: EC | last post by:
We have two DB2 servers are supposed to be a replicate of each other with a database of the same name. I want to do a 'db2 db backup online... include logs' on the first server, and do a 'db2...
2
1791
by: satish mullapudi | last post by:
Hi, Am facing a tough situation & the scenario goes like this: I have scheduled online backup on a db. The online backup is scheduled to run daily at 12 in the night. Now am to restore the same db...
0
65299
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
7158
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
7535
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
7523
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
5683
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,...
1
5085
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...
0
4745
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...
0
3221
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
798
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
455
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...

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.