It's all about the answers!

Ask a question

Data Warehouse - Database Connection Problems


Dave Evans (14812646) | asked Dec 05 '13, 8:05 p.m.

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



permanent link
Benjamin Silverman (4.1k610) | answered Dec 05 '13, 8:12 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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,

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.