load-insert with no rollback ?

HI, Folks IDS12.10 FC4 I was loading big amount of data to a table, begin work; lock table hist201511_lin_source in exclusive mode; load from hist_lin_source.data insert into hist201511_lin_source ;commit work; later, it was running of dbspace , and session was terminated by IDS, 22:05:57 Warning: The storage pool is out of space. To enable automatic chunk creation use the OpenAdmin Tool to add space to the pool. 22:05:57 WARNING: DBspace dwdata04 is full 22:08:26 Checkpoint Completed: duration was 5 seconds. I was thinking all the so far loaded data would be rolled back (purged), but to my surprise, the partial data loaded before running of dbspace , is still in the table ( NO transaction rollback, even the session was terminated by IDS). Any comments? Thanks Frank --001a114584daebb8d4052550d47d

When the engine interrupted the INSERT statement dbaccess executed the next line which was the COMMIT WORK. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Nov 24, 2015 at 5:26 PM, FRANK <yunyaoqu@gmail.com> wrote: > HI, Folks > > IDS12.10 FC4 > > I was loading big amount of data to a table, > > begin work; > lock table hist201511_lin_source in exclusive mode; > load from hist_lin_source.data > insert into hist201511_lin_source ;> commit work; > > later, it was running of dbspace , and session was terminated by IDS, > > 22:05:57 Warning: The storage pool is out of space. To enable automatic > chunk > > creation use the OpenAdmin Tool to add space to the pool. > 22:05:57 WARNING: DBspace dwdata04 is full > 22:08:26 Checkpoint Completed: duration was 5 seconds. > > I was thinking all the so far loaded data would be rolled back (purged), > but to my surprise, the partial data loaded before running of dbspace , is > still in the table ( NO transaction rollback, even the session was > terminated by IDS). > > Any comments? > > Thanks > Frank > > --001a114584daebb8d4052550d47d > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bd75288277469052550e105

Dbaccess ? export DBACCNOIGN=1 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK Sent: Tuesday, November 24, 2015 4:27 PM To: ids@iiug.org Subject: load-insert with no rollback ? [36114] HI, Folks IDS12.10 FC4 I was loading big amount of data to a table, begin work; lock table hist201511_lin_source in exclusive mode; load from hist_lin_source.data insert into hist201511_lin_source ;commit work; later, it was running of dbspace , and session was terminated by IDS, 22:05:57 Warning: The storage pool is out of space. To enable automatic chunk creation use the OpenAdmin Tool to add space to the pool. 22:05:57 WARNING: DBspace dwdata04 is full 22:08:26 Checkpoint Completed: duration was 5 seconds. I was thinking all the so far loaded data would be rolled back (purged), but to my surprise, the partial data loaded before running of dbspace , is still in the table ( NO transaction rollback, even the session was terminated by IDS). Any comments? Thanks Frank --001a114584daebb8d4052550d47d **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Thank you Art and Paul! I see the reason. Frank On Tue, Nov 24, 2015 at 5:43 PM, Paul Watson <paul@oninit.com> wrote: > Dbaccess ? > > export DBACCNOIGN=1 > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > FRANK > Sent: Tuesday, November 24, 2015 4:27 PM > To: ids@iiug.org > Subject: load-insert with no rollback ? [36114] > > HI, Folks > > IDS12.10 FC4 > > I was loading big amount of data to a table, > > begin work; > lock table hist201511_lin_source in exclusive mode; > load from hist_lin_source.data > insert into hist201511_lin_source ;> commit work; > > later, it was running of dbspace , and session was terminated by IDS, > > 22:05:57 Warning: The storage pool is out of space. To enable automatic > chunk > > creation use the OpenAdmin Tool to add space to the pool. > 22:05:57 WARNING: DBspace dwdata04 is full > 22:08:26 Checkpoint Completed: duration was 5 seconds. > > I was thinking all the so far loaded data would be rolled back (purged), > but to my surprise, the partial data loaded before running of dbspace , is > still in the table ( NO transaction rollback, even the session was > terminated by IDS). > > Any comments? > > Thanks > Frank > > --001a114584daebb8d4052550d47d > > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113a9b5625f81e05255f967b