By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,233 Members | 1,500 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,233 IT Pros & Developers. It's quick & easy.

recovery time is bigger than current time

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a

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.