469,365 Members | 1,840 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,365 developers. It's quick & easy.

recovery time is bigger than current time

Why the recovery to time is greater than the current time?
---------------------------------------------------------------------------------------------------------------------
Last committed transaction = 2006-08-23-22.09.40.000000

DB20000I The ROLLFORWARD command completed successfully.
db2 =connect to test

Database Connection Information

Database server = DB2/6000 7.1.0
SQL authorization ID = DB2INST1
Local database alias = TEST

db2 =select count(*) from t1

1
-----------
280

1 record(s) selected.

db2 =select current time from dual

1
--------
17:33:47

1 record(s) selected.

Aug 23 '06 #1
2 1493
thats the GMT time. Use the "using local time" option.

jpzhai wrote:
Why the recovery to time is greater than the current time?
---------------------------------------------------------------------------------------------------------------------
Last committed transaction = 2006-08-23-22.09.40.000000

DB20000I The ROLLFORWARD command completed successfully.
db2 =connect to test

Database Connection Information

Database server = DB2/6000 7.1.0
SQL authorization ID = DB2INST1
Local database alias = TEST

db2 =select count(*) from t1

1
-----------
280

1 record(s) selected.

db2 =select current time from dual

1
--------
17:33:47

1 record(s) selected.
Aug 23 '06 #2

kedar wrote:
thats the GMT time. Use the "using local time" option.

jpzhai wrote:
Why the recovery to time is greater than the current time?
---------------------------------------------------------------------------------------------------------------------
Last committed transaction = 2006-08-23-22.09.40.000000

DB20000I The ROLLFORWARD command completed successfully.
db2 =connect to test

Database Connection Information

Database server = DB2/6000 7.1.0
SQL authorization ID = DB2INST1
Local database alias = TEST

db2 =select count(*) from t1

1
-----------
280

1 record(s) selected.

db2 =select current time from dual

1
--------
17:33:47

1 record(s) selected.

thanks

Aug 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Rajesh Garg | last post: by
18 posts views Thread by Jason Tesser | last post: by
1 post views Thread by Vikrant | last post: by
10 posts views Thread by xixi | last post: by
3 posts views Thread by jignesh shah | last post: by
1 post views Thread by Michel Esber | last post: by
reply views Thread by Winder | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.