473,770 Members | 2,630 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

No future for DB2

This article is very bleak about future of DB2. How credible is the
author. http://www.eweek.com/article2/0,1895,1839681,00.asp

Nov 12 '05
375 18193
Madison Pruet wrote:
no - it's comp.databases. ibm-db2 and comp.databases. informix AND
comp.databas es


You will find the ability to read of great value if your career is in
IT. And you are not correct. Perhaps your reader is truncated the name
but it is indeed c.d.o.server.
--


ARGGGGGGHHHH!!!

Dang it - you're right. #%$#@#$*()@@#$& %((($(#$$


Yeah like I don't totally embarrased myself on a regular basis.
For example my mangled verbiage above.
--
Daniel A. Morgan
http://www.psoug.org
da******@x.wash ington.edu
(replace x with u to respond)
Nov 12 '05 #251
On Mon, 01 Aug 2005 00:10:29 -0700, Noons interested us by writing:

DA Morgan wrote:
Madison Pruet wrote:
> I didn't know that Oracle replication was available on the standard edition.
> I thought that it was only available on the enterprise edition. Am I
> mistaken?


1. Please don't top post.
2. You are correct.


He's correct in that he's mistaken. Snapshot replication
(basic replication) *is* available in Standard Edition, 9i.
Advanced replication (master2master) is only in EE.
10g might have changed that, but that will be another
reason for people not to upgrade...


Just to expand on that a bit:

a) from the Oracle9i R2 New Features manual:

-----------------
Basic replication - SE and EE

Oracle9iserver fully supports bi-directional replication with automated
conflict detection and resolution. Supported configurations include a
single updatable master site with multiple updatable or read-only snapshot
sites.

Advanced Replication - EE only

Advanced replication includes basic replication functionality plus
multi-master replication, Replication Manager, and parallel propagation to
maximize throughput. (Advanced Replication was formerly known as
Replication.)
-----------------

b) from the Oracle® Database Licensing Information manual for 10g

-----------------
Advanced Replication (multimaster) - EE only

Basic replication (which is available with Standard Edition and Standard
Edition One) provides support for read-only and updatable materialized
views (for replication) and multitier materialized views. Standard Edition
and Standard Edition One databases can also act as a master site for
materialized views, but cannot participate in multimaster replication.
-----------------

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard _at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

Nov 12 '05 #252
HansF wrote:
On Mon, 01 Aug 2005 00:10:29 -0700, Noons interested us by writing:

DA Morgan wrote:
Madison Pruet wrote:

I didn't know that Oracle replication was available on the standard edition.
I thought that it was only available on the enterprise edition. Am I
mistaken?

1. Please don't top post.
2. You are correct.


He's correct in that he's mistaken. Snapshot replication
(basic replication) *is* available in Standard Edition, 9i.
Advanced replication (master2master) is only in EE.
10g might have changed that, but that will be another
reason for people not to upgrade...

Just to expand on that a bit:

a) from the Oracle9i R2 New Features manual:

-----------------
Basic replication - SE and EE

Oracle9iserver fully supports bi-directional replication with automated
conflict detection and resolution. Supported configurations include a
single updatable master site with multiple updatable or read-only snapshot
sites.

Advanced Replication - EE only

Advanced replication includes basic replication functionality plus
multi-master replication, Replication Manager, and parallel propagation to
maximize throughput. (Advanced Replication was formerly known as
Replication.)
-----------------

b) from the Oracle® Database Licensing Information manual for 10g

-----------------
Advanced Replication (multimaster) - EE only

Basic replication (which is available with Standard Edition and Standard
Edition One) provides support for read-only and updatable materialized
views (for replication) and multitier materialized views. Standard Edition
and Standard Edition One databases can also act as a master site for
materialized views, but cannot participate in multimaster replication.
-----------------


Thanks.
--
Daniel A. Morgan
http://www.psoug.org
da******@x.wash ington.edu
(replace x with u to respond)
Nov 12 '05 #253

"bka" <ba*******@yaho o.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
Replicaton to/from Oracle has nothing do with Enterprise and/or
standard edition - to replicate to Oracle or SQL Server, you need IBM
Information Integator.


On minaframe, you need to buy a matching nut for every screw you purchased.
Nov 12 '05 #254
Madison Pruet wrote:
Does Oracle snapshot replication

1) replicate all of the trigger activity performed on the original table
2) distinguish between updates on a row and inserts/deletes on the same row?
(If not, then cascade deletes are not properly performed)
3) properly handle cascading updates
If I understand your question correctly, that is not possible
with ANY replication in any database version.
Traditionaly, when one replicates a table, one only wants the data
of that table. What you are saying is that the entire schema
potentially dependent on that table might also need to be replicated?

If so, I suggest you look at Dataguard: it's the appropriate product
to achieve it and yes, it does the lot. To try and do that with
replication is to pay a huge overhead to achieve something that can
be done a lot more efficiently with different technology.
This is why I generally don't consider snapshot copies as being replication.
They generally only replicate the data, and not the engine logic associated
with the base table.


Well, have a look at the Oracle doco. Replication has at least three
flavours nowadays (four if you count Dataguard): basic, advanced and
streams.
Streams is the most powerful, but being new you may pay a price in it
not being entirely debugged. Of course I'm not suggesting that Oracle
software is anything but perfect... ;)
The other two are just traditional replication subsets.

Have a look at Hans' reply, he details each of the two and
there is no point in me repeating. Even with basic replication,
you still get CRUD. But you won't get elaborate cascading dependencies.
Nor trigger effect cascading. For that sort of replication, Dataguard
is the answer.

Nov 12 '05 #255

Madison Pruet wrote:

no - it's comp.databases. ibm-db2 and comp.databases. informix AND
comp.databases


You will find the ability to read of great value if your career is in
IT. And you are not correct. Perhaps your reader is truncated the name
but it is indeed c.d.o.server.
--

ARGGGGGGHHHH!!!

Dang it - you're right. #%$#@#$*()@@#$& %((($(#$$

ker-chink!
;)

Nov 12 '05 #256

"Noons" <wi*******@yaho o.com.au> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. .
Madison Pruet wrote:
Does Oracle snapshot replication

1) replicate all of the trigger activity performed on the original table
2) distinguish between updates on a row and inserts/deletes on the same row? (If not, then cascade deletes are not properly performed)
3) properly handle cascading updates


If I understand your question correctly, that is not possible
with ANY replication in any database version.
Traditionaly, when one replicates a table, one only wants the data
of that table. What you are saying is that the entire schema
potentially dependent on that table might also need to be replicated?

If so, I suggest you look at Dataguard: it's the appropriate product
to achieve it and yes, it does the lot. To try and do that with
replication is to pay a huge overhead to achieve something that can
be done a lot more efficiently with different technology.


Noons --- IBM Informix Enterprise Replication supports this functionality
with about 1/3 the overhead of the original transaction.
Nov 12 '05 #257
Madison Pruet wrote:

Noons --- IBM Informix Enterprise Replication supports this functionality
with about 1/3 the overhead of the original transaction.


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?

Nov 12 '05 #258

"Noons" <wi*******@yaho o.com.au> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.com.. .
Madison Pruet wrote:

Noons --- IBM Informix Enterprise Replication supports this functionality with about 1/3 the overhead of the original transaction.


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?


Then why are you posting in comp.databases. informix?

You stated -

"If I understand your question correctly, that is not possible
with ANY replication in any database version."

That is simply not true. Now it may be true with the database that you are
using, but it is not true with IDS ER. There are replication solutions which
do support these functionalities , and yes - Informix ER does support them
with about 1/3 of the overhead of the original transaction.

I'm not playing any "mine is longer than yours" game. I'm simply pointing
out an incorrect statement which you made.

Nov 12 '05 #259
On 2 Aug 2005 17:54:03 -0700, "Noons" <wi*******@yaho o.com.au> wrote:
Madison Pruet wrote:

Noons --- IBM Informix Enterprise Replication supports this functionality
with about 1/3 the overhead of the original transaction.


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?


Ah, intellectual honesty . . . at last he 'fesses up.

I use ER under 9.4; it works quite well. Relatively low overhead . .
.. . and I'm looking forward to 10.00.

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.

JWC
Nov 12 '05 #260

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

Similar topics

47
3666
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...
35
3356
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...
9
2368
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)
2
2167
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...
0
1854
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...
29
3133
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?
6
14452
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...
190
8180
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...
5
3593
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...
51
3435
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
0
9602
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10237
Oralloy
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...
0
10071
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9882
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7431
isladogs
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...
0
6690
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5326
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...
2
3589
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2832
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.