为什么我看不到Data Studio中的所有DB2实例？ [英] Why don't I see all of my DB2 instances in Data Studio?

问题描述

我在Windows 8.1中运行IBM Data Studio 4.1.1。我在同一台机器上有一个DB2 Express-C 10.5的副本，它有两个实例，DB2的默认版本和我创建的一个名为inst2的实例。当我打开Data Studio时，我只看到实例叫做DB2，但是inst2实例没有出现。

如何让我的第二个实例及其数据库出现，以便我可以与他们合作？我已经尝试刷新管理视图，甚至停止并重新启动Data Studio，但第二个实例从不出现。我需要在CLP中的数据库实例（比如数据库编目）中做一些事情，然后才会出现在Data Studio中？

另外，我不清楚如果我可以使用Data Studio中的db2icrt和db2ilist等命令。到目前为止，它似乎只是设置为执行SQL而不是DB2命令。

任何一个问题的帮助将不胜感激。

解决方案

应用程序一次只能与单个DB2实例相关联（如
由code> DB2INSTDEF 环境变量（在Windows上）

Data Studio具有选项（默认启用），以包含所有在默认实例中编目，这就是为什么只从一个实例看到数据库。

如果要查看其他数据库，您有几个选项： / p>

1. 从主实例中的其他实例手动目录数据库




2. 在另一个实例中为数据库定义新连接（JDBC）

Data Studio不能就我所知，执行发现以查找DB2实例，也不能创建DB2实例，即使它依赖于ssh来执行远程机器上的某些操作系统级别的命令，也主要是远程客户端。

I'm running IBM Data Studio 4.1.1 in Windows 8.1. I have a copy of DB2 Express-C 10.5 on the same machine and it has two instances, the default one of DB2 and a new one I've created called inst2. When I open Data Studio, I only see the instance called DB2 but the inst2 instance doesn't appear.

How do I get my second instance and its databases to appear so that I can work with them? I've tried refreshing the Administration view and even stopping and restarting Data Studio but the second instance never appears. Do I need to do something with the instance of database in the CLP - like cataloging the database - before it will appear in Data Studio?

Also, I'm not clear if I can do commands like db2icrt and db2ilist from Data Studio. So far, it only appears to be set up to do SQL but not DB2 commands.

Any help with either question would be appreciated.

解决方案

An application can only be associated with a single DB2 instance at a time (as controlled by the DB2INSTDEF environment variable (on Windows).

Data Studio has the option (enabled by default) to include all databases that have been cataloged within the default instance, which is why you see databases from only one instance.

If you want to see the other databases, you have a couple of options:

1. Manually catalog the databases from the other instance within your primary instance

2. Define new connections (JDBC) to the databases in the other instance

Data Studio can not, as far as I can tell, perform discovery to find DB2 instances, nor can it create DB2 instances. It's intended to be primarily a remote client, even if it does rely on ssh to execute certain OS-level commands on remote machines.

这篇关于为什么我看不到Data Studio中的所有DB2实例？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！