DB2 Database system provide two kinds of backup methods, physical and logical.
DB 2数据库提供了物理备份与逻辑备份两种数据备份的方式。
This section provides some tuning guidelines for the IBM DB2 database system, as an example.
本小节以ibmDB 2数据库系统为例,提供一些数据库调优规则。
Additional details on the DB2 database system monitor can be found in the following articles: " Performance Monitoring, Part 1: It's a Snap(shot)" and " Performance Monitoring, Part 2."
有关DB2数据库系统监视的更多详细信息可以在以下文章中找到:“PerformanceMonitoring,Part1:It'sa Snap(shot)”和“ Performance Monitoring, Part 2”。
After the database has started, open a db2 command window on the system where the database is installed.
数据库启动之后,在安装数据库的系统上会打开一个db 2命令窗口。
Because a federated system includes a DB2 database, you can also store local data, as well as combine information from local and remote tables.
由于联邦系统包含DB 2数据库,因此您还可以存储本地数据库,也可合并来自本地表和远程表的信息。
Because the federated system includes a DB2 database, you can also store local data in it, as well as correlate information from both local and remote tables.
由于联邦系统包括一个DB 2数据库,因此还可以在其中存储本地数据以及来自本地和远程表的相关信息。
Just as in local tables, all the data registration steps described above store the information in the DB2 federated database system catalogs.
与本地表一样,上面描述的所有数据注册步骤都将信息存储在DB 2联邦数据库系统编目中。
Information about the column definitions, index, and statistics for a nickname is stored in the DB2 federated database system catalogs.
关于列定义、索引以及昵称统计信息的信息存储在DB 2联邦数据库系统编目中。
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分区数据库系统,那么必须在每个数据库主机上的相同路径中安装数据库软件。
When a document enters the system, it is stored in the file server and indexed in the DB2 database.
当一个文档进入系统时,它存储在文件服务器上并在DB 2数据库中编制索引。
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数据库,所以还可以将本地数据存储在这个数据库中,也可以存储来自本地表和远程表的组合信息。
You can apply the simple step-by-step performance tuning examples to improve the performance on your own DB2 UDB database system.
您可以应用这些简单的一步步的性能调优示例来提高您自己的DB 2UD b数据库系统上的性能。
In addition to new features for managing database time, DB2 9.7 also helps administrators minimize downtime by making it possible to move database schemas without taking the system down.
除了管理数据库时间的新特性之外,DB2 9.7还支持在不停止运行系统的情况下转移数据库模式,这可以帮助管理员减少停机时间。
Federation takes you to the next level of information integration, allowing the DB2 federated system to act as a virtual database where remote objects can be queried like local tables.
联邦技术将您带到更高级别的信息集成,它允许DB 2联邦系统充当一个虚拟的数据库,使得对远程对象的查询和对本地表的查询一样简单。
To overcome this restriction and to maximize the flexibility of a relational database system, DB2 V9.5 introduces the concept of global variables.
为克服这种约束并最大化实现关系数据库系统的灵活性,DB2V9.5引入了全局变量的概念。
To process the query, the DB2 query compiler consults information in the DB2 federated database system catalog and the data source wrapper modules.
为了处理该查询,DB 2查询编译器查阅DB 2联邦数据库系统编目中的信息以及数据源包装器模块中的信息。
The viewer displays the dependencies of the DB2 database pool sample on DB2 JARs and system modules.
该查看器显示了DB 2数据库池示例对DB 2JAR和系统模块的依赖关系。
In DB2, users do not exist within the database, but are rather managed by the operating system.
在DB 2中,用户不是存在于数据库中,而是由操作系统来管理。
On the other hand, DB2 LUW database stores several information required for normal operation across several operating system files under local database directory.
另一方面,DB 2LUW数据库还存储跨本地数据库目录下的多个操作系统文件正常运行所需的若干信息。
IBM DB2 is a relational database management system that runs on a wide range of devices and operating systems.
IBMDB 2是一个关系数据库管理系统,它能够运行在许多设备和操作系统上。
Please note that you can connect and have full access to the tables in the DB2 database as any of the system users from within your application.
请注意,可以作为任何系统用户从应用程序连接DB2数据库,对其中的表有完全访问权。
Create the logical volumes and file systems on the target DB2 system to match the sizes of the source database file systems.
在目标DB 2系统上创建与源数据库文件系统大小匹配的逻辑卷和文件系统。
In this example, the system LIMSS contains a DB2 instance, DB2, in which the database SAMPLE is located.
本例中,系统LIMSS包含了一个名为db2的DB 2实例,而数据库sample就位于该实例中。
Along with DB2's technical excellence, this ensures DB2's position as a leading database management system.
这个因素与DB2的技术优势结合起来,将确保DB 2成为领先的数据库管理系统。
The backup strategy for your DB2 environment should cover the operating system, the DB2 instance, and the DB2 database.
用于DB 2环境的备份策略应当包括操作系统、DB 2实例、以及DB 2数据库。
Since a DB2 buffer pool is a part of the main memory of the system, the DB2 database manager allocates it for caching tables and index data when it reads or writes to and from media disks.
因为db2缓冲池是系统主内存的一部分,DB 2数据库管理器在它读取或写入磁盘介质时将它分配给缓存表和索引数据。
For this to work, the remote database has to be cataloged in the system database directory of the local DB2 instance.
为此,要在本地DB 2实例的系统数据库目录中对远程数据库进行编目。
The DB2 UDB system catalog is a collection of tables that describe database objects.
DB 2udb系统编目是描述数据库对象的表的集合。
This option is available for all DB2 tablespaces, including system and temporary tablespaces and database managed tablespaces.
所有DB 2表空间都可以使用这个选项,包括系统表空间和临时表空间,以及数据库管理的表空间。
The IBM DB2 database management system has long been a leading player in the area of relational data management.
IBMDB 2数据库管理系统早就成为关系数据管理方面的主导者。
应用推荐