All geek questions in one place

Is there a limit on the size of a DB2 JDBC transaction?

I need to insert a large number of rows (up to 100,000) into 6 different DB2 tables. I am using Java JDBC for this. I would like to do all this in one database transaction so that all this can be discarded if any problems arise. Is there any limit (in the JDBC driver or in DB2) how many attachments can be processed in one transaction? We are using DB2 version 8.

+3
source share
1 answer

The size of a single transaction is limited by the size of the database transaction logs. With a sufficiently large transaction log, you can do what you ask.

, DB2, Linux/UNIX/Windows - LOGFILSIZ ( ), LOGPRIMARY ( ) LOGSECOND ( ).

+2

Source: https://habr.com/ru/post/1793057/

More articles:


All Articles