更新数据库服务器用于优化查询的系统编目表。
Update system catalog tables that the database server USES to optimize queries.
数据库服务器不更新系统编目表中的统计信息。
The database server does not update the statistics in the system catalog tables.
对于每个数据库，都创建和维护一组系统编目表。
A set of system catalog tables is created and maintained for each database.
SYSSTAT模式包含少量的基于系统编目表的可更新视图。
The SYSSTAT schema contains a small number of updatable views that are based on the system catalog tables.
在DB 29之前，大多数对象在相应的系统编目表或视图中具有惟一的定义者。
Prior to DB2 9, most of the objects have only definer in the corresponding system catalog table or view.
当然，不能显式地创建或删除这些系统编目表，但是可以查询和显示这些表的内容。
Of course, you cannot explicitly create or drop these system catalog tables, but you can query and view their content.
数据库管理器创建和维护两组系统编目视图，这些视图是在基本系统编目表之上定义的。
The database manager creates and maintains two sets of system catalog views that are defined on top of the base system catalog tables.
为了确保包含系统编目表的分区能够快速恢复，应避免将用户表也放在那个数据库分区上。
To ensure fast recovery of the partition containing system catalog tables, avoid placing user tables on the same database partition.
可以使用runstats实用程序来更新系统编目表中的统计信息，使查询优化过程更容易一些。
The runstats utility can be used to update statistics in system catalog tables to facilitate the query optimization process.
可以使用系统编目视图来检索关于表空间之类的存储管理对象的信息。
You can use the system catalog views to retrieve information about storage management objects such as table Spaces.
DB 2udb系统编目是描述数据库对象的表的集合。
The DB2 UDB system catalog is a collection of tables that describe database objects.
表4列出了各个联邦对象以及可用于定位信息的DB 2系统编目视图。
Table 4 lists the respective federated objects and the DB2 system catalog views that can be used to locate the information.
服务器为表中的各个列生成数据分布，这些数据分布被以编码直方图的形式存储在sysdistrib系统编目的encdat列中。
Data distributions are generated by the server for individual columns of a table, and are stored as encoded histograms in the encdat column of the sysdistrib system catalog.
也可以使用系统编目视图来检索关于NOT NULL、惟一、主键、外键和表检查约束的信息。
You can also use the system catalog views to retrieve information about NOT NULL, unique, primary key, foreign key, and table check constraints. For example.
系统编目基表（SYSIBM模式）
DB 2udb系统编目(或简称为“编目”)由很多表和视图组成，这些表和视图由数据库管理器来维护。
The DB2 UDB system catalog (or simply "catalog") consists of a number of tables and views that are maintained by the database manager.
IBMCATGROUP-用于包含系统编目的表空间的默认数据库分区组。
IBMCATGROUP - default database partition group for the tablespace containing the system catalogs.
在这个示例中，customer表的完全限定名包含模式名，V8R2M5，这可以在系统编目中将它与其他名为CUSTOMER的表区分开。
In this example, the fully qualified name of the CUSTOMER table includes the schema name, V8R2M5, to distinguish it from any other table named CUSTOMER in the system catalog.
在这个示例中，customer表的完全限定名包含模式名，V8R2M5，这可以在系统编目中将它与其他名为CUSTOMER的表区分开。
In this example, the fully qualified name of the CUSTOMER table includes the schema name, V8R2M5, to distinguish it from any other table named CUSTOMER in the system catalog.
应用推荐