Re: Commit in DB2/MVS

[Parijat Sahai <parijatsahai@HOTMAIL.COM>]

Why don't you post the code in question? Maybe issuing a COMMIT between
FETCHes is causing the problem (loss of Cursor handle perhaps - don't
know if it makes sense in MVS).

Parijat.

>
>I am using DB2 version 4 and SQR version 4 on windows NT and MVS
>mainframe.
>I have an sqr program that issues a commit after x number of records
are
>processed.
>When I run it on the NT/Client it runs ok, when I run it on the MVS
>server it abends after the commit is executed.  The commit is actually
>working, but it seems to blow up on a select after the commit.   The
>program runs ok on MVS with the 'commit' commented out.  This is a
>conversion program that will load a large volume of data and needs to
do
>a commit periodically.
>
>Has anyone else run into this???
>
>
>DSN      ENDED DUE TO ERROR+
> SYSTEM ABEND CODE 04E   REASON CODE 00E7000C  PSW 077C100087713180
>ASIDS:  HOME
>1LSCX041 **** ERROR ****
>         ABEND occurred in line  1020 of    SQ043(SQ048)  ,offset
000390
>
>         Program terminated by operating system. ABEND code = S04E
>         A non-C or system routine was running at the time of ABEND
>


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com