473,574 Members | 2,242 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Nov 12 '05 #1
4 3705
db********@yaho o.com wrote:
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
Nov 12 '05 #2

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

Nov 12 '05 #3
Ian
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.

Nov 12 '05 #4
Ian wrote:
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

Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
5494
by: Vik Rubenfeld | last post by:
I'm a newbie to Apache. This week I installed my first Apache 2.0 server, and it's working fine. I then installed PHP. When I ran the PHP test file ("test.php"), the actual text contents of the file came up in the browser: ---------------- <?php phpinfo(); ?> ----------------
4
7365
by: Akhlaq Khan | last post by:
we are developing an intranet application (web based) which needs to detect the logged in user ID of the user hitting the website. the intranet is huge and based on win2k active directory (around 20-30 different domains) with 25K+ users. i dont want to use "NT challenge response" for this pupose. I am exploring ways using ADSI and WMI to...
20
2789
by: Karl Smith | last post by:
I heard a rumour that Opera succeeded where none have before, and implemented the tables described in HTML4 and CSS2. So I thought I'd try it out with the well known Periodic Table. http://users.tpg.com.au/karl6740/css/table_elements_periodic.html CSS: Notice in the TRs with the lanthanides and actinides, the empty TDs at the end...
1
5473
by: Daniel Chou | last post by:
Hello, I have two questions about "not logged initially": 1. Before using "alter table tbname activate not logged initially", should the table be created with "not logged initially"? 2. After using "alter table tbname activate not logged initially", how to deactivate it?
289
1805
by: napi | last post by:
I think you would agree with me that a C compiler that directly produces Java Byte Code to be run on any JVM is something that is missing to software programmers so far. With such a tool one could stay with C and still be able to produce Java byte code for platform independent apps. Also, old programs (with some tweaking) could be...
0
6624
by: atomz4peace | last post by:
I am trying to script the creation of a database in sql server 2000. I have something like: create database test go use test go create table .....etc.....
10
10026
by: morangolds | last post by:
Hi, I've been having a problem with C++ Windows Forms apps not "ending" when you close the form window. I've searched about this problem all over the place and most searches have lead me to believe that this has to do with unreleased form component events or event handlers. I'm comparatively new to .net and windows forms, in the sense that...
2
2046
by: MohamedSaleh | last post by:
HI all I have the following problem Table SOURCE has columns <char COL1, integar COL2> and has rows {A,1}, {A,2,}, {,A,3}, {B,1}, {B,2},, {C,1},
5
7909
by: TC | last post by:
Hey All, I'm trying to upload files via FTP and I'm using FtpWebRequest and WebClient. Unfortunately, I'm receiving a "Not Logged In" error. I know that others have seen this as I've seen postings but I haven't seen any clear resolution.
0
7801
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7719
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8229
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7808
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8096
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6450
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3739
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1335
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1055
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.