× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. OPENSOURCE
  3. July 2018

Re: [IBMiOSS] Installing IBM Data Server Client

You want the DDM/DRDA port: 446 or 447 (SSL).



----- Original message -----
From: Bryan Dietz <bdietz400@xxxxxxxxx>
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxx>
Cc:
Subject: Re: [IBMiOSS] Installing IBM Data Server Client
Date: Mon, Jul 9, 2018 8:59 PM

the ports you have referenced to not appear to be correct.

have a look here for port numbers:
[1]https://www-01.ibm.com/support/docview.wss?uid=nas8N1019667

Bryan

Joe Scandora wrote on 7/9/2018 6:15 PM:
> Hello folks at
OpenSource@xxxxxxxxxxxx<[2]mailto:OpenSource@xxxxxxxxxxxx> ***
>
> I am attempting to install the ***IBM Data Server Driver*** on Centos7
Linux to connect to an iSeries DB2 server from the Linux instance, in
order to use the Python driver.
>
> I installed the dsdriver from here:
[3]https://www-01.ibm.com/support/docview.wss?uid=swg21385217
>
> And I am following the installation instructions here:
>
>
[4]https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.5.0/com.ibm.swg.im.dbclient.install.doc/doc/c0023452.html
>
> We are stopped on the step of ***Testing client-to-server
communications using CLPPlus***
>
> Below, I***ve included the output from CLPPlus during the connection
attempt, and a sanitized copy of my ***db2dsdriver.cfg***, where the
actual username has been replaced with ***username*** and the actual
host has been replaced with ***example.com***.
>
> The issue may be that the proper service is not running on port 50001
on the iSeries. Can anyone help by telling us what service does this
dsdriver connect to, and what port does the service normally run on?
>
>
> [jscandora@sfload01.dal01 cfg]$ /opt/ibm/dsdriver/bin/clpplus -nw
username@alias1
> CLPPlus: Version 1.6
> Copyright (c) 2009, 2011, IBM CORPORATION. All rights reserved.
>
> Enter password: ********
>
> [jcc][t4][2043][11550][3.71.22] Exception java.net.ConnectException:
Error
> opening socket to server example.com/64.135.114.154 on port 50,001
> with message: Connection refused. ERRORCODE=-4499, SQLSTATE=08001
>
>
> DB250018E: A connection attempt during the CLPPlus environment start
sequence
> failed. The CLPPlus environment failed to start.
>
> To close this window, press the ENTER key.
>
>
> [jscandora@sfload01.dal01 cfg]$ cat db2dsdriver.cfg
> <configuration>
> <dsncollection>
> <dsn alias="alias1" name="name1" host="example.com"
port="50001"/>
> <!-- Long aliases are supported -->
> <!--
> <dsn alias="longaliasname2" name="name2"
host="server2.net1.com" port="55551">
> <parameter name="Authentication" value="SERVER_ENCRYPT"/>
> </dsn>
> -->
> </dsncollection>
> <databases>
> <database name="username" host="example.com" port="50001">
> <parameter name="CurrentSchema" value="schemaname"/> <!--
<wlb>
> <parameter name="enableWLB" value="true"/>
> <parameter name="maxTransports" value="50"/>
> </wlb>
> <acr>
> <parameter name="enableACR" value="true"/>
> </acr>
> <specialregisters>
> <parameter name="CURRENT DEGREE" value="'ANY'"/>
> </specialregisters>
> <sessionglobalvariables>
> <parameter name="global_var1" value="abc"/>
> </sessionglobalvariables>
> -->
> </database>
> <!-- Local IPC connection -->
> <!--
> <database name="name3" host="localhost" port="0">
> <parameter name="IPCInstance" value="DB2"/>
> <parameter name="CommProtocol" value="IPC"/>
> </database>
> -->
> </databases>
> <parameters>
> <parameter name="GlobalParam" value="Value"/>
> <!-- cmxControllerAccessPolicy : Indicates the impact of DSM or
OCM on client applications
> Supported values
> 0 : If DSM or OCM server is unreachable, do not allow the
application to start.
> 1 : If DSM or OCM server is unreachable, allow the application
to start only if a cached profile for the application is available.
> 2 : If DSM or OCM server is unreachable, allow the application
to start.
> 3 : Even if DSM or OCM is reachable, allow the application to
ignore the DSM or OCM server.
> 4 : Even if DSM or OCM is reachable, do not poll for control
directives, but send client statistics when available. -->
> <!-- DSM and OCM users : Remove comments from the line below
and put in the appropriate values for DSM_OCM_hostname and DSM_OCM_port
-->
> <!--<parameter name="connectionSupervisorProperties"
value="httpControllerURL=http://DSM_OCM_hostname:DSM_OCM_port,
cmxControllerAccessPolicy=2"/>-->
>
>
> <!-- OPM users : Remove comments from the line below and put in
the appropriate values for OPM_hostname and EIPort -->
> <!--<parameter name="connectionSupervisorProperties"
value="controllerURL=OPM_hostname:EIPort "/>-->
>
> </parameters>
> </configuration>
>
>
> Joseph R. Scandora
> Database Engineer
> Office/Skype: 720-452-7501
> Mobile: 303-578-9250
> jscandora@xxxxxxxxxxxxxx<[5]mailto:jscandora@xxxxxxxxxxxxxx>
> 5975 S. Quebec St., Ste. 190
> Centennial, CO 80111
>
> [[6]cid:03B2DFC4-6A49-4D42-80DE-A6BCF4BDBDE0]
>
> We strive to D E L I G H T every day. Learn
more<[7]https://www.intelepeer.com/about-us/core-values/> about our Core
Values.
>
>
> Disclaimer
> The information contained in this communication from the sender is
confidential. It is intended solely for use by the recipient and others
authorized to receive it. If you are not the recipient, you are hereby
notified that any disclosure, copying, distribution or taking action in
relation of the contents of this information is strictly prohibited and
may be unlawful.
>
> This email has been scanned for viruses and malware, and may have been
automatically archived by Mimecast Ltd, an innovator in Software as a
Service (SaaS) for business. Providing a safer and more useful place for
your human generated data. Specializing in; Security, archiving and
compliance. To find out more Click
Here<[8]http://www.mimecast.com/products/>.
>
> From:
"ibm_support@xxxxxxxxxxxxxx<[9]mailto:ibm_support@xxxxxxxxxxxxxx>"
<ibm_support@xxxxxxxxxxxxxx<[10]mailto:ibm_support@xxxxxxxxxxxxxx>>
> Reply-To:
"ibm_support@xxxxxxxxxxxxxx<[11]mailto:ibm_support@xxxxxxxxxxxxxx>"
<ibm_support@xxxxxxxxxxxxxx<[12]mailto:ibm_support@xxxxxxxxxxxxxx>>
> Date: Monday, July 9, 2018 at 10:24 AM
> To: Bill Folchetti
<bfolchetti@xxxxxxxxxxxxx<[13]mailto:bfolchetti@xxxxxxxxxxxxx>>
> Cc: Joe Scandora
<jscandora@xxxxxxxxxxxxxx<[14]mailto:jscandora@xxxxxxxxxxxxxx>>
> Subject: PMR 39653,442,000
>
> Hi Bill and Joe.
> You can respond to this email for this PMR.
>
>
> Regards,
> Skye Harney
> IBM i Global Support Center
>
>
>
>
> Disclaimer
>
> The information contained in this communication from the sender is
confidential. It is intended solely for use by the recipient and others
authorized to receive it. If you are not the recipient, you are hereby
notified that any disclosure, copying, distribution or taking action in
relation of the contents of this information is strictly prohibited and
may be unlawful.
>
> This email has been scanned for viruses and malware, and may have been
automatically archived by Mimecast Ltd, an innovator in Software as a
Service (SaaS) for business. Providing a safer and more useful place for
your human generated data. Specializing in; Security, archiving and
compliance. To find out more Click
Here<[15]http://www.mimecast.com/products/>.
>
> Disclaimer
>
> The information contained in this communication from the sender is
confidential. It is intended solely for use by the recipient and others
authorized to receive it. If you are not the recipient, you are hereby
notified that any disclosure, copying, distribution or taking action in
relation of the contents of this information is strictly prohibited and
may be unlawful.
>
> This email has been scanned for viruses and malware, and may have been
automatically archived by Mimecast Ltd, an innovator in Software as a
Service (SaaS) for business. Providing a safer and more useful place for
your human generated data. Specializing in; Security, archiving and
compliance. To find out more visit the Mimecast website.
>
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [16]https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [17]https://archive.midrange.com/opensource.




References

Visible links
1. https://www-01.ibm.com/support/docview.wss?uid=nas8N1019667
2. mailto:OpenSource@xxxxxxxxxxxx
3. https://www-01.ibm.com/support/docview.wss?uid=swg21385217
4. https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.5.0/com.ibm.swg.im.dbclient.install.doc/doc/c0023452.html
5. mailto:jscandora@xxxxxxxxxxxxxx
6. file:///tmp/cid:03B2DFC4-6A49-4D42-80DE-A6BCF4BDBDE0
7. https://www.intelepeer.com/about-us/core-values/
8. http://www.mimecast.com/products/
9. mailto:ibm_support@xxxxxxxxxxxxxx
10. mailto:ibm_support@xxxxxxxxxxxxxx
11. mailto:ibm_support@xxxxxxxxxxxxxx
12. mailto:ibm_support@xxxxxxxxxxxxxx
13. mailto:bfolchetti@xxxxxxxxxxxxx
14. mailto:jscandora@xxxxxxxxxxxxxx
15. http://www.mimecast.com/products/
16. https://lists.midrange.com/mailman/listinfo/opensource
17. https://archive.midrange.com/opensource

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.