topic Connection to DB2 from SAS via clpplus in SAS Programming

Connection to DB2 from SAS via clpplus

helannivas88 — Sun, 24 May 2020 07:20:42 GMT

Hi,

Did anybody try calling DB2 clpplus from SAS Client tools via Unix Command (X (or) %sysexec??

Currently SAS are installed in Linux servers and the DB2 servers are catalogued in our DB2 drivers installed in SAS machines.

When I tried launching clpplus from Command line , I can able to successfully connect to DB2 database.

But when I launch clpplus from SAS Clients (EG) , Im trying the below failure

[jcc][t4][2030][11211][4.25.23] A communication error occurred during operations
on the connection's underlying socket, socket input stream,
or socket output stream. Error location: Reply.fill() - socketInputStream.read
(-1). Message: Received fatal alert: handshake_failure. ERRORCODE=-4499,
SQLSTATE=08001

DB250018E: A connection attempt during the CLPPlus environment start sequence
failed. The CLPPlus environment failed to start.

I don't really think the above issue is to deal with any SAS programming. Do anybody have any idea on the issue please.

I'm struggling to resolve this for the past few months.

Thanks

Re: Connection to DB2 from SAS via clpplus

Kurt_Bremser — Sun, 24 May 2020 07:44:05 GMT

When you log on to the commandline, your personal profile is executed, and that will include the necessary environment variables for the DB2 client.

When working with EG, the workspace server inherits its settings from the object spawner, which is started from the SAS installation user.

Have your SAS admin check what is necessary for DB2 to work, and include it in the WorkspaceServer_usermods.sh file.

Re: Connection to DB2 from SAS via clpplus

helannivas88 — Wed, 27 May 2020 16:46:37 GMT

Thanks Kurt. Its due to Java library . SAS session points to different JRE and command line session points to different Java.