Implementing DB2 with ReportCenter › Multiple DB2 JDBC Applications

Multiple DB2 JDBC Applications

If you have DB2 JDBC applications and ReportCenter, each application may need access to different DB2 subsystems, DBRM libraries, and different and perhaps mutually exclusive runtime JDBC properties. To do this:

• Have a separate JDBC runtime properties file for each application. Each file contains the DB2 subsystem name, DBRM library, and JDBC parameters required by that specific application.
• Customize the JDBC profile and bind the DBRMs separately for each application.
• For ReportCenter, specify its JDBC properties file in the REPORTCENTER parameter group.
• For each of the other applications, use a separate $HOME/.profile file. This file points to an application's separate JDBC properties file.