Re: RPGLE I/O opcodes with commit/rollback

[Doug Davie <dougdavie@xxxxxxxxx>]

Is there a speaker out there that can give a full day presentation to a
user group on Journaling, Commit and Rollback?
> From how to setup journaling to commit and rollback techniques?
Including native RPG as well as SQL considerations?

Doug
NHMUG

On Thu, Nov 19, 2015 at 9:33 AM, <rob@xxxxxxxxx> wrote:

> Commitment control may be more popular with SQL because:
> 1 - The precompiler defaults to using commitment control.  It at least got
> people thinking about it, even if their only goal was to figure out how to
> use SET OPTION to turn it off.
> 2 - Certain SQL operations, like CREATE SCHEMA, default to creating
> journals and receivers so it just is a start.
> 3 - It's newer and you don't initially worry about 25 year old code and
> the problems with integrating with that.
>
> Journal receivers can consume disk space if not properly managed, or if
> you start to get so enthralled by the auditing capability that you keep
> them around for as long as we do.  (Not saying it's bad, but the disk
> salespeople love us.)
> Receivers can add some overhead.  There's way to code for this but we
> chose to just purchase "HA Journal Performance" and that made a huge
> impact!
>
> I wanted to journal for years but it was always put off.  Purchasing Mimix
> opened the floodgates.
>
> I suspect that many vendors do not implement journalling into their
> packages to not be considered a "resource hog".
>
> You kind of have to do this right.  Ever do a bunch of interactive SQL and
> signoff without doing the commit?  Losing your work does not put me into
> my happy place.
>
>
> 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:   "John R. Smith, Jr." <smith5646midrange@xxxxxxxxx>
> To:     "RPG programming on the IBM i \(AS/400 and iSeries\)"
> <rpg400-l@xxxxxxxxxxxx>
> Date:   11/18/2015 02:40 PM
> Subject:        RPGLE I/O opcodes with commit/rollback
> Sent by:        "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>
>
>
>
> I got into a heated conversation today about using the write / update /
> delete opcodes (not embedded SQL) and doing commits / rollbacks.  I said
> it
> could not be done but the other guy said he has done it.  He said he wrote
> RPG code that did opcode writes and updates (again, not via SQL) and was
> able to do rollbacks to remove the data from the write / update.
>
>
>
> Does anyone know of any way of doing this?
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.