In DB2, a federated system is used.
在DB 2中,使用的是联合系统。
Figure 2 shows the federated system configuration.
图2展示了这个联邦系统的配置。
The basic concepts of an IBM federated system are depicted as follows.
IBM联邦系统的基本概念展示如下。
Figure 3 shows the federated system configuration that follows this step.
图3展示了遵循这个步骤的联邦系统配置。
The server is registered in the federated system by a CREATE server DDL statement.
服务器是通过CREATESERVERddl语句在联邦系统中注册的。
Authentication information is registered with the federated system as user mappings.
身份验证信息以用户映射的形式向联邦系统注册。
This indicates to the federated system that you are willing to tolerate stale results.
这样便指示联邦系统,您愿意容忍陈旧的结果。
In a federated system a server represents a collection of data on the remote data source.
在联邦系统中,服务器表示远程数据源上的一个数据集合。
A user mapping is registered in the federated system by a CREATE user mapping DDL statement.
用户映射通过CREATEUSERMAPPINGddl语句在联邦系统中注册。
A federated system communicates with each data source by means of software modules called wrappers.
联邦系统与每个数据源通信是通过称作包装器的软件模块进行的。
The output of the query optimizer on a federated system is the Federated Query Execution Plan (FQEP).
联邦系统上查询优化器的输出是联邦查询执行计划(FederatedQuery Execution Plan,FQEP)。
After you register the wrapper libraries with the federated system, register each data source as a server.
在将包装器库注册到联邦系统之后,将每个数据源注册为一个服务器。
Provides helpful hints and tips on how to tune the performance of a distributed query in a federated system.
提供关于如何调优联邦系统中一个分布式查询的性能的提示和技巧。
In a federated system with the data partitioning feature, only user-maintained MQTs are supported for nicknames.
在具有数据分区功能的联邦系统中,对于昵称只支持用户维护的MQT。
Informational constraints help improve query performance in a WebSphere Information Integrator federated system.
信息约束有助于提高WebSphereInformation Integrator联邦系统中的查询性能。
With a federated system, you can use a single SQL statement to send distributed requests to multiple data sources.
有了联邦系统,便可以使用一条SQL语句将分布式请求发送到多个数据源。
When a primary key constraint is defined, the federated system automatically creates a unique index specification.
当定义一个主键约束时,联邦系统自动创建一个惟一的索引规范。
Most federated system users do not need to tune these three options, as the default values perform relatively well.
大多数联邦系统用户不需要调优这三个选项,因为默认值已经相当好了。
The administrator of the federated system controls which DB2 users can open a pass-through session to a remote server.
联邦系统的管理员控制哪些DB2用户可以打开到一个远程服务器的 pass-through会话。
Once an application is connected to the federated database, it can access all authorized objects in the federated system.
一旦应用程序连接到联合数据库,就能访问联合数据库中的所有已授权对象。
After the wrapper libraries are registered with the federated system, each data source needs to be registered as a server.
在包装器库用联邦系统注册过后,每个数据源需要被注册为服务器。
Registering each database as a server allows data on each of these remote databases to be accessed from the federated system.
通过将每个数据库注册为一个服务器,可以使这些远程数据库上的数据能够从联邦系统访问到。
The federated system collects statistics for relational nicknames (and some non-relational nicknames) during nickname creation.
联邦系统在创建昵称时收集关系昵称(和一些非关系昵称)的统计信息。
After you register the remote data sets on the federated system, you can reference them as easily as you would reference local tables.
在联邦系统上注册远程数据集之后,可以像引用本地表那样引用这些数据集。
Just like tables, nicknames have an equivalent set of privileges that can control user access to the nickname objects on the federated system.
与表一样,昵称也有对等的一组权限,用于控制用户在联邦系统上对昵称对象的访问。
An index specification that defines a unique index also conveys information about the uniqueness of the index columns to the federated system.
定义惟一索引的索引规范还将关于索引列惟一性的信息传递给联邦系统。
Another Oracle instance, called the credit Checking server, tracks customers with bad credit history and is accessible from the federated system.
另一个名为CreditChecking服务器的Oracle实例跟踪具有不良信用历史的客户,这个实例可以从联邦系统中访问到。
When it detects a potential update target, the federated system avoids using the block fetch feature in order to maintain the remote cursor position.
当检测到一个潜在的更新目标时,联邦系统避免使用块读取特性,以维护远程游标的位置。
The database manager configuration parameter rqrioblk controls the size of the communication buffer between the federated system and the data sources.
数据库管理器参数rqrioblk控制着联邦系统与数据源之间的通信缓冲区的大小。
Because a federated system includes a DB2 database, you can also store local data in it, as well as combine information from both local and remote tables.
由于联邦系统包括一个DB 2数据库,所以还可以将本地数据存储在这个数据库中,也可以存储来自本地表和远程表的组合信息。
应用推荐