Continue after suspend

Hello IDS 11.10FC2W1 on solaris 10 In one of the load activites i got a an error saying that no more extents can be added,my chunks were completely used 847: Error in load file line 5262575. table. 136: ISAM error: no more ex and the transaction was aborted after adding (count(*)) 5262574 pls let know it there is there is some way that will suspend(halt) the transaction rather then aborting it and allow me to add new chunk and continue that activity again from the point it has halted? Regards vikas

Not directly. What you can do is to use dbload instead of the dbaccess LOAD verb. Dbload can be told to commit every N rows so that you will only have to roll back at most N-1 rows. Dbload will give you sufficient information to use the -i <nrows> option to skip the rows that were already processed so that you can reload just the tail end of the file. Art On Fri, Jun 27, 2008 at 1:52 AM, VIKAS HIVARKAR <vikas.hivarkar@tcs.com> wrote: > Hello > > IDS 11.10FC2W1 on solaris 10 > > In one of the load activites i got a an error saying that no more extents > can > be added,my chunks were completely used > 847: Error in load file line 5262575. table. 136: ISAM error: no more ex> > and the transaction was aborted after adding > (count(*)) > > 5262574 > > pls let know it there is there is some way that will suspend(halt) the > transaction rather then aborting it and allow me to add new chunk and > continue > that activity again from the point it has halted? > > Regards > vikas > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Thanx Mr Kagel !

Change the BD state to NOLOGGING with 'ontape -s -N <nameBD>' or create your table in raw type. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of VIKAS HIVARKAR Sent: Viernes, 27 de Junio de 2008 12:52 a.m. To: ids@iiug.org Subject: Continue after suspend [12526] Hello IDS 11.10FC2W1 on solaris 10 In one of the load activites i got a an error saying that no more extents can be added,my chunks were completely used 847: Error in load file line 5262575. table. 136: ISAM error: no more ex and the transaction was aborted after adding (count(*)) 5262574 pls let know it there is there is some way that will suspend(halt) the transaction rather then aborting it and allow me to add new chunk and continue that activity again from the point it has halted? Regards vikas ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.