Db2 11.1 for z/OS and Spring Batch

Daniel Luksetich

Db2 11.1 for z/OS and Spring Batch
Anyone have any experience with Spring Batch and Db2? We are attempting to
create a file driven process as well as a cursor driven process. What we use
for chuck size and commit interval has not translated into what we would
think of as Db2 units or work. Basically, every query comes through as it's
own transaction. For example, we have an 11 records input file, and 4 Db2
cursors. This becomes 44 transactions in Db2, one per cursor per record. In
addition, we disabled autocommit and now every transaction rolls back
instead of committing.

Thanks,

Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

IBM Certified Database Adminstrator - DB2 11 DBA for z/OS

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Application Developer - DB2 11 for z/OS

IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and
Windows