App Connect

App Connect

Join this online user group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#Applicationintegration
#App Connect
#AppConnect
 View Only
Expand all | Collapse all

JDBC Driver Property Question: maxTransportObjects

  • 1.  JDBC Driver Property Question: maxTransportObjects

    Posted Mon August 17, 2020 02:39 PM

    Hello,

     

    Connecting javaApp to Db2 for z/OS v11…

     

    In version 4.19, I see the maxTransportObjects default = 1000

     

    What I'd like to know is, what is the upper limit of the maxTransportObjects property?  I've cruised through a bunch of documentation and can't find an upper limit for the property.

     

    Can anyone help here?

     

    Thanks,



    ------------------------------
    Jonathan Brown
    ------------------------------


  • 2.  RE: JDBC Driver Property Question: maxTransportObjects
    Best Answer

    Posted Tue August 18, 2020 07:02 AM
    Hi Jonathan,
    I would expect the upper limit to be unlimited ( -1 ).
    Based on Adrian Burke (DB2 for z/OS SWAT team ) the default used to be Unlimited, now the default is 1000.
    There are some highly technical documents / presentations that try to explain the meaning of maxTransportObjects and similar parameters in more detail.
    http://www.codug.org/presentations/2016-08-16%20Distributed%20Strategy%20in%20the%20Mobile%20Age.pdf
    http://www.alabamadb2usersgroup.org/2017-spring-presentations/ADUG-stale-conns.pdf

    https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_r0053795.html

    ------------------------------
    Matthias Jungbauer
    ------------------------------