Re: COMMIT Needed?

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

I don't see anything that looks odd. I guess CREATE INDEX can't be
created with NC?

On 1/16/07, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
> Try this again.  But run STRDBG UPDPROD(*YES) before you do a STRSQL. When
> you exit STRSQL do a DSPJOBLOG and see if anything sticks out.
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> "Michael Ryan" <michaelrtr@xxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 01/16/2007 08:30 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> "Midrange Systems Technical Discussion" <MIDRANGE-l@xxxxxxxxxxxx>
> cc
>
> Subject
> COMMIT Needed?
>
>
>
>
>
>
> I had a process where I did an INSERT with NC into a table. It took
> over 5 minutes. I then did a CREATE INDEX, the same INSERT, and a DROP
> INDEX. Total time now 45 seconds. Obviously much better. However, when
> I exited Interactive SQL, I needed to do a COMMIT (or ROLLBACK). I
> determined it was as a result of the CREATE INDEX. Why is that?
> Thanks...
> --
> 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.