Re: Commitment Control - Duplicate Key

I can run this by IBM. It makes sense to me why it does it, now I just
need some documentation to back me up on it.

Thanks for your help.
James Salter
Systems Programmer
American Cast Iron Pipe Company
phone (205) 325-3033
fax (205) 307-3833



from: Charles Wilt <charles.wilt@xxxxxxxxx>
subject: Re: Commitment Control - Duplicate Key

Jame,

Yes, I saw the PT & DR entries (and a CPF83E1) when I tried it under
commitment control.

No entries if commitment control wasn't being used.

Did a little googling but didn't see anything relevant.

I'd be willing to bet it's working as designed....
As I understand it, the journal entry gets written before anything
else happens to the data.
I'm guessing that the system puts the PT out there even when CC isn't
being used, but "removes(?)" the entry when the constraint fails.

With CC, it doesn't need to bother going back and removing the entry
and for performance reasons, can simply add the DR entry.

But assuming you're current on maint. Open a PMR and ask IBM.

Charles

On Wed, May 20, 2009 at 1:21 PM, Salter, James <JSalter@xxxxxxxxxx>
wrote:

Thanks, Charles.

So you were able to perform an insert under commitment control for an
item that already existed, thereby creating an additional PT journal
entry?

I wanted to make sure that this wasn't some O/S bug that I needed to
fix.

Not to get into to much detail, but this additional journal entry

causes

issues down the line for me.

Of course the system that is trying to create the item that already
exists (the Oracle Transparent Gateway) should already know that the
item exists.

James Salter
Systems Programmer
American Cast Iron Pipe Company
phone (205) 325-3033
fax ? ? ?(205) 307-3833



from: Charles Wilt <charles.wilt@xxxxxxxxx>
subject: Re: Commitment Control - Duplicate Key

James,

I don't have any links for you....but playing around with the
issue...I notice that the PT entry only shows up if the record was
inserted under commitment control.

Charles


On Wed, May 20, 2009 at 10:14 AM, Salter, James <JSalter@xxxxxxxxxx>
wrote:

I have a situation where we have a record that already exists in the
database (uniquely keyed file), yet I am seeing PT journal entries

for

the same item under commitment control and a follow up DR journal

entry.

The commitment control process was never committed, it errored out

and

was rolled back.

Can you have PT journal entries under commitment control for records
that already exist?

Documentation or a link to where this is possible would be

appreciated,

otherwise it looks like a call to IBM.

Thanks.
James Salter
Systems Programmer
American Cast Iron Pipe Company
phone (205) 325-3033
fax (205) 307-3833

_________Confidentiality Notice_______________________
This e-mail and any files transmitted with it is
confidential and is intended solely for the use of
the individual(s) or entity(ies) to whom this e-mail
is addressed. If you are not the intended recipient
or the person responsible for delivering the e-mail
to the intended recipient, be advised that you have
received this e-mail in error, and that any use,
disclosure, dissemination, forwarding, printing,
retention or copying of this e-mail is strictly
prohibited. If you have received this e-mail in
error, please immediately return this e-mail to
the sender and delete the e-mail from your system.
Thank you.