Block fetch in Java

william giannelli

Block fetch in Java

For DB2, is it possible to do a block fetch using Java?

thanks

Bill

Daniel Luksetich

Block fetch in Java
(in response to william giannelli)
Bill, which Db2? If it is a Db2 for z/OS and it is a type 4 connection from a remote client then you get block fetching automatically. I believe, but not sure, if it is a local connection using type 2 then you do not get block fetching. There is no way to program for block fetching, although Java does allow you to “block” transitions. I have used blocking successfully in a JDBC application with minimal performance gain. Not worth the effort.



Block fetching is also dependent upon unambiguous cursors and proper current data setting. Always code “FOR READ ONLY”.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

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



From: william giannelli [mailto:[login to unmask email]
Sent: Friday, February 23, 2018 8:50 AM
To: [login to unmask email]
Subject: [DB2-L] - Block fetch in Java



For DB2, is it possible to do a block fetch using Java?

thanks

Bill



-----End Original Message-----