questions on HADR on tables with "not logged initially"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db2group88@yahoo.com - 23 Feb 2005 21:27 GMT

we are using db2 udb v8.2 on windows. all our tables are created with
not logged initially property,

So if i want to activate HADR (high availability disaster recovery) for

the database, in the document it said " non-replicated operations
include, but are not limited to --Tables created with the NOT LOGGED
initially option specified", so does that means i can't do HADR on our
current database because all the tables are created with the NLI
option? thanks

Reply to this Message

Serge Rielau - 23 Feb 2005 21:45 GMT

> we are using db2 udb v8.2 on windows. all our tables are created with
> not logged initially property,
[quoted text clipped - 6 lines]
> current database because all the tables are created with the NLI
> option? thanks

No it doesn't mean that.
If a table is created with not logged initially thsi is only in effect
for the first insert. After that that table is no different than any
other in DB2 V8.1 and V8.2
Presuming you don't start with an empty database the issue would only
arise if you ALTER TABLE .. ACTIVATE NOT LOGGED INITIALLY
everything happening on that table until the next commit would not be
logged and hence not applied to the secondary.

Cheers
Serge

Signature

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Reply to this Message

Steve Pearson - 26 Feb 2005 04:10 GMT

This depends a bit on what is meant by "tables are created."
For existing tables that were created with NLI and are now logged,
there
shouldn't be a problem, as long as the standby is initialized using a
backup taken after all the tables became logged. However, if it means
that new tables are regularly created in the database with NLI, then
this
will be in conflict with HADR.

Regards,
- Steve P.
-----------------------
Steve Pearson
IBM DB2 UDB Development
Portland, OR, USA

Reply to this Message

Ian - 26 Feb 2005 19:09 GMT

> This depends a bit on what is meant by "tables are created."
> For existing tables that were created with NLI and are now logged,
[quoted text clipped - 3 lines]
> that new tables are regularly created in the database with NLI, then
> this will be in conflict with HADR.

Steve,

I think he meant that because V8.2 does not require you to create tables
explicitly with the NOT LOGGED INITIALLY parameter (it's implicit), does
the simple act of creating a table (CREATE TABLE T1 (c1 int);) break
HADR.

Reply to this Message

Nunya Bizness - 28 Feb 2005 05:45 GMT

>> This depends a bit on what is meant by "tables are created."
>> For existing tables that were created with NLI and are now logged,
[quoted text clipped - 10 lines]
> the simple act of creating a table (CREATE TABLE T1 (c1 int);) break
> HADR.

Not really since logging for the table is on until you do an:

alter table schema.table activate not logged initially

Reply to this Message