|
|
|
|
|
|
| Author |
Message |
Nunya Bizness
*nix forums beginner
Joined: 22 Feb 2005
Posts: 14
|
 Posted: Mon Feb 28, 2005 4:45 am Post subject:
Re: questions on HADR on tables with "not logged initially"
|
|
|
Ian wrote:
| Quote: | Steve Pearson wrote:
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.
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.
|
Not really since logging for the table is on until you do an:
alter table schema.table activate not logged initially |
|
| Back to top |
|
 |
Ian
*nix forums Guru Wannabe
Joined: 02 Aug 2005
Posts: 262
|
| Posted: Sat Feb 26, 2005 6:09 pm Post subject:
Re: questions on HADR on tables with "not logged initially"
|
|
|
Steve Pearson wrote:
| Quote: | 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.
|
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. |
|
| Back to top |
|
|
Steve Pearson (news only)
*nix forums beginner
Joined: 16 Jun 2005
Posts: 39
|
| Posted: Sat Feb 26, 2005 3:13 am Post subject:
Re: questions on HADR on tables with "not logged initially"
|
|
|
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 |
|
| Back to top |
|
|
Serge Rielau
*nix forums Guru
Joined: 29 Apr 2005
Posts: 1583
|
| Posted: Wed Feb 23, 2005 8:45 pm Post subject:
Re: questions on HADR on tables with "not logged initially"
|
|
|
db2group88@yahoo.com wrote:
| Quote: | 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
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
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab |
|
| Back to top |
|
|
db2group88@yahoo.com
*nix forums beginner
Joined: 15 Feb 2005
Posts: 6
|
| Posted: Wed Feb 23, 2005 8:27 pm Post subject:
questions on HADR on tables with "not logged initially"
|
|
|
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 |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Thu Jan 08, 2009 3:43 am | All times are GMT
|
|
Car Finance | Libro arquitectura | McDonalds | Loans | Credit Cards
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
IBM DB2
