Viya4 and DB2 CLI CATALOG Operation

eddieleung305 — Thu, 16 Nov 2023 18:53:12 GMT

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

topic Viya4 and DB2 CLI CATALOG Operation in SAS Viya

Viya4 and DB2 CLI CATALOG Operation