Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Rollforward stop vs complete

609 views
Skip to first unread message

Gladiator

unread,
Apr 26, 2011, 5:20:31 AM4/26/11
to
Hi ,

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

Kamal.

Lennart Jonsson

unread,
Apr 26, 2011, 7:46:12 AM4/26/11
to

They are synonyms, so there is no difference. Snipped from the 9.5
online help
(http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/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

Gladiator

unread,
Apr 27, 2011, 1:57:19 AM4/27/11
to
On Apr 26, 4:46 pm, Lennart Jonsson <erik.lennart.jons...@gmail.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.

Mark A

unread,
Apr 27, 2011, 2:11:50 AM4/27/11
to
> "Gladiator" <vkamaln...@gmail.com> wrote in message
> news:497cb7cc-4692-46ff...@r35g2000prj.googlegroups.com...

> 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.


Helmut Tessarek

unread,
Apr 27, 2011, 2:27:48 AM4/27/11
to
Hi Kamal,

On 27.04.11 1:57 , Gladiator wrote:
> 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.

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

Gladiator

unread,
Apr 27, 2011, 5:53:05 AM4/27/11
to

Thanks everyone for the clarification.

Kamal.

0 new messages