Risks in Circular logging for huge db in partitioned environment.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

prakku - 14 Dec 2006 08:59 GMT

Hi guys,

Can you please give your inputs for this,

OS : AIX 5.2

S/W : DB2 ESE 8.1 with fixpak 9.(Partitioned environment)

DB Size : approx 4TB

Logging : Circular.

Can any one please tell What are the risks involved if we use this
circular logging in partitioned environment.

Many Thanks.

Reply to this Message

Ian - 14 Dec 2006 14:07 GMT

> Hi guys,
>
[quoted text clipped - 10 lines]
> Can any one please tell What are the risks involved if we use this
> circular logging in partitioned environment.

They are exactly the same as any DB2 database. Your recovery is
limited to when you took your backup. Any work done since the
backup will be lost.

Reply to this Message

Mark A - 14 Dec 2006 16:40 GMT

> Hi guys,
>
[quoted text clipped - 12 lines]
>
> Many Thanks.

If you have a data warehouse, and have a complete backup, or can reload
the data after the last backup, then circular logging is usually fine.

Reply to this Message

db2admin - 14 Dec 2006 17:27 GMT

you cannot do online backups
database activity has to be stopped when taking backups

> > Hi guys,
>
[quoted text clipped - 13 lines]
> > Many Thanks.If you have a data warehouse, and have a complete backup, or can reload
> the data after the last backup, then circular logging is usually fine.- Hide quoted text -- Show quoted text -

Reply to this Message