Connecting to Db2 from SAS Viya

[yatinrao]

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 

[alexal]

@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.

[yatinrao · Accepted solution]

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