DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Chon
Participant



Joined: 12 Mar 2018
Posts: 12

Points: 89

Post Posted: Mon Mar 12, 2018 5:01 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I have configured the odbc.ini to connect to mysql database, but when trying testing it I received a Connection Failed error

Error Message:
ODBC function "SQLConnect" reported: SQLSTATE = HY000: Native
Error Code = 2,0003: Msg = [IBM(DataDirect OEM)[ODBC MySQL Wire Protocol driver]
Can't connect to MySQL server on '13.250.184.188'

odbc.ini
[MYSQLPROD]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmysql00.so
Description=DataDirect 7.0 MySQL Wire Protocol
HostName=13.250.184.188
PortNumber=3306
Database=sodv3
LogonID=
Password=
OPTION=3
SOCKET=

uvodbc.config
<SKYRPD>
MYSQLPROD = ODBC
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16292
Location: Germany
Points: 92381

Post Posted: Mon Mar 12, 2018 8:07 am Reply with quote    Back to top    

Using your DataStage user, can you Login to the command line on your DataStage Server and do a "ping 13.250.184.188"

_________________

Image
Rate this response:  
Not yet rated
Chon
Participant



Joined: 12 Mar 2018
Posts: 12

Points: 89

Post Posted: Mon Mar 12, 2018 8:15 am Reply with quote    Back to top    

After trying it , this is the result

dsadm@p2lp18:/home/dsadm>ping 13.250.184.188
PING 13.250.184.188: (13.250.184.188): 56 data bytes

then nothing is happening after that one liner result
Rate this response:  
Not yet rated
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16292
Location: Germany
Points: 92381

Post Posted: Mon Mar 12, 2018 8:54 am Reply with quote    Back to top    

That means that your Problem doesn't lie with datastage, but that the MySQL machine at address 13.250.184.188 cannot be reached from your UNIX DataStage Server. You should contact your machine Ad ...

_________________

Image
Rate this response:  
Not yet rated
Chon
Participant



Joined: 12 Mar 2018
Posts: 12

Points: 89

Post Posted: Mon Mar 12, 2018 5:21 pm Reply with quote    Back to top    

I tried the same step on the database we already using in DataStage, but I got the same result.
Rate this response:  
Not yet rated
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16292
Location: Germany
Points: 92381

Post Posted: Tue Mar 13, 2018 2:31 am Reply with quote    Back to top    

Is the machine "p2lp18" your DataStage engine Tier? To which working database did you try to "ping"? Can you ping your Workstation from the Server? (If not, then the admins might have blocked pin ...

_________________

Image
Rate this response:  
Not yet rated
Chon
Participant



Joined: 12 Mar 2018
Posts: 12

Points: 89

Post Posted: Tue Mar 13, 2018 11:33 pm Reply with quote    Back to top    

Is the machine "p2lp18" your DataStage engine Tier?
- Yes

To which working database did you try to "ping"?
- [i]Yes. I ping'ed the MySQL connection in our engine tier which is p2lp18 and I got a one liner result. I also tried it in our database that we already using in DataStage but I got the same result.


BTW, we are using AIX.
Rate this response:  
Not yet rated
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16292
Location: Germany
Points: 92381

Post Posted: Wed Mar 14, 2018 3:58 am Reply with quote    Back to top    

Can you ping your Workstation from the AIX Server?

_________________

Image
Rate this response:  
Not yet rated
Chon
Participant



Joined: 12 Mar 2018
Posts: 12

Points: 89

Post Posted: Wed Mar 14, 2018 6:33 am Reply with quote    Back to top    

Yep. I can ping my workstation from AIX server
Rate this response:  
Not yet rated
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2724
Location: USA
Points: 20365

Post Posted: Wed Mar 14, 2018 7:13 am Reply with quote    Back to top    

Doing a ping is a reasonable, general test but not quite the same as making a database connection. Just because ping succeeds or fails does not mean that you will be able to connect to the database.

It is better to do a ' telnet target_db_server db_port ' command from your AIX Information Server.

If the telnet command connects OK, then double check how you defined the database connection, because if it is defined correctly then it should work.

If the telnet command times out or fails to connect, then you probably have a firewall blocking the traffic and need to get your network/firewall people to open it up.

A few other ideas:

- check your file name (the default .odbc.ini file name begins with a dot)

- list the data source name in the [ODBC Data Sources] header section of the .odbc.ini file, such as db_name=DataDirect 7.0 MySQL Wire Protocol

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius

Last edited by qt_ky on Wed Mar 14, 2018 7:21 am; edited 1 time in total
Rate this response:  
Not yet rated
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16292
Location: Germany
Points: 92381

Post Posted: Wed Mar 14, 2018 7:17 am Reply with quote    Back to top    

To add to the previous post, use "Telnet 13.250.184.188 3306" to attempt to connect to the IP address and to the appropriate port as you specified in your odbc.ini Usually "ping" is sufficient, b ...

_________________

Image
Rate this response:  
Not yet rated
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2724
Location: USA
Points: 20365

Post Posted: Wed Mar 14, 2018 7:23 am Reply with quote    Back to top    

I have also found that the ODBC DSN needs to be <= 8 characters; you've got 9.

And, the DSN <SKYRPD> in the uvodbc.config file needs to match the DSN [MYSQLPROD] in the .odbc.ini file.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
Chon
Participant



Joined: 12 Mar 2018
Posts: 12

Points: 89

Post Posted: Wed Mar 14, 2018 9:53 am Reply with quote    Back to top    

I tried using telnet but I got this result

admin@p2lp18:/home/dsadm>telnet 13.250.184.188 3306
Trying...
admin@p2lp18:/home/dsadm>


This is my odbc config ( .odbc.ini )
[SKYRPD]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmysql00.so
Description=DataDirect 7.0 MySQL Wire Protocol
HostName=13.250.184.188
PortNumber=3306
Database=sodv3
LogonID=
Password=
OPTION=3
SOCKET=
EncryptionMethod=0
ValidateServerCertificate=0
DriverUnicodeType=1

This is my uvodbc config ( uvodbc.config )
<SKYRPD>
DBMSTYPE = ODBC
Rate this response:  
Not yet rated
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16292
Location: Germany
Points: 92381

Post Posted: Wed Mar 14, 2018 10:05 am Reply with quote    Back to top    

Before going further into the Problem, can you talk to one of your AIX Administrators and explain the connectivity issues - perhaps something else is blocking connectivity.

One more thing, could you post the Output of the command "traceroute 13.250.184.188"

_________________

Image
Rate this response:  
Not yet rated
Chon
Participant



Joined: 12 Mar 2018
Posts: 12

Points: 89

Post Posted: Wed Mar 14, 2018 8:06 pm Reply with quote    Back to top    

Here is the result

admin@p2lp18:/home/dsadm>traceroute 13.250.184.188
ksh: ^Vtraceroute: not found.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours