Migrate DB2 UDB applications to a partitioned database
将DB2UDB应用程序迁移到分区数据库中
Server assisted client reroute for partitioned database environments
用于分区数据库环境的服务器辅助客户机重路由
Figure 1 illustrates the DB2 architecture in a partitioned database environment.
图1说明了分区数据库环境中的DB 2架构。
In a non-partitioned database, no partitioning key or partitioning map is required.
在一个非分区数据库中,不需要分区键或分区映射。
Tables within a partitioned database can be located in one or more database partitions.
在分区数据库中,一个表可以分布在一个或多个数据库分区中。
Slice extends OpenJPA for a distributed, horizontally partitioned database environment.
Slice将OpenJPA扩展用于一个分布式的、水平分区的数据库环境。
Note: IXF files cannot be used to load into a table defined in a hash partitioned database.
注意:无法使用IXF文件将导出表装入哈希分区数据库中定义的表。
Each additional server means more CPUs, more memory, and more disks for your partitioned database.
每多一个服务器,就意味着将有更多的CPU、内存和更多的磁盘用于分区数据库。
Partitioning maps are a flexible way of controlling where data is stored in a partitioned database.
分区映射是在分区数据库中控制数据存储位置的一种灵活的方式。
An application can upgrade to a partitioned database environment using Slice by reconfiguration only.
使用Slice只需重新配置,一个应用程序就可以升级到一个分区的数据库环境。
Db2pdbc: Handles parallel requests from remote nodes (used only in a partitioned database environment).
db2pdbc:它处理来自远程节点的并行请求。(只用于分区数据库环境中)。
A partitioned database can maintain very large amounts of data and can open opportunities for new applications.
分区数据库可以维护大量数据,并可以为新的应用程序提供机会。
Each database in a partitioned database environment can have its catalog partition on a different database partition server.
在分区数据库环境中,每个数据库可以在一个不同的数据库分区服务器上有它的编目分区。
Manually determining the correct point in time to which to roll forward a database is difficult, particularly for a partitioned database.
手动地确定前滚一个数据库的正确时间点比较困难,对于分区数据库更是如此。
The focus is on application migration, but design, configuration, and operational considerations for a partitioned database is also covered.
其焦点在应用程序的迁移上,但同时也介绍了针对分区数据库的设计、配置和操作考虑。
For partitioned database systems, there should be a separate database file system on each machine that participates in the partitioned database.
对于分区数据库系统,在每台参与分区数据库的计算机上都应该有一个单独的数据库文件系统。
Easily migrate data to a partitioned database or warehouse using the splitter function to unload into pre-split files ready for parallel loading.
使用splitter功能将数据卸载到预分区文件来为并行加载做准备,轻松地将数据迁移到分区数据库或数据仓库。
WebSphere Information Integrator does not support system-maintained materialized query tables that reference nicknames in a partitioned database environment.
WebSphereInformation Integrator不支持在分区数据库环境中引用昵称的系统管理的物化查询表。
Say that you have a partitioned database, which means it is part of a database that contains its own data, indexes, configuration files, and transaction logs.
假设您有一个分区的数据库,这意味着它是一个数据库的一部分,它包含自己的数据、索引、配置文件和事务日志。
If you are running a DB2 partitioned database system on multiple physical nodes, you must install the database software on each database host in identical paths.
如果在多个物理节点上运行DB 2分区数据库系统,那么必须在每个数据库主机上的相同路径中安装数据库软件。
In a multi-partitioned database, an attempt to suspend I/O on any of the non-catalog partitions will require a connection to the catalog node for authorization.
在多分区数据库中,要挂起任何非编目分区上的I/O,都必须有到编目节点的连接,以便进行认证。
For a data partitioning configuration, you must have a file system that is available to all participating machines that participate in your partitioned database system.
对于一个数据分区配置,必须有一个可供所有参与分区数据库系统的机器使用的文件系统。
For the partitioned database to function properly, you must configure the operating system environment, including users and groups, in the same manner on each data node.
为使分区数据库正常运行,必须在每个数据节点中以相同的方式来配置操作系统环境,包括用户和组。
As described above, some of the information provided in the file (such as NODENUM in the case of a multi-partitioned database) must be specified even if the value isn't changing.
如前所述,即使不改变这些信息的值,也必须指定文件中的一些信息(比如多分区数据库中的NODENUM)。
In a partitioned database environment, the database manager must have a way of knowing which table rows are stored on which database partition, so that it can find the data it needs.
在分区数据库环境中,数据库管理器必须有方法知道表的哪些行存储在哪个数据库分区上,以便发现它需要的数据。
In a partitioned database environment, during a LOAD_ONLY operation, partition headers are used to verify that the file only contains data belonging to a specific database partition.
在分区数据库环境中,执行LOAD_ONLY操作期间,分区头用于验证该文件是否只包含属于特定数据库分区的数据。
RUNSTATS does not run in parallel in a partitioned database, but information is determined for one partition, and then extrapolated to determine a suitable estimate for all partitions.
RUNSTATS不是在分区的数据库中并行运行的,但对一个分区确定信息,然后对所有分区推断出合适的估计值。
This article discusses what DB2 partitioning is, Outlines the benefits and costs of using it, and helps you decide whether or not to use a partitioned database, as well as how to migrate to one.
这篇文章讨论DB 2分区是什么,概述了使用DB 2分区的好处和成本,并帮助您决定是否要使用分区数据以及如何迁移至一个分区数据库。
This article discusses what DB2 partitioning is, Outlines the benefits and costs of using it, and helps you decide whether or not to use a partitioned database, as well as how to migrate to one.
这篇文章讨论DB 2分区是什么,概述了使用DB 2分区的好处和成本,并帮助您决定是否要使用分区数据以及如何迁移至一个分区数据库。
应用推荐