topic Re: DB2 libname giving error in Administration and Deployment

DB2 libname giving error

AshwaniGupta — Mon, 10 Jun 2019 04:59:09 GMT

Hello <

I am facing one DB2 libname issue.

My libname getting assign perfectly while running on SAS EG or SAS DI Code editor . but when i scehdule our job and ran on SAS batch server (LSF platform process manager) it is giving issue.

Below is error Msg.

Libname db2_XYZ Datasrc=ABC Schema =XXX Authdomain=XXXXXX;

ERROR: Error allocating CLI Environment.

ERROR: Error in libname statement.

.. I am surprise that the same libname connecting on EG or DI. just givinng error while running on LSF.

Please help me on this.

Re: DB2 libname giving error

nhvdwalt — Mon, 10 Jun 2019 06:20:47 GMT

Hi @AshwaniGupta

I'm assuming Linux here and that your LSF jobs run under a different user id than the EG/DI jobs.

I would start by checking that the environment variables needed to locate the DB2 client is set up the same for the different user ids. It's possible that the variable e.g. LD_LIBRARY_PATH is configured for the EG/DI user but not the LSF batch user.

Re: DB2 libname giving error

AshwaniGupta — Mon, 10 Jun 2019 06:26:03 GMT

Hi @nhvdwalt

Yes, here is Linux. But the User Id's are same for EG/DI and LSF.

Where i can find this environment variable 'LD_LIBRARY_PATH' ? I will cross check that once.

Re: DB2 libname giving error

nhvdwalt — Mon, 10 Jun 2019 06:36:11 GMT

Have a look in !SASROOT/bin/sasenv_local

Look for 'SAS Access to DB2' in the below document:

http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf

There is tells you what UNIX variables need to be set.

Also check the .bash_profile script for every user to ensure no variables are set there.

Re: DB2 libname giving error

Lenvdb — Mon, 10 Jun 2019 06:59:24 GMT

The engine is missing in your libname statements. What cli engine are you using? We use odbc .

Re: DB2 libname giving error

AshwaniGupta — Mon, 10 Jun 2019 07:20:52 GMT

@Lenvdb ..

Yeah, that's typo error. We are using DB2 engine .

Re: DB2 libname giving error

nhvdwalt — Mon, 10 Jun 2019 07:29:57 GMT

Well spotted @Lenvdb !

Re: DB2 libname giving error

AshwaniGupta — Fri, 14 Jun 2019 10:15:04 GMT

This libname was working fine about a week ago.

I checked variables files, there is no change recently.

We also restart our LSF service as issue is only on LSF batch server. But still facing issue.

One strange thing i experience that when i use only libname statement in job (no other code), that time its working fine, but when we tried to run select statement that time only we are facing issue.

LIBNAME db2 DB2 Datasrc=XXXX SCHEMA=TXN AUTHDOMAIN="XXXXXXXX" ;

ERROR: Error allocating CLI environment.

ERROR: Error in the LIBNAME statement.

96 data test;

97 set db2.Table_name(obs=100);

ERROR: Libref DB2 is not assigned.

Re: DB2 libname giving error

SASKiwi — Sun, 16 Jun 2019 20:49:47 GMT

If it was working a week ago then what has changed since then? Worth checking with your DB2 Administrator in case anything has changed on the database side. SAS Tech Support is your best option for progressing this.