Commit Doubt

somu_june · Post by **somu_june** » Thu Mar 09, 2006 9:05 am

Hi,

Iam having a requirement like this . Iam getting a message and it was parsed by xml and Iam inserting or updating or deleting the records in DB2 API stage . After entire XML message has been processed (i.e either inserted or updated or deleted ) then I need to commit the table. I read in some posts that I can use APT_RDBMS_COMMIT_ROWS and is there any option in stage DB2 API like transaction size.Can I use transaction size to commit the rows.If Iam wrong correct me

Thanks
Somaraju

ArndW · Post by **ArndW** » Thu Mar 09, 2006 9:20 am

The commit frequency is the transaction size in your stage.

DSguru2B · Post by **DSguru2B** » Thu Mar 09, 2006 9:39 am

The commit frequency as mentioned by Andrw, would help you acheive the goal. The default I beleive is 1000 rows.
Most of the time you dont have rollback privelages, so decide before you commit anything.