Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RRDI 2.0 - RIDW Data source connection -Fails

Questions
Tags
Users
Badges
Murali Dhandapani
(116●9●8) retagged
Aug 15 '12, 3:38 p.m.
I have the following configuration for the RIDW database.

DB2 database name:
RIDW
DB2 connect string:
jdbc:db2://localhost:50005/RIDW
Collation sequence:
Open asynchronously
Trusted context
Timeouts 
Specify the time in seconds, in which you want the database to connect or wait for your reply before timing out.
Connect time:
Reply time:
Signon 
Select whether or not authentication is needed, and if so, the type of authentication to use, whether a password is required and whether to create a signon.
No authentication
An external namespace:

The signons of this connection

Password - enabled
Testing 
Test the connection...
-------------------------------------------------

Test the parameters that make up the database connection.
Connection string:
^User ID:^?Password:;LOCAL;D2;DSN=RIDW;UID=%s;PWD=%s;jdbc:db2://localhost:50005/RIDW@ASYNC=0@0/0@COLSEQ=
 
Dispatcher:
http://islswestest5.in.ibm.com:19080/reporting
 
Test the connection using:    
Select whether to test the connection with a user ID and password, or with a signon.
User ID and password
User ID:
Password:
Signon

Entries: - Go To
First Page Previous Page Next Page Last Page
 
 
Name 
rptuser rptuser


-------------------------------------------

Test Connection always fails.. what is wrong here.?.

0 votes

2 answers
6,423 views
0 votes

2 answers

Permanent link
Mark Prout
(134●1●15●10) Aug 15 '12, 5:13 p.m.
Hi Murali, have you checked the validity of the username/password combination for the rptuser sign-on?  I've been caught out before with this.

0 votes

Comments
Murali Dhandapani
Aug 15 '12, 11:55 p.m.

Actually LIBPATH was not set properly on my AIX server. Updating the LIBPATH with DB2 32 bit libraries made the job easy.

Also while using the data warehouse database from a different server, we need to create db2 catalog and connect to the remote node to make the database locally. Otherwise it again fails.

Example : 1. db2 catalog tcpip node <node name=""> remote <remote server="" ip=""> server <port>

  1. db2 catalog database DW at node <node name="">

  2. db2 list node directory

  3. db2 connect to DW user <username> using <password>

Thanks Mark.

Permanent link
Murali Dhandapani
(116●9●8) Aug 15 '12, 11:55 p.m.
Actually  LIBPATH was not set properly on my AIX server. Updating the LIBPATH with DB2 32 bit libraries made the job easy.

Also while using the data warehouse database from a different server, we need to create db2 catalog and connect to the remote node to make the database locally. Otherwise it again fails.

Example :
 1. db2 catalog tcpip node <node name> remote <remote server ip> server <port>

 2. db2 catalog database DW at node <node name>

 3. db2 list node directory

 4. db2 connect to DW user <username> using <password>

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 403

Question asked: Jul 27 '12, 2:15 p.m.

Question was seen: 6,423 times

Last updated: Aug 15 '12, 11:55 p.m.

Confirmation Cancel Confirm