I am trying to determine whether LOB's are replciated using HADR. The
following documentation from the on-line manuals http://publib.boulder.ibm.com/infoce...help/index.jsp suggest that
LOB's are not replicated on HADR:
------------------------------------------------
"Non-replicated operations for high availability disaster recovery:
High availability disaster recovery (HADR) uses database logs to
replicate data to the standby database. Non-logged operations are
allowed on the primary database, but not replicated to the standby
database. Non-replicated operations include, but are not limited to,
the following operations:
- BLOBs and CLOBs are not replicated; however, the space for them will
be allocated on the standby database."
-------------------------------------------------
So I assuming that even LOB's that are logged on the primary server are
not replicated to the backup in HADR? But I assume it also means that
if the LOB data is read only (not updated), then we could store the
data on both servers. 13 5070 m0****@yahoo.co m wrote: I am trying to determine whether LOB's are replciated using HADR. The following documentation from the on-line manuals http://publib.boulder.ibm.com/infoce...help/index.jsp suggest that LOB's are not replicated on HADR: ------------------------------------------------
... -
NOT LOGGED BLOBs and CLOBs are not replicated; however, the space for them will be allocated on the standby database." -------------------------------------------------
I'm told this doc error will be corrected in the next refresh.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Can you tell me specifically what the doc error is?
Does that mean that HADR will replciate LOB's?
The current documentation categorizing LOBs among non-logged items is
incorrect. Some LOBs are logged and some aren't. Logged LOBs are
replicated just fine by HADR, non-logged LOBs are not.
Regards,
- Steve P.
--------------------------
Steve Pearson
DB2 UDB for LUW Development, Portland, OR, USA
"Steve Pearson (news only)" <st*******@my-deja.com> wrote in message
news:11******** **************@ g49g2000cwa.goo glegroups.com.. . The current documentation categorizing LOBs among non-logged items is incorrect. Some LOBs are logged and some aren't. Logged LOBs are replicated just fine by HADR, non-logged LOBs are not.
Regards, - Steve P. -------------------------- Steve Pearson DB2 UDB for LUW Development, Portland, OR, USA
The doc does not say that LOB's are not logged. It says they are not
replicated with HADR. The InfoCenter on-line doc says:
"BLOBs and CLOBs are not replicated; however, the space for them will be
allocated on the standby database."
This is the on-line version of the manuals at the IBM website. How come it
has not been updated?
"Steve Pearson (news only)" <st*******@my-deja.com> wrote in message
news:11******** **************@ g49g2000cwa.goo glegroups.com.. . The current documentation categorizing LOBs among non-logged items is incorrect. Some LOBs are logged and some aren't. Logged LOBs are replicated just fine by HADR, non-logged LOBs are not.
Regards, - Steve P. -------------------------- Steve Pearson DB2 UDB for LUW Development, Portland, OR, USA
Anyone know if HADR has a problem replicating XML Extender?
Mark A wrote: "Steve Pearson (news only)" <st*******@my-deja.com> wrote in message news:11******** **************@ g49g2000cwa.goo glegroups.com.. .
The current documentation categorizing LOBs among non-logged items is incorrect. Some LOBs are logged and some aren't. Logged LOBs are replicated just fine by HADR, non-logged LOBs are not.
Regards, - Steve P. -------------------------- Steve Pearson DB2 UDB for LUW Development, Portland, OR, USA
Anyone know if HADR has a problem replicating XML Extender?
The XML extender is, at the end of the day, just an application.
It should work.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Mark A wrote: "Steve Pearson (news only)" <st*******@my-deja.com> wrote in message news:11******** **************@ g49g2000cwa.goo glegroups.com.. .
The current documentation categorizing LOBs among non-logged items is incorrect. Some LOBs are logged and some aren't. Logged LOBs are replicated just fine by HADR, non-logged LOBs are not.
Regards, - Steve P. -------------------------- Steve Pearson DB2 UDB for LUW Development, Portland, OR, USA
The doc does not say that LOB's are not logged. It says they are not replicated with HADR. The InfoCenter on-line doc says:
"BLOBs and CLOBs are not replicated; however, the space for them will be allocated on the standby database."
This is the on-line version of the manuals at the IBM website. How come it has not been updated?
The doc _implies_ that LOBs are not replicated because they are not logged.
What it should state is that LOBs which have been specified as NOT
LOGGED are not replicated (because they are not logged...)
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
"Serge Rielau" <sr*****@ca.ibm .com> wrote in message
news:3n******** **@individual.n et... The doc _implies_ that LOBs are not replicated because they are not logged. What it should state is that LOBs which have been specified as NOT LOGGED are not replicated (because they are not logged...)
Cheers Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab
I will have to respectively disagree. The doc says flat out that "BLOBs and
CLOBs are not replicated" and there is no mention of logging, or not
logging, for the reason they are not replicated.
"Serge Rielau" <sr*****@ca.ibm .com> wrote in message
news:3n******** **@individual.n et... The XML extender is, at the end of the day, just an application. It should work.
Cheers Serge
-- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab
The reason I asked is that Q-Replication doc states that it will not
replicate the DB2 Extenders. I realize that I am asking about HADR, but I
need to make sure. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Bruce M |
last post by:
Is there a way to run the db2-generated HADR-create script outside of
DB2CC beyond the obvious? My DB2CC generates the HADR script and then
abends because of a java error meaning I can't finish my HADR
creation.
In looking at the script it isn't necessarily obvious which commands
should run on the primary server and which should be run on the
standby server.
|
by: Mark A |
last post by:
If server 01 running HADR in the primary role crashes, and the DBA does a
HADR takeover by force on the 02 server to switch roles, then the 02 server
is now the primary.
What happens when the Server 01 is brought back up? It still thinks it is
the primary because that was its role when it crashed and it does not know
about the takeover by force command that was issued. Does the 01 server
check the 02 server to see what role they are in...
|
by: Joachim Klassen |
last post by:
DB2 V8.2 FP10 on Windows
I tested the following HADR scenario:
- a new tablespace on a new filesytem is created on the primary System
- the replay on standby fails because of lacking permissions
- the tablespace is backed up on the primary system
- tables are created in the new tablespace and data is inserted (and a
couple of logs are archived)
- Takeover is done by the standby
|
by: gumby |
last post by:
I'm having trouble getting HADR to work with the sample databases on
two HS20 xSeries blades, Red Hat ES4 up3, DB2 8.2.4, getting the
following error.
SQL1768N Unable to start HADR. Reason code = "7" - The primary
database failed to establish a connection to its standby database
within the HADR timeout interval.
What things should I check besides the remote host and remote service
parameters on the standby database, which seem to be...
|
by: Gladiator |
last post by:
Hai everyone......
i was trying to implement the HADR concept
........ i tried using the following commands ......
On server_1
db2 backup database prod to /backup_dir
db2 update db cfg for prod using
HADR_LOCAL_HOST server_1
HADR_REMOTE_HOST server_2
HADR_LOCAL_SVC port_s1
| |
by: Challenge |
last post by:
Hi,
I got error, SQL1768N Unable to start HADR. Reason code = "7", when I
tried to start hadr primary database. Here are the hadr configuration
of my primary db:
HADR database role = STANDARD
HADR local host name (HADR_LOCAL_HOST) = testserver
HADR local service name (HADR_LOCAL_SVC) = 56000
HADR remote host name (HADR_REMOTE_HOST) = testserver
|
by: RayRay |
last post by:
I was hoping I might be able to get an answer regarding DB2 and HADR.
Let me preface this by saying that I know very little about networking
and I'm not familiar with the HADR product or clustering. But, I've
been asked to research a couple issues for a client.
They are thinking about implementing HADR. They have DB2 production
databases running on more than one box.
Does a liscense for HADR need to be purchased for each production box...
|
by: shorti |
last post by:
db2 8.1 fix pack 12 on AIX 5.3
This is a newly configured HADR machine. The HADR was up and running.
I was 'playing' around some on the standby and did a db2 deactivate and
things sort of went down hill from there.
Though the Standby machine seemed to know it was a standby it would not
connect to the primary. I could not even do a db2 get snapshot to view
the hadr status on the machine. I was wanting to do a few HADR tests
before I...
|
by: deshaipet |
last post by:
Hi -
We have primary and standby databases on different servers.
Here is my /etc/service entry for HADR pair :
On Primary :
"vi /etc/services
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |