Chapter 33 Further Reading

IBM Official Documentation

  • IBM Data Server Driver for JDBC and SQLJ https://www.ibm.com/docs/en/db2/11.5?topic=developing-java-applications Complete reference for the DB2 JDBC driver including connection properties, data type mapping, driver configuration, and troubleshooting. Essential for any Java developer working with DB2.

  • DB2 for z/OS: Application Programming Guide and Reference for Java (SC27-9846) Covers JDBC and SQLJ programming against DB2 for z/OS specifically. Includes z/OS-specific configuration, trusted contexts, and distributed data facility (DDF) setup.

  • IBM Db2 ODBC and CLI Reference https://www.ibm.com/docs/en/db2/11.5?topic=programming-odbc-cli Full CLI/ODBC API documentation including function reference, configuration keywords, and connection string parameters.

  • Python ibm_db Documentation https://github.com/ibmdb/python-ibmdb Official repository for the ibm_db Python driver. Includes installation guides, API reference, and examples for all supported platforms.

  • ibm_db_sa (SQLAlchemy Dialect) Documentation https://github.com/ibmdb/python-ibmdb_sa SQLAlchemy dialect for DB2. Covers engine URL format, supported SQLAlchemy features, and DB2-specific considerations.

Books

  • DB2 Developer's Guide by Craig Mullins (6th Edition) Comprehensive coverage of application development with DB2 including JDBC, ODBC, and CLI programming. The application development chapters provide both breadth and depth.

  • Java Database Best Practices by George Reese (O'Reilly) While not DB2-specific, this book covers JDBC best practices including connection pooling, prepared statements, transaction management, and performance optimization that apply directly to DB2 applications.

  • High-Performance Java Persistence by Vlad Mihalcea Deep dive into JDBC, JPA, and Hibernate performance. The connection pooling, batch processing, and statement caching chapters are directly applicable to DB2 JDBC applications.

  • Python for Data Analysis by Wes McKinney (3rd Edition) The definitive pandas reference. Covers read_sql, DataFrame operations, and data pipeline patterns used in Section 33.10.

  • SQLAlchemy: Database Access Using Python (Leanpub) Practical guide to SQLAlchemy's Core and ORM. Applicable to the ibm_db_sa patterns covered in Section 33.9.

IBM Redbooks

  • Modernizing IBM DB2 for z/OS Applications (SG24-8527) Covers migrating from embedded SQL to JDBC/ODBC access patterns, REST API access to DB2, and modern application architecture with DB2.

  • DB2 for z/OS and the Open Data Platform (SG24-8492) Integrating DB2 with modern data platforms including Python, Spark, and data lake architectures. Directly relevant to the data pipeline patterns in Section 33.10 and Case Study 33.2.

Online Resources

  • HikariCP Documentation https://github.com/brettwooldridge/HikariCP Configuration guide, pool sizing recommendations, and monitoring documentation for the most widely used Java connection pool.

  • About Pool Sizing by Brett Wooldridge https://github.com/brettwooldridge/HikariCP/wiki/About-Pool-Sizing The definitive article on connection pool sizing. Explains why smaller pools outperform larger ones, with mathematical proof.

  • pandas read_sql Documentation https://pandas.pydata.org/docs/reference/api/pandas.read_sql.html Official documentation for pandas SQL integration including chunked reading, parameterized queries, and engine configuration.

  • SQLAlchemy Documentation https://docs.sqlalchemy.org/ Complete SQLAlchemy documentation. The Engine Configuration, Connection Pooling, and ORM Tutorial sections are most relevant.

  • IDUG (International DB2 Users Group) https://www.idug.org Conference proceedings with presentations on JDBC performance tuning, Python integration, and modern DB2 application patterns.

  • Chapter 32 of this book: Embedded SQL — the traditional access method that these modern approaches complement
  • Chapter 19 of this book: Isolation Levels and Locking — understanding how JDBC/Python isolation settings map to DB2 behavior
  • Chapter 35 (forthcoming): Stored Procedures — callable from all access methods covered in this chapter
  • Chapter 38 (forthcoming): REST API Access to DB2 — HTTP-based access without drivers