Thx, I did open a PMR and asked IBM to clarify which “instance” they are referring to.
/Gus
From: [email protected] [mailto:[email protected]] On Behalf Of [email protected]
Sent: den 21 februari 2013 20:41
To: Discussion list for Tivoli product and Tivoli Ready products.
Subject: Re: [TME10] cq.ini KFW* entries for DB2 Warehouse. SOLVED!
Thanks for circling back to let us know the solution, Gus. It's nice when it actually makes sense. :-)
On Thu, Feb 21, 2013 at 10:37 AM, <[email protected]<mailto:[email protected]>> wrote:
Finally nailed it!
When configuring DB2 as WH db in TEPS configuration it ask for 4 things:
Instance
Database name
Uid
Password
Now since my DB2 db is remote from my teps server, Databse Instance is the local instance name of the DB2 client, which seems to default to the uid installing the client. Did so in my case anyways. User called tems
On remote DB2 server on windows instance name is DB2
On TEPS DB2 (db2 client) instance name is tems (in my case)
So I changed from DB2 to tems as instance name in teps configuration and the TEPS GUI is returning history data Yiha!
/Gus
From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of [email protected]<mailto:[email protected]>
Sent: den 18 februari 2013 09:08
To: [email protected]<mailto:[email protected]>
Subject: RE: [TME10] cq.ini KFW* entries for DB2 Warehouse.
Hi, I’m using a type4 driver. WHP is using it on the same box. I will try and run itmcmd manage despite port regulations…..
/Gus
From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of [email protected]<mailto:[email protected]>
Sent: den 16 februari 2013 00:12
To: Discussion list for Tivoli product and Tivoli Ready products.
Subject: RE: [TME10] cq.ini KFW* entries for DB2 Warehouse.
Yeah, the username, password and TDW URL are all encrypted. Anyway, despite the fact that you're using a type 4 (aka "Universal") jdbc driver--and thus should NOT need any DB2 products installed on the TEPS--because the DB2 runtime client is free, just install it on the TEPS and catalog the remote TDW node and dbase and see if things magically work. Otherwise you *might* be using a type 2 driver which doesn't utilize the DRDA architecture that type 4 uses...which can be verified by issuing:
com.ibm.db2.java.jcc.DB2Jcc -version
...assuming the db2jcc.jar is in your class path.
On Feb 15, 2013 9:26 AM, <[email protected]<mailto:[email protected]>> wrote:
Hi no I didnt replaced them with my interp. (-:
But I think that the DB2 Warehouse connection from a linux TEPS uses the DB2 client. The doc says to catalog the remote Warehouse DB which does’nt, make sense if you are running JDBC. Besides I think that the example I took was from someone who moved from Oracle Warehouse to DB2. Oracle Warehouse is using JDBC for sure. And this case deletes the references to Oracle when configuring teps.
But the thing that puzzles me is that itmcmd manage (which I cant run) has Warehouse references to jdbc driver jdbc url etc. for DB2. So I’m a bit confused now on what the Warehouse connection is really using. Therfore I asked for cq.ini ref’s. But I just found out that the reference in cq.ini is encrypted SIGH!
/Gus
From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Venkat Saranathan
Sent: den 15 februari 2013 15:37
To: Discussion list for Tivoli product and Tivoli Ready products.
Subject: Re: [TME10] cq.ini KFW* entries for DB2 Warehouse.
Gus,
You haven't tried adding them verbatim, have you? The value for <arch> should be "lx8263". Also, make sure that you are replacing the existing values (if available), not adding duplicating rows. You probably did the right way but just thought of checking that first.
with warm regards,
Venkat Saranathan
Gulf Breeze Software.
Visiting Pulse 2013? Stop by our booth in the Expo and ask your Tivoli questions.
On Fri, Feb 15, 2013 at 6:33 AM, <[email protected]<mailto:[email protected]>> wrote:
Hi all.
When I installed my teps on RHEL a chose not to configure a TDWH. It runs on Derby as TEPS DB.
Node and db is cataloged on the DB2 client installed on the box. Not sure if it is needed for TEPS->TDWH connection though, since it looks like below it is using JDBC? DB2 is at version 9.7 on a remote windows server. S&P + WHP is running fine and I can see data flowing to TDWH tables.
When I go back and run itmcmd config –A cq I don’t get prompted for more than DB2, Database name, user and pwd
Googled around a bit and found (http://www-01.ibm.com/support/docview.wss?uid=swg21394004) that I need:
<arch>|WHCLASS|
<arch> |WHDB2ATTR|KFWJDBCDRIVER=;KFWDSURL=;|
<arch>|WHURL|
In */.ConfigData/kcqenv
Tried adding these empty rows to the file and reran config of teps. Same result no questions to add these.
I can’t run X either due to port restrictions so itmcmd manage is not an option.
Can someone share KFW_* cq.ini entries for a remote TDWH on DB2?
/Gus
_______________________________________________
TME10 mailing list
[email protected]<mailto:[email protected]>
Unsubscribe:[email protected]<mailto:Unsubscribe%[email protected]>
_______________________________________________
TME10 mailing list
[email protected]<mailto:[email protected]>
Unsubscribe:[email protected]<mailto:Unsubscribe%[email protected]>
_______________________________________________
TME10 mailing list
[email protected]<mailto:[email protected]>
Unsubscribe:[email protected]<mailto:Unsubscribe%[email protected]>
--
"Sometimes I think that's the only right thing to do:
To dream. to live in the world of dreams.
But it doesn't last forever--wakefulness always comes to take me back..."
_______________________________________________
TME10 mailing list
[email protected]
Unsubscribe:[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.