Re: 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]> 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]] *On Behalf Of *[email protected]
> *Sent:* den 18 februari 2013 09:08
> *To:* [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] <[email protected]>] *On
> Behalf Of *[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]> 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]] *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]> 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]
> Unsubscribe:[email protected]****
>
>  ****
>
>
> _______________________________________________
> TME10 mailing list
> [email protected]
> Unsubscribe:[email protected]****
>
> _______________________________________________
> TME10 mailing list
> [email protected]
> 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]