Data Warehouse - Database Connection Problems
There are some connection properties I am not fully understanding in our Reporting (JTS Data Warehouse Connection) settings because the server setup seems to set them incorrectly and we're not sure why.
We have a distributed system: 1 server for each of JTS, RTC, and RRC as well as one server for the database (SQL).
In the JTS Data Warehouse Connection properties, what are:
JDBC Location
and
DB2z data warehouse database name
?
Thanks!
One answer
JDBC Location refers to the database connection string. In the case of DB2, the connection string will look something like this:
//db2.ibm.com:50000/JTS:user=db2inst1;password={password};
The schema prefix is only required in the case your DB2 server is on z/OS (it's how we support multiple instances of the data warehouse on DB2 for z/OS). If that is not the case, you can leave it blank. Hope it helps,
//db2.ibm.com:50000/JTS:user=db2inst1;password={password};
The schema prefix is only required in the case your DB2 server is on z/OS (it's how we support multiple instances of the data warehouse on DB2 for z/OS). If that is not the case, you can leave it blank. Hope it helps,