Fw: Fw: Company thought DB2 will be better than Oracle.

[Mark Denham]

----- Original Message -----
From: "Mark Townsend" <markbt...@attbi.com>
To: <inform...@iiug.org>
Sent: Friday, September 26, 2003 00:02
Subject: Re: Fw: Company thought DB2 will be better than Oracle.

> Obviously sent from a 2 node RAC cluster. The first post was simply
> gratuitous, the second mere stupidity.
>
RAC??? Isn't that an emergency vehicle recovery service in the UK? Aid for
the stupid, something like that.

sending to informix-list

[Mark Denham]

> Flashback Query
>
You mean the system forgets what it was doing and has to be reminded? I'm
impressed. I thought it was only humans that suffered Altzeimers.
>
> Virtual Private Database (Policy based security)
>
As opposed to a really private one. Is this akin to a latrine with the door
hanging off? That's virtually private too.
>
> Automated Memory Management
>
To counter flashbacks no doubt.
>
Great!!! When are they going to get any of them working on anything more
complex than a slide projector?

You almost got my money

sending to informix-list

[Daniel Morgan]

Mark Denham wrote:

Flashback Query
    

You mean the system forgets what it was doing and has to be reminded? I'm
impressed. I thought it was only humans that suffered Altzeimers.

Try this in informix.

TRUNCATE TABLE <table_name>;

or

DELETE FROM <table_name>;
COMMIT;

If you can then recover all of the records that were in the table to a previous transaction point or
point-in-time within a few minutes without running for the backup tapes you don't need flashback.
Otherwise ... you might just find it handy.

Great!!! When are they going to get any of them working on anything more
complex than a slide projector?

You really should take my class at the University of Washington. We do it real-time for every class, I
don't allow slide projectors or PowerPoint in my classroom. And each and every student does it on
their own machine. It is really rather elementary to do and extraordinarily powerful.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damo...@x.washington.edu
(replace 'x' with a 'u' to reply)