recovery time is bigger than current time
This is a discussion on recovery time is bigger than current time within the DB2 forums, part of the Database Server Software category; --> Why the recovery to time is greater than the current time? --------------------------------------------------------------------------------------------------------------------- Last committed transaction = 2006-08-23-22.09.40.000000 DB20000I The ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:59 AM
| ||||
| ||||
 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.      |
|
02-27-2008, 07:59 AM
| |||
| |||
| Re: recovery time is bigger than current time 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. |
|
02-27-2008, 08:01 AM
| ||||
| ||||
| Re: recovery time is bigger than current time 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 |
Linear Mode
