Problem with DB2_USE_ALTERNATE_PAGE_CLEANING
in [DB2]
|
Prev: Perl DBD DB2
Next: Instance Crash
From: Hemant Shah on 27 Sep 2006 13:31 While stranded on information super highway memmerto(a)yahoo.com wrote: > > Hemant Shah wrote: >> While stranded on information super highway memmerto(a)yahoo.com wrote: >> > >> > Hemant Shah wrote: >> >> >> 2) If my last commit was at 30000th row how did the extra rows get commited? >> >> > >> >> > Take note that the explicit commits done by the utilities (as specified >> >> > by COMMITCOUNT) are not the only commits that will be done. DB2 will >> >> > issue internal commits in certain situations. >> >> >> >> This does not make sense. Why would DB2 commit the data without explicit >> >> commit, what happens when a process encounters error and does a roll back >> >> (which my application did when it received -964)? >> >> >> >> In my case I end up with extra rows that I did not expect. In this case >> >> it did not make difference because I can start loading the table again, >> >> but it could be disasterous in OLTP environment. >> > >> > Please show me the full LOAD command that you are using, and I can >> > explain more. >> >> I am not using LOAD command. My application loops through a file and >> reads data in proprietory format, decodes it and runs INSERT command. >> >> It executes COMMIT every 5000th row. If it encounters error, it does >> ROLLBACK and exits. >> >> Last commit was on 30000th row, and it gets -964 after that, application >> does ROLLBACK and exits. I should not have more than 30000 rows in the table. >> >> Again, this only happens if DB2_USE_ALTERNATE_PAGE_CLEANING is set to YES. > > What type of interface does your application use to talk to DB2? CLI? > Static C? JDBC? Static C (EXEC SQL). > > -- > Matt Emmerton > -- Hemant Shah /"\ ASCII ribbon campaign E-mail: NoJunkMailshah(a)xnet.com \ / --------------------- X against HTML mail TO REPLY, REMOVE NoJunkMail / \ and postings FROM MY E-MAIL ADDRESS. -----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------ I haven't lost my mind, Above opinions are mine only. it's backed up on tape somewhere. Others can have their own. |