BookmarkSubscribeRSS Feed
eddieleung305
Obsidian | Level 7

We are configuring Viya4 with SAS/ACCESS to DB2 to access an external DB2 server.

May I know how to CATALOG a DB2 database in the Viya4 environment?

 

I know that if it is SAS9 or Viya3.5, we will install the DB2 client on the same server that was installed with SAS9 or Viya3.5 and then we will CATALOG a database by db2 command. e.g. 

db2 CATALOG DATABASE PRDDB1 AS PRDDB1 AT NODE S051I001

 

How to do the same operation in Viya4 and Kubernetes world? SAS doc has a details description of how to install the db2 client and move to NFS PV but not much to discuss the operation. We noticed that without the correct setup, we will have the error: 

 

ERROR: CLI error trying to establish connection: [IBM][CLI Driver] SQL1031N The database directory cannot be found on the
indicated file system. SQLSTATE=58031

 

 

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Discussion stats
  • 0 replies
  • 252 views
  • 0 likes
  • 1 in conversation