Hi ,

Can someone tell me what happens when we issue a rollforward stop and
a rollforward complete.

Kamal.

On 2011-04-26 11:20, Gladiator wrote:
They are synonyms, so there is no difference. Snipped from the 9.5
online help
(http://publib.boulder.ibm.com/infoce...r5/index.jsp):

COMPLETE | STOP
Stops the rolling forward of log records, and completes the
rollforward recovery process by rolling back any incomplete transactions
and turning off the rollforward pending state of the database. This
allows access to the database or table spaces that are being rolled
forward. These keywords are equivalent; specify one or the other, but
not both. The keyword AND permits specification of multiple operations
at once; for example, db2 rollforward db sample to end of logs and
complete. When rolling table spaces forward to a point in time, the
table spaces are placed in backup pending state.



/Lennart

On Apr 26, 4:46*pm, Lennart Jonsson <erik.lennart.jons... (AT) gmail (DOT) com>
wrote:
Thanks for the reply,

But my question is if both are performing the same operation why do we
have two keywords STOP|COMPLETE ?
What are the situations in which we use STOP and in what situations we
use COMPLETE.


Thanks,
Kamal.

There is absolutely no difference between them. Both are accepted and do the
exact same thing. They probably both exist because of a decision to make the
rollforward command more compatible with syntax for other DB2 products (such
as DB2 for z/OS, etc), but I don't recall the exact history of this.

Hi Kamal,

On 27.04.11 1:57 , Gladiator wrote:
You can either use COMPLETE or STOP. Both commands are performing the same
operation. STOP is an alias for COMPLETE.
The reason why there are 2 keywords is a historical one.

But aliases are not uncommon. e.g.:

DB2:
'db2 get dbm cfg' alias for 'db2 get database manager configuration'

PHP:
'join' alias for 'implode'
'chop' alias for 'rtrim'

--
Helmut K. C. Tessarek
DB2 Performance and Development
IBM Toronto Lab

On Apr 27, 11:27*am, Helmut Tessarek <tessa... (AT) evermeet (DOT) cx> wrote:
Thanks everyone for the clarification.

Kamal.