I have created the DB2_Server , Db2_Schema and Library working fine under DB2Auth
Now I have added the connection object in DB2 Server for pointing it to defferent DataSrc: with same DB2Auth as before.
Add new Schema: pointing it to schema2
Library: db2libI2 as libref, server: DB2_Server , Schema2
I have created the different DB2 user group (Like DB2_user_group1, DB2_user_group2) for differnet Library which uses different login credential
and exist in DB2 Server as User.
Finally it throws this Message,
NOTE: Libref DB2LIBI2 was successfully assigned as follows:
Engine: DB2
Physical Name: ITERATE2
1 LIBNAME db2libI2 DB2 Datasrc=ABC2 SCHEMA=GR2 USER=user2 PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXX ;
I have also tested this running (Display Libname) query from BASE/SAS on server it runs and but doesnot shows me tables.
but if I run this query from BASE/SAS on server it gives me result.
proc sql;
select * from db2libi2.Emp_master;
quit;
I am not understanding why it is happening.
Please let me know ,
Thanks