列表应用程序失败.... [英] LIST APPLICATIONS fails ....

问题描述

Win XP上的UDB PE V8.0。我发出以下命令：


1.连接到示例用户db2adming使用xxxxx

输出结果为：


数据库连接信息

数据库服务器= DB2 / NT 8.1.3

SQL授权ID = DB2ADMIN

本地数据库别名= SAMPLE


2.接下来我发出以下命令：

数据库样本列表应用


它给出了错误消息：


SQL30082N尝试建立连接失败，出于安全原因

" 24"

（" USERNAME AND / OR PASSWORD INVALID" ）。 SQLSTATE = 08001

有什么问题？在LIST APPLICATION命令中没有规定用户名和

密码;更多的我已经连接了

到SAMPLE，那么为什么又要再次连接呢？


TIA

Raquel。< br>

UDB PE V8.0 on Win XP. I issue the following commands:

1. CONNECT TO SAMPLE USER db2adming USING xxxxx
The output is:

Database Connection Information
Database server = DB2/NT 8.1.3
SQL authorization ID = DB2ADMIN
Local database alias = SAMPLE

2. Next I issue the following command:
LIST APPLICATION FOR DATABASE SAMPLE

It gives me error message:

SQL30082N Attempt to establish connection failed with security reason
"24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
What is wrong? There is no provision for specifying userid and
password on LIST APPLICATION command; more ever I am already connected
to SAMPLE, so why is it bothering to connect again?

TIA
Raquel.

推荐答案

有什么问题？在LIST APPLICATION命令中没有规定用户名和
密码;更多的是我已经连接到SAMPLE了，为什么再次连接呢？

TIA
Raquel。

What is wrong? There is no provision for specifying userid and
password on LIST APPLICATION command; more ever I am already connected
to SAMPLE, so why is it bothering to connect again?

TIA
Raquel.

list application命令需要实例的附件。它b / b
尝试使用当前的OS用户ID建立附件，如果它没有附加
。

你需要使用''在列表应用程序命令之前使用....''附加到db2用户db2admin

The list application command needs an attachment to the instance. It
tries to establish an attachment using the current OS userid if it
isn''t attached.
You need to use the ''attach to db2 user db2admin using ....'' before
the list application command.

> list application命令需要附件到实例。它

> The list application command needs an attachment to the instance. It

尝试使用当前的OS用户ID建立附件，如果它没有附加。
您需要使用''附加到db2用户db2admin使用.. ..''在列表应用程序命令之前。

tries to establish an attachment using the current OS userid if it
isn''t attached.
You need to use the ''attach to db2 user db2admin using ....'' before
the list application command.

好​​吧，我现在更加困惑了。连接到数据库不是

''隐式''也意味着我也附加到db2实例？我可以

连接到数据库而无需附加到

数据库所在的实例吗？


TIA

Raquel。

ok, I am even more confused now. Does a CONNECT TO DATABASE not
''implicitly'' also mean that I am also attached to db2 instance? Can I
connect to a database without being attached to the instance that
database resides in?

TIA
Raquel.

> > list application命令需要附件到实例。它

> > The list application command needs an attachment to the instance. It

尝试使用当前的OS用户ID建立附件，如果它没有附加。
你需要使用''使用....''在列表应用程序命令之前附加到db2用户db2admin。

tries to establish an attachment using the current OS userid if it
isn''t attached.
You need to use the ''attach to db2 user db2admin using ....'' before
the list application command.

好的，我现在更加困惑了。连接数据库不是隐式地也意味着我也附加到db2实例吗？我是否可以连接到数据库而无需连接到数据库所在的实例？

TIA
Raquel。

ok, I am even more confused now. Does a CONNECT TO DATABASE not
''implicitly'' also mean that I am also attached to db2 instance? Can I
connect to a database without being attached to the instance that
database resides in?

TIA
Raquel.

通过与数据库的连接，您将被连接。但是，List

应用程序需要特定的权限才能执行。有关详细信息，请参阅命令

参考。尝试使用实例所有者ID，如果确实没有工作，请在此论坛中报告。

With a connection to a database, you are attached. However, List
Applications requires specific authority to execute.See the Command
Reference for details. Try it with the instance owner id, and if that does
not work, report back in this forum.

这篇关于列表应用程序失败....的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！