server:DB2 V8.2,aix6.1
Database manager authentication (AUTHENTICATION) = CLIENT
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = NO
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
client1:DB2V9.7 ,redhat 6.5, 64bit
client2:DB2V9.7 ,redhat 5.8,32bit
两个client的配置一样,如下
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = YES
Bypass federated authentication (FED_NOAUTH) = NO
将server的数据库分别编目到两台client,远程连接client2时不用输用户密码 可以直接db2 connect to dbname,
但是client1一定要输入密码,不知道有什么会引起这种情况 ,数据库层面还是OS,没辙了。
编目语句:
db2 catalog tcpip node node10 remote **.**.**.** server 50000
db2 catalog db dbname at node node10
这个没毛病吧!!!
搜了半天,只注意到这个参数TRUST_ALLCLNTS,当服务器端是客户端认证,而这个参数是NO,对于不可信客户机最终还是会在服务器端认证,什么样才是可信客户机。不知道和这个有没有关系。由于这个是生产的数据库,这个参数没法改成yes。
请各位大神不吝赐教,小女谢过了!!!!
看懂了这个表你就释然了。
是否提供了ID/密码? | TRUST_ALLCLNTS | TRUST_CLNTAUTH | 不可信的客户机 | 可信的客户机 | 主机客户机 |
No | Yes | CLIENT | CLIENT | CLIENT | CLIENT |
No | Yes | SERVER | CLIENT | CLIENT | CLIENT |
No | No | CLIENT | SERVER | CLIENT | CLIENT |
No | No | SERVER | SERVER | CLIENT | CLIENT |
No | DRDAONLY | CLIENT | SERVER | SERVER | CLIENT |
No | DRDAONLY | SERVER | SERVER | SERVER | CLIENT |
Yes | Yes | CLIENT | CLIENT | CLIENT | CLIENT |
Yes | Yes | SERVER | SERVER | SERVER | SERVER |
Yes | No | CLIENT | SERVER | CLIENT | CLIENT |
Yes | No | SERVER | SERVER | SERVER | SERVER |
Yes | DRDAONLY | CLIENT | SERVER | SERVER | CLIENT |
Yes | DRDAONLY | SERVER | SERVER | SERVER | SERVER |