求助：连接到db2 udb v8.1.9 linux [英] Help: connecting to db2 udb v8.1.9 linux
问题描述
我已经设置了主题系统，并且可以使用几个
用户ID连接到它。我可以使用我创建的新用户标识登录到它（ssh），但是当我尝试使用这些凭据连接到db2时，我的密码无效。
我已经检查了新用户ID的组，并使其密码为
，与具有相同结果的成功用户ID之一相同。这一个
让我感到困惑。我显然错过了一些非常基本的东西，但我不能确定是什么。任何想法，rtfm参考等，非常感谢。
I have the subject system set up, and can connect to it with several
userids. I can login to it (ssh) with a new userid I created, but when I
try to use those credentials to connect to db2, I get password invalid.
I have checked the groups of the new userid and made its password the
same as one of the successful userids with the same results. This one
baffles me. I''m obviously missing something very elementary, but I can''t
figure out what. Any ideas, rtfm references, etc. greatly appreciated.
推荐答案
Bob Stearns写道：
Bob Stearns wrote:
我有主题系统集up，并且可以使用几个用户ID连接到它。我可以使用我创建的新用户标识登录到它（ssh），但是当我尝试使用这些凭据连接到db2时，我的密码无效。
我检查了新用户标识的组并使其密码与具有相同结果的成功用户ID之一相同。这一个让我感到困惑。我显然错过了一些非常基本的东西，但我无法弄清楚是什么。任何想法，rtfm参考等，非常感谢。
I have the subject system set up, and can connect to it with several
userids. I can login to it (ssh) with a new userid I created, but when I
try to use those credentials to connect to db2, I get password invalid.
I have checked the groups of the new userid and made its password the
same as one of the successful userids with the same results. This one
baffles me. I''m obviously missing something very elementary, but I can''t
figure out what. Any ideas, rtfm references, etc. greatly appreciated.
Q1：ID是否具有连接权限？我认为这是'SYSCAT.DBAUTH
Q2：如何设置身份验证？服务器，客户端，..？我认为这是DBM CONFIG的一部分。
干杯
Serge
-
Serge Rielau
DB2解决方案开发
IBM多伦多实验室
IOD会议
http://www.ibm.com/software/data /ond...ness/conf2006/
Serge Rielau写道：
Serge Rielau wrote:
Bob Stearns写道：
Bob Stearns wrote:
我已经设置了主题系统，并且可以使用几个用户ID连接到它。我可以使用我创建的新用户标识登录到它（ssh），但是当我尝试使用这些凭据连接到db2时，我得到密码
无效。我检查了新用户ID的组，并使其
密码与具有相同
结果的成功用户ID之一相同。这个让我感到困惑。我显然缺少一些非常基本的东西，但我不知道是什么。任何想法，rtfm参考，
等非常感谢。
I have the subject system set up, and can connect to it with several
userids. I can login to it (ssh) with a new userid I created, but when
I try to use those credentials to connect to db2, I get password
invalid. I have checked the groups of the new userid and made its
password the same as one of the successful userids with the same
results. This one baffles me. I''m obviously missing something very
elementary, but I can''t figure out what. Any ideas, rtfm references,
etc. greatly appreciated.
Q1：ID是否具有连接权限？我认为那是'SYSCAT.DBAUTH
Q2：如何设置身份验证？服务器，客户端，..？我认为这是DBM CONFIG的一部分。
干杯
Serge
Q1: Does the ID have connect privileges? I think that''s in SYSCAT.DBAUTH
Q2: How is authentication set up? Server, Client, .. ? I think that''s
part of the DBM CONFIG.
Cheers
Serge
1我查了一下，一个是连接权限
2服务器，我想。我在哪里可以找到DBM CONFIG来验证
3 db2diag给出检查密码失败，rc = -2146500502。那是
800F006A的32位十六进制。
1 I checked, an is has connect authority
2 Server, I think. Where do I find DBM CONFIG to verify
3 db2diag gives check password failed with rc = -2146500502. That is
800F006A in 32 bit hex.
我不知道你是怎么想连接但是这是我想要的
来解决这个问题。
1 - 使用userid到db2服务器ssh（不是用另一个id和
su - 用户 - 用户帐户可以设置为在下次登录时更改密码
，如果你刚刚创建的那样），加载数据库
db2profile for the用户并从那里连接，这排除了
数据库授权
2 - 从客户端机器目录中获取节点和数据库（如果你
还没有这样做） - 使用命令行代替控制中心，它更快更好地解决问题。
3 - 使用来自客户端计算机的命令行测试连接
使用您知道它可用的用户ID
4 - 使用新用户标识进行测试命令行
要检查身份验证类型（听起来不像这是
问题，因为你说你可以使用另一个
用户连接....） />
I''m not sure how you are trying to connect but here is what I would to
to troubleshoot this thing.
1 - Ssh to the db2 server using the userid (not with another id and
su-ing to the user - the user account may be set to change the password
on next login if you just created it that way), load the database
db2profile for the user and connect from there, which rules out the
database authorization
2 - From the client machine catalog the node and the database (if you
haven''t done so) - use command line instead of the control center, it''s
faster and better to troubleshoot.
3 - Test the connection using the command line from the client machine
with a userid you know it works
4 - Test using the new userid using the command line
To check the authentication type (doesn''t sound like this is the
problem because you said you were able to connect using another
user....)
这篇关于求助：连接到db2 udb v8.1.9 linux的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
