Database Connection Cannot Be Established -- No Suitable SQLJ/JDBC Driver
12-1
Symptom:
I see the following message in the ReportCenter Java Task log:
Cannot establish database connection. Message: No suitable driver…
Solution:
Ensure that you have implemented the REPORTCENTER parameter group in the ReportCenter control region correctly. Ensure that the parameter group is correct in terms of the HFS path for DB2 JDBC classes and the DB2 subsystem location name, for example:
REPORTCENTER - ReportCenter Control Region DB2 Database and JDBC information: (Get these values from your DB2 DBA) JDBC Driver Name .............. ibm.sql.DB2Driver JDBC Class File (eg. /usr/lpp/db2/db2710/classes/db2j2classes.zip ) /sys/usr/lpp/db2/db2710/classes/db2j2classes.zip JDBC DLL Directory (eg. /usr/lpp/db2/db2710/lib ) /sys/usr/lpp/db2/db2710/lib JDBC Properties File (eg. /usr/lpp/db2/db2710/classes/db2sqljjdbc.properties ) /sys/usr/lpp/db2/db2710/classes/db2sqljjdbc.properties
Carry this information through to the last five lines of the Adaptor.ini file as follows:
For the Legacy Driver
WebReportsDB2JDBC.driver=ibm.sql.DB2Driver WebReportsDB2JDBC.url=jdbc:db2os390: WebReportsDB2JDBC.SQLType=DB2
For the Universal Driver using Type 2 Connectivity
WebReports.driver=com.ibm.db2.jcc.DB2Driver WebReports.url=jdbc:db2:Db2LocationNameWebReports.SQLType=DB2
For the Universal Driver using Type 4 Connectivity
WebReports.driver=com.ibm.db2.jcc.DB2Driver WebReports.url=jdbc:db2://Ipaddress:port/Db2LocationNameWebReports.user=user WebReports.password=password WebReports.SQLType=DB2
Database Information Cannot Be Retrieved
Symptom:
I see the following message in the ReportCenter Java Task log:
Cannot get database information: DB2JDBCCursor Received Error in Method prepare:SQLCODE==> -551 SQLSTATE ==> 42501 Error Tokens ==> <<DB2 6.1 ANSI SQLJ-0/JDBC 1.0>>jsnameSELECT SYSIBM.SYSxxxxxxcom.ca.syd.utils.datawarehouse.ExpiryService.009
Solution:
Ensure that you have run the statements in the supplied CC2DSAMP(WRBD2GRA) member.
Key Range Does Not Exist
Symptom:
I see the following message in the ReportCenter Java Task log:
Key range for tabledatabase-table-namedoes not exist
Solution:
Review the following points, and take appropriate action:
- In the db2sqljjdbc.properties file, ensure that your DB2 subsystem name is specified correctly.If you find a problem, correct the file. Rerun the db2genJDBC utility and the DSNTJJCL job to recreate and rebind the DBRMs.
- In the output of the WRDB2CRE job, ensure that no errors were encountered, and that all table spaces, tables, and indexes are created correctly.
- The DB2 subsystem that contains your ReportCenter databases has been brought down while you have been collecting data. Restart the ReportCenter Java Task so that new database connections can be obtained.