Re: Two trigger programs allowed on a file. Maybe more allowed?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

I never got a t-shirt... :(

Charles


On Mon, May 20, 2013 at 12:09 PM, Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>wrote:

> Hey Ray!
>
> Is it the orange T-shirt? Or a white one with boring blue and black
> design? Seems I was also involved with the UCD sessions back then - was
> working at Centerfield Technology in Rochester at the time.
>
> Cheers
> Vern
>
> ----- Original Message -----
> Now that I didn't know!  Of course after seeing Rob's response, maybe my
> best bet is to do both!
>
> Thanks so much.  Anything that improves my performance is highly
> appreciated.
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
> midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of TheBorg
> Sent: Monday, May 20, 2013 10:07 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: Two trigger programs allowed on a file. Maybe more allowed?
>
> I quit using the search feature in the IBM Information Center.
>
> I now use Google to search for stuff on IBM sites, using 'site:ibm.com"
> in the search string to force it to search the IBM site.
>
> In fact, I attended a User-Centered Design session (got a T-shirt!) in
> Rochester almost 10 years ago and expressed my frustration with the search
> feature in the Information Center, and some of the IBM'ers admitted that it
> wasn't very good.
>
> - sjl
>
>
> "Raymond B. Dunn"  wrote in message
> news:mailman.4859.1369061731.7202.midrange-l@xxxxxxxxxxxx...
>
> I use the search function on the IBM website.
>
> My comments may have been a little strong, but lately I have really had
> problems finding things in the manuals.
>
> I am the cutting edge guy here, so I have no one to bounce things off of.
> In addition, I am the one who is expected to be able to resolve the
> problems none of my coworkers are able to.  I have two resources: You guys
> (thank
> god) (and the other internet sites) and the manuals.  I would love to be
> able to effectively use the manuals.  I just seem to have a great deal of
> trouble finding things in the manual, which in the past was never a problem.
>
> That said, the system we work on has evolved so far from V5R1 that I know
> there has to be more complexity in the manuals.  It just seems like there
> should be some kind of middle ground.
>
> I very much appreciate your assistance Rob, Brent
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
> Sent: Monday, May 20, 2013 9:36 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: Two trigger programs allowed on a file. Maybe more allowed?
>
> Don't blame it on the manuals - blame it on misuse of the manuals.
> You CANNOT use the top url in your browser to get to the point you are
> currently at in the manual.
> You need to find a point which will point to that point.  A blue
> highlighted area for example like
> http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzlimtabs.htm
> In Firefox I right click on the blue highlighted area and select "Copy
> Link Location".
>
> Information Center, Availability, Database and SQL limits, SQL limits
>
> Triggers
> Maximum number of triggers on a table   300
>
> You can also search Infocenter for system limitations.  That's how I
> originally found this.  Back in the old manuals you are so fond of I don't
> think they had this.  It was a separate manual entitled system limitations
> or some such thing.
>
> If you search for Maximum triggers you will see SQL Limits on the results
> list, granted tis would have been nice to be closer to the top.
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   "Raymond B. Dunn" <Raymond.Dunn@xxxxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
> Date:   05/20/2013 10:26 AM
> Subject:        RE: Two trigger programs allowed on a file.  Maybe more
> allowed?
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> Really?  It took me to a generic V7R1 screen.  I even tried to search for
> maximum number of triggers in the DB2 manual.  Nothing.
>
> Again, this is an example of how IBM has made the manuals absolutely
> worthless.  I would love to take the person in charge of the V7R1 manuals
> and beat him/her within an inch of their life.
>
> I can remember back when the manuals were an asset.  Thank god for the
> internet and non-IBM information resources.
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [
> mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
> Sent: Monday, May 20, 2013 8:52 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: Two trigger programs allowed on a file. Maybe more allowed?
>
> Eric,
> This link shows a max of 300
> http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/index.jsp
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [
> mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Eric Lehti
> Sent: Monday, May 20, 2013 7:45 AM
> To: Midrange Systems Technical Discussion
> Subject: Two trigger programs allowed on a file. Maybe more allowed?
>
> I succeeded in attaching a second trigger program to a file yesterday.
> Happy.  I did not realize that system will allow more than one trigger
> program.
>
> I did not want to modify the existing (first) program trigger that tracks
> sales order totals in real-time.
>
> I created second trigger program with JD Edwards DBAM (data base audit
> manager) to identify which process is changing info in one field.
>
> How many trigger programs will system allow on a file?  I will find out
> someday.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.