Connection to DB2 from SAS via clpplus

[helannivas88]

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 

[Kurt_Bremser · Accepted solution]

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.

[helannivas88]

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