• Subject: Re: File Read
  • From: Gary Guthrie <GaryGuthrie@xxxxxxxx>
  • Date: Thu, 17 Feb 2000 08:50:27 -0600

> Since I asked the original question, how does one go about requesting
> such a thing from IBM?


It's somewhat interesting to be reading this thread. It's a deja vu kind
of thing for me.

A few years ago, I (and my partner) went to IBM database folks and
presented what we felt was a strong argument for READ triggers. We
prefaced our discussion with the acknowledgement that there would be
serious performance considerations, but that we felt that because of
the, at that time, contemporary reason we wanted READ triggers that the
performance issue might be acceptable, at least for a limited time.

One could argue that there is a performance issue for INSERT and UPDATE
triggers, so what's the big deal about READ trigger performance worries.
The difference is that there are almost always VASTLY more READs issued
that INSERTs or UPDATEs.

The argument we presented to IBM centered on Y2K. We were considering
putting together what we felt would have been the quintessential Y2K
tool. The tool's basic premise was to let normal, everyday operations
identify (at least to a great extent) where dates were being used and
keep track of not only where they were used, but keep statistics as to
the frequency of their use. In so doing, considerable quantification of
the work necessary to fix Y2K problems would be captured by users simply
doing their jobs. The tool would "learn" where exposures were and the
data gathered as to the frequency of use would give us a great impact
analysis payback. With that data, priorities could be set as to what
needed attention first, etc.

The tool, in my opinion, would have greatly eased the burden on IBM's
AS/400 customers. We simply asked IBM for a READ trigger so that we
could provide the function to customers. We even went down the road of
mentioning patching the SEPT as Leif has discussed, just so IBM knew we
had some amount of knowledge.

As you know, we didn't get the READ trigger, even given what I feel was
compelling reason to consider it. Bottom line -- good luck getting IBM
to listen, now. Keep trying, though.

Gary Guthrie
+---
| This is the MI Programmers Mailing List!
| To submit a new message, send your mail to MI400@midrange.com.
| To subscribe to this list send email to MI400-SUB@midrange.com.
| To unsubscribe from this list send email to MI400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: dr2@cssas400.com
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.