Solution : https://service.sap.com/sap/support/notes/1385571 (SAP Service marketplace login required)
Summary :
This SAP note discusses the configuration nuances for connecting DB2 for IBM i using the PI JDBC Connector. It details connecting via sender or receiver channels and underscores the need for specific connection configuration due to complexities such expanded network configurations and remote data source availability. The document provides details on parameters such as `taskTimeout` and `sqlQueryTimeout` via IBM Toolbox JDBC Driver or JTOpen affecting the DB2 query behaviors, and introduces specific parameters like `socket timeout`, `login timeout`, and `keep alive` for the Toolbox Driver to manage TCP/IP-based database connectivity and ensure robustness in network disruptions or server unavailability. Recommendations for parameter settings like `keepAliveIdle` on different operating systems are also discussed to optimize performance.
Key words :
pi jdbc connector imposes special requirements, recommended pi-jdbc connector parameters, sap pi jdbc connector, open source equivalent jtopen, omitted tcp answer package, note describes special features, system triggers sql error 666, choose <val> significantly larger, existing connection suddenly fails, blocking tcp/ip request
Related Notes :
| 1078420 | XI/PI JDBC Adapter: Setting JDBC driver properties for DB |
| 934468 | IBM i, FAQ: JDBC error analysis |
| 924753 | iSeries: JAVA DataSources for external DB4 data sources |
| 654800 | FAQ: JDBC driver certified for SAP on IBM i |