系统编目描述数据的逻辑和物理结构。
The system catalog describes the logical and physical structure of the data.
系统编目基表（SYSIBM模式）
与模式相关的系统编目信息
它使用来自系统编目中统计信息中的信息。
It USES the information from the statistics in the system catalog.
控制对系统编目的访问。
更新数据库服务器用于优化查询的系统编目表。
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.
您可以使用那些系统编目来检验关于联邦对象的信息。
You can use those system catalogs to verify the information about federated objects.
Syscatspace ——存储系统编目信息。
DB 2udb系统编目是描述数据库对象的表的集合。
The DB2 UDB system catalog is a collection of tables that describe database objects.
SYSSTAT模式包含少量的基于系统编目表的可更新视图。
The SYSSTAT schema contains a small number of updatable views that are based on the system catalog tables.
可以使用系统编目视图来检索关于对象相互之间依赖关系的信息。
You can use the system catalog views to retrieve information about the dependencies that objects have on one another.
可以使用系统编目视图来检索关于表空间之类的存储管理对象的信息。
You can use the system catalog views to retrieve information about storage management objects such as table Spaces.
还可以使用系统编目视图来检索关于数据库分区和数据库分区组的信息。
You can also use the system catalog views to retrieve information about database partitions and database partition groups.
如前所述，没有哪个单独的系统编目视图可以包含所有可用的授权数据。
As mentioned earlier, no single system catalog view contains all the available authorization data.
表4列出了各个联邦对象以及可用于定位信息的DB 2系统编目视图。
Table 4 lists the respective federated objects and the DB2 system catalog views that can be used to locate the information.
关于联邦对象的信息存储在DB2系统编目中，在图2中也叫全局编目。
The information about federated objects is stored in the DB2 system catalogs, also known as the global catalog in Figure 2.
可以使用系统编目视图来轻松地检索关于用户定义数据类型或例程的信息。
You can use the system catalog views to easily retrieve information about user-defined data types or routines. For example
分布统计信息存储在系统编目视图SYSCAT.COLDIST 中。
The distribution statistics are stored in the system catalog view SYSCAT.COLDIST.
由于对节省空间的计算只基于系统编目中的统计信息，所以这种计算速度很快。
As the calculation of the savings is based just on statistics information in the system catalog, the calculation is fast.
IBMCATGROUP-用于包含系统编目的表空间的默认数据库分区组。
IBMCATGROUP - default database partition group for the tablespace containing the system catalogs.
在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.
我们所知道的所有关于数据库的信息几乎都可以在称作系统编目的元数据存储库中找到。
Almost everything that is known about a database can be found in a metadata repository called the system catalog.
在本文中，我将通过实际的例子展示如何从DB 2udb系统编目检索有用的信息。
In this article, I will show you, by way of working examples, how to retrieve useful information from the DB2 UDB system catalog.
数据库管理器创建和维护两组系统编目视图，这些视图是在基本系统编目表之上定义的。
The database manager creates and maintains two sets of system catalog views that are defined on top of the base system catalog tables.
一个条目被添加到系统编目中，以向查询优化器表明存在那样的一个远程索引。
An entry is added to the system catalog to indicate to the query optimizer that such a remote index exists.
为了确保包含系统编目表的分区能够快速恢复，应避免将用户表也放在那个数据库分区上。
To ensure fast recovery of the partition containing system catalog tables, avoid placing user tables on the same database partition.
这条规则同样适用于全局变量的定义——与全局变量相关的权限也在系统编目中进行了定义。
This rule also applies to their definition — privileges associated with a global variable are also defined within the system catalog.
应用推荐