topic Connecting to Db2 from SAS Viya in Administration and Deployment

Connecting to Db2 from SAS Viya

yatinrao — Tue, 24 Sep 2019 21:17:49 GMT

Hello

Has anyone connected to db2 9.7 from SAS Viya 3.4? I am trying to connect from data explorer GUI from environment Manager .

I can connect but can't see the list of tables. As per excellent blog by Roberto Meléndez , Isql connectivity works perfectly

what is the significance of catalog and and schema options? are they needed

I tried to specify my schema and also sysibm.systables as catalog but will not list tables or view

I also need to specify dm_unicode=utf-16 parameter for connection to work , not sure what is the significance

Yatin

Re: Connecting to Db2 from SAS Viya

alexal — Fri, 27 Sep 2019 12:23:01 GMT

@yatinrao ,

Did you see any errors in the CAS server log? You can find that log in /opt/sas/viya/config/var/log/cas/default directory.

Re: Connecting to Db2 from SAS Viya

yatinrao — Fri, 18 Oct 2019 13:49:42 GMT

Finally got the solution for this issue .

It had to do with which variation of the installed 9.7 cli driver was used by unixODBC

isql works fine with the single threaded driver file libdb2.so.1

for CAS server and sas which are multi threaded needed to use libdb2o.so.1 . Thanks to Sam Loflin from sas for figuring it out.

as usual this is probably documented by IBM where only Watson can find 🙂

I suggest this and similar database connectivity should be added to SAS Viya documentation . I would also appreciate if someone can document the use of dm_unicode =UTF-16 during ODBC database connections