Error on connect to DB2

radha009 — Tue, 28 Jan 2020 13:43:33 GMT

my code :

%let env = DBPROD;
%let user = sam;
%let pwd = welcome;

proc sql;
connect to db2 as db2con (db="&env" user="&user" pw="&pwd");
quit;

error:

ERROR: CLI error trying to establish connection: [IBM][CLI Driver] SQL1013N The database alias name or database name "DBPROD"
could not be found. SQLSTATE=42705

Re: Error on connect to DB2

JBailey — Thu, 30 Jan 2020 14:45:33 GMT

Hi @radha009

SQL1013N and SQLSTATE=42705 means that the database, in this case DBPROD may not have been cataloged on the DB2 client.

You can read about it, here.

https://www.ibm.com/support/pages/sql1013n-db2-connect

If you have the DB2 CLI installed on the client you can invoke it and issue the following command:

db2 list db directory

If DBPROD isn't listed, it will need to be cataloged.

This Stackoverflow thread may help you:

https://stackoverflow.com/questions/19303061/db2-database-directory-shows-db-that-does-not-exist

If this is all gibberish, you may need to contact your DBA and have them configure the client.

Best wishes,

Jeff

topic Error on connect to DB2 in SAS Enterprise Guide

Error on connect to DB2

Re: Error on connect to DB2