375 18198
"Noons" <wi*******@yaho o.com.au> wrote in message
news:42******** *************** @per-qv1-newsreader-01.iinet.net.au ... Madison Pruet apparently said,on my timestamp of 4/08/2005 6:07 AM:
So, what happens if a trigger in that table changes ANOTHER table that is not being replicated? Do the OTHER table's changes get replicated as well? Note: you asked for "ALL trigger activity".
At a minimun the replication solution should be able to either prevent triggers from firing on the target if it is populated by a replication apply, with the assumption (and policing) that all of the tables
associated with original transaction is replicated as part of that transaction.
I was not talking about triggers on the target nor were you. It's very clear above. Don't change the subject.
Fantastic. I couldn't care less about the "or" bits to "deal with this problem". First of all, you didn't even understand the problem. the original table". That's : *ALL* OF THE TRIGGER ACTIVITY PERFORMED ON THE *ORIGINAL TABLE*. That is a much more complex requirement. I want to know how YOU address it with specific NATIVE Informix replication (or any other product's for that matter).
Fair enough --- on the IDS informix server, to do this with say 5 instances
by issueing the two commands
cdr define template noons --database=noons --master=node1 --all
cdr realize template noons --syncdatasource= node1 node2 node3 node4 node5
This would set up an update anywhere of everything in the noons database
using the five servers.
Madison Pruet wrote: At a minimun the replication solution should be able to either prevent triggers from firing on the target if it is populated by a replication apply, with the assumption (and policing) that all of the tables associated with original transaction is replicated as part of that transaction.
Yes, there is a function that should be called in an updateable MV
target table trigger DBMS_MVIEW.I_AM _A_REFRESH. It returns FALSE if
trigger is fired by local changes, and TRUE if trigger is fired by
replication.
"Mark Malakanov" <ma*****@rogers .com> wrote in message
news:xL******** ************@ro gers.com... Madison Pruet wrote: At a minimun the replication solution should be able to either prevent triggers from firing on the target if it is populated by a replication apply, with the assumption (and policing) that all of the tables
associated with original transaction is replicated as part of that transaction.
Yes, there is a function that should be called in an updateable MV target table trigger DBMS_MVIEW.I_AM _A_REFRESH. It returns FALSE if trigger is fired by local changes, and TRUE if trigger is fired by replication.
"Mark Malakanov" <ma*****@rogers .com> wrote in message
news:xL******** ************@ro gers.com... Madison Pruet wrote: At a minimun the replication solution should be able to either prevent triggers from firing on the target if it is populated by a replication apply, with the assumption (and policing) that all of the tables
associated with original transaction is replicated as part of that transaction.
Yes, there is a function that should be called in an updateable MV target table trigger DBMS_MVIEW.I_AM _A_REFRESH. It returns FALSE if trigger is fired by local changes, and TRUE if trigger is fired by replication.
That's a good feature. But is there a way to prevent the trigger from
firing without having to make the trigger aware of the fact that replication
exists? Otherwise, wouldn't it be difficult to use replication with third
party applications?
Madison Pruet wrote: "Mark Malakanov" <ma*****@rogers .com> wrote in message news:xL******** ************@ro gers.com...
Madison Pruet wrote:
At a minimun the replication solution should be able to either prevent triggers from firing on the target if it is populated by a replication apply, with the assumption (and policing) that all of the tables associated with original transaction is replicated as part of that transaction.
Yes, there is a function that should be called in an updateable MV target table trigger DBMS_MVIEW.I_AM _A_REFRESH. It returns FALSE if trigger is fired by local changes, and TRUE if trigger is fired by replication .
That's a good feature. But is there a way to prevent the trigger from firing without having to make the trigger aware of the fact that replication exists? Otherwise, wouldn't it be difficult to use replication with third party applications?
I'm afraid it would be difficult. Triggers should be modified.
If you have third-party app that was not designed for replication, you
could use Advanced Replication, that works via Streams and AQ and is
practically transparent to the app. But it is lincensed separately.:(
AR is very powerful thing, mainly because it allows to resolve data
collisions using many standard and custom methods, and can work with a
close to real time latency.
So depending on the scenario, you can use Standard R with full or fast
refreshes, groups, for one-direction replication. I doubt that you will
run the same app on the replica. Usually it is some kind of reporting DB.
If you need two(several) identical DBs with identical apps, that
actively work by-directionally, you have to go with AR, and to think
about collision resolutions.
but... what was an initial question? :)
On Thu, 04 Aug 2005 05:36:54 +1000, Noons <wi*******@yaho o.com.au>
wrote: Madison Pruet apparently said,on my timestamp of 4/08/2005 5:32 AM: I am sure IBM Global Services are just as happy to look after an Oracle database as a DB2 database as an abacus if they can earn their hourly fee for doing so... (LOL)!!
and place heaps of their hordes on the job. 27 dbas in a single project, I counted last time. As if ANY of them was a dba...
Noons --- I'd be very careful about talking of the number of DBA's required to run a database system if I were you. I can quote some fairly impressive system/dba ratios which are in place for the IBM Informix server.
Me too. I can even tell you in which project IBMGSA placed the 27 dbas.
Oracle DBAs or DB2 DBAs?? 8-)
JWC
On Wed, 03 Aug 2005 20:06:31 +1000, Noons <wi*******@yaho o.com.au>
wrote: John Carlson apparently said,on my timestamp of 3/08/2005 11:25 AM:
I use ER under 9.4; it works quite well. Relatively low overhead . . . . and I'm looking forward to 10.00. That's great. Someone please give the man the blue plastic bucket.
And your point would be . . . . ? I'm saying, in my case with my
systems, it works. Not as perfect as I'd like, but it works. Rows
get updated / inserted on source; rows get replicated to reporting
server. Nothing fancy . . . .
No blue buckets needed . . . . I don't work for IBM. 8-) If you don't want to keep Informix in the conversation, then please drop comp.databases. informix from your post list. Give a hoot, don't pollute. As soon as everyone else, including you, does the same to all the other cross replies. Who the heck do you think you are to tell me how and where to post? Get lost.
Correct the error / comment in direct proportion to the broadcast.
Your quote of . . . .
Madison: I've long ago stopped believing in fairies, godmothers and other garden variety gnomes. Spare me the "mine is longer than yours", I don't give a rat's arse what Informix does, under or not IBM. Tah?
.. . . was cross-posted to all three, thus the reply / correction /
comment gets cross-posted as well.. If you don't really wish to talk
(intelligently or otherwise) about Informix, then why bother posting
to c.d.i? You do have the right to post; other Oracle DBAs post here
too. But when it gets ridiculous, we also have the right to either
correct or ignore.
'Nuff said from here . . . back to the fireworks . . . 8-)
JWC
"Mark Malakanov" <ma*****@rogers .com> wrote in message
news:Na******** ************@ro gers.com... Madison Pruet wrote: "Mark Malakanov" <ma*****@rogers .com> wrote in message news:xL******** ************@ro gers.com...
Madison Pruet wrote:
At a minimun the replication solution should be able to either prevent triggers from firing on the target if it is populated by a replication apply, with the assumption (and policing) that all of the tables
associated
with original transaction is replicated as part of that transaction.
Yes, there is a function that should be called in an updateable MV target table trigger DBMS_MVIEW.I_AM _A_REFRESH. It returns FALSE if trigger is fired by local changes, and TRUE if trigger is fired by replication .
That's a good feature. But is there a way to prevent the trigger from firing without having to make the trigger aware of the fact that
replication exists? Otherwise, wouldn't it be difficult to use replication with
third party applications? I'm afraid it would be difficult. Triggers should be modified.
Mark - you are cross-posting to comp.databases. informix.
Believe me, I'm fully aware of how difficult this is, and also how important
it is to make replication seemless for user and third-party applications.
IBM Informix Enterprise Replication supports the ability to dynamically fire
or not fire the triggers based on wheither the update is performed by a user
thread or by the replication apply. That means no modification of the
trigger body is required to support replication, even though the tables have
triggers defined. Informix Enterprise Replication also has the option to
permit selective firing of the triggers. On some tables you might fire
them; on others not.
Since by default, triggers are not fired on the targets, we are able to
fairly easily configure the system to replicate all of the tables within the
database without having to modify the triggers that are supporting the
application. Or I can again fairly easily define a subset of tables within
the database that I want to replicate as a group. Basically replicate all of
the related tables affected by the firing of the triggers and not firing any
triggers on the target.
Noons wrote: Frank van Bortel apparently said,on my timestamp of 4/08/2005 5:18 AM:
Thanks for clarifying that, Montpellier it was.
Well, Montpellier <-> Nice is 275 km. Both on the Cote d'Azur. Close enough for me.
This is Europe you're talking about Frank, there are entire countries in there smaller than that! :)
Smaller than 275 km ???
Ok , a couple are smaller than 275 square kilometers.
--
Anton Versteeg
IBM Netherlands
Serge Rielau wrote: Call it RAC, GRID, autonomous computing, queuing, advanced XML, information integration. I think the commercial database vendors will stay ahead of the open source crowd for the foreseeable future. Comparing marketshare between the faction in this environment is another can of worms.
I DO think you're underestimating both growth rate and capabilities of
the OS databases. I honestly think those databases will gain a lot of
marketshare in a very short time. We're using DB2 atm for our ASP
service, but it's mainly because of the reputation and the lack of
practice information concerning OS databases. We're not willing to take
the risk of using an OS database that *might* not be up to the task.
But a database like postgres might aswell be able to do the things we
need. It *has* the capabilities we need; SQL, backup/restore, stored
procedures, ODBC connectivity, schema's, tablespaces, ACID, and so on...
The are a few things that are unclear: TPS and stability. The biggest
things lacking for OS databases are not very technical, these are
reputation (DB2/Oracle/Informix/Sybase etc. are proven technology and
built a certain reputation over the years) and support (still
notoriously little support for OS databases).
I see a lot of young companies around me, and they all consider OS
databases first. Only if an OS database doesn't fit, then and only then
will they consider an expensive commercial database.
Sure, the commercial databases have a solid base of customers, but I
doubt the growth of customers is increasing or even stable.
But one thing we can all agree on is MSSQL. I cannot place that thing
anywhere. Too expensive to compete with OS, and too ..erm.. arcane to
compete with commercial databases. But one behemoth of marketing :P
-R- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: David Eng |
last post by:
> For many years now enterprise business application development has
> been the core area for the use of C++.
> Today a significant share to this segment has already been lost to
> SUN's Java technology and with MS now abandoning C++ in favour if its
> proprietery .NET and C# technology, how long can we except C++ to hold
> on against these might competitors?
> Has C++ become a dying language?
> What is the future of C++?
As I posted...
|
by: GTO |
last post by:
I do not believe that C# is the future of C++. I also do not believe that
adding two thousand new library functions to the standard library is the
future of C++. But what is the future of C++? Is it as good as a programming
language can get?
Like so many of you, I programmed speech recognizers, image recognition
systems, a portion of a chess program, lots of numeric code using STL, and
tons of other applications in C++, (even firmware...
|
by: Lyle Fairfield |
last post by:
It's confusing. Many people here and elsewhere make many different
predictions:
There's an introduction mentioning some aspects of this at
http://msdn.microsoft.com/data/mdac/techinfo/default.aspx?
pull=/library/en-us/dnmdac/html/data_mdacroadmap.asp
revised Sep 2005
(upper case conversions are mine)
|
by: |
last post by:
Everything seems to be moving to .NET and VC++ seems to be adding a lot of
managed code support every new release.
The questions: is unmanaged code in VC++ beeing phased out in favour of
managed code?
And suppose I still program in VC++ 6.0, can I safely assume that the code I
use in VC++ 6.0 will still be available in future VC++ versions.
Finally will VC++ 6.0 generated executables be still be able to run on futur
Windows versions and...
|
by: Fuzzyman |
last post by:
Hello all,
The following is a copy of a blog entry. It's asking a question about
future statements and the built in compile function. I'd appreciate any
pointers or comments about possible approaches.
`Movable Python <http://www.voidspace.org.uk/python/movpy/>`_ supports
running both Python scripts and ``.pyc`` bytecode files. It does this
by compiling scripts to bytecode, or extracting the code object from
bytecode files, and then...
| |
by: Zootal |
last post by:
My apologies if this gets asked/discussed a lot. With c# rampaging through
corporate USA (and other countries), what impact will this have on the usage
and future of c++? I've used both of them a bit. I'm in school, and our CS
program does not use c#, but uses mostly c++ and a bit of java. C# is
relegated ot the CIS programs. Out there in the real world, what kind of a
future does c++ have?
|
by: rohayre |
last post by:
Im a long time java developer and actually have never done anything
with java scripting. I'd like to write a short simple script for
calculating a date in the future based on today's date and a letter.
Can I use javascripting to create a webpage to allow a user to enter a
letter and then click a button to find a future calendar date? I'm just
not sure how much user interaction scripting allows. Does java
scripting allow buttons, textfields...
|
by: blangela |
last post by:
If you had asked me 5 years ago about the future of C++, I would have
told you that its future was assured for many years to come. Recently,
I have been starting to wonder.
I have been teaching C++ at a local polytechnical school here in
Vancouver, Canada for approximately 8 years. Six years ago, at the
height (or should I say volume?) of the internet bubble, I had 80+
students per semester in my C++ course. Now I am fortunate to have...
|
by: KimmoA |
last post by:
Does C have a future? I'd like to think so, but nobody seems to agree
with me. Of course, I don't use C in my profession, and maybe I
wouldn't be using it if I had the pressure to actually produce things
with deadlines and stuff. Hmm. That's a depressing thought.
I can't stand OOP. Yes, it is beautiful in theory, and it might make
sense for huge projects with many people involved, but I don't want
anything to do with it. (I switched to C...
|
by: Jon Harrop |
last post by:
If Microsoft turn F# into a product and place it alongside C# and VB, will
many people migrate from C# to F#?
--
Dr Jon D Harrop, Flying Frog Consultancy
http://www.ffconsultancy.com/products/?u
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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: 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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| |
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...
| |