Andrei Dolinau 29.Jan.08 07:08 AM a Web browser LEI LEI - 6.5 AIX
Could you land me you hand, pls?
LEI ver 6.5.1
Domino Server Release 6.53HF654 on AIX 3.5
DB2 AIX64 9.1.1 Server
I have got two DB2 Dbs on the same server but with different Port Numbers.
For first DB I have user1.
For second DB I have user1 and user2 just was created for me.
The DB2 Connection on AIX side was created to first DB2 DB.
Then I could use it by user1.
Then new user2 was created in the second DB and I had to use the second DB.
I asked aix team just to update connection using new Port Number for the second DB 'cause they are both use the same names.
And now I cannot connect to the second DB2 using this connection through LEI:
Error: [IBM][CLI Driver][DB2/AIX64] SQL0551N "user2" does not have the privilege to perform operation "SELECT" on object "table name". SQLSTATE=42501, Connector 'lei_db2_connection', Method -Execute- (-551)
When I attempt to use DB2 Control Center I have an access.
It looks like LEI doesn't see new changes for connection... still trying to use old Port Number. If I try to connect to first DB by using DB2 Control Center with user2 I'll get the same error messages.