Examining the contents of the system catalog tables.
检查系统目录表的内容。
A new system catalog table, sysfragdist, is introduced for this feature.
新的系统目录表格sysfragdist，为此功能引入。
A set of system catalog tables is created and maintained for each database.
对于每个数据库，都创建和维护一组系统编目表。
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.
数据库服务器不更新系统编目表中的统计信息。
The distribution statistics are stored in the system catalog view SYSCAT.COLDIST.
分布统计信息存储在系统编目视图SYSCAT.COLDIST 中。
Named SYSCATSPACE by DB2, the catalog table space holds the system catalog tables.
目录表空间被DB 2命名为SYSCATSPACE，它保存了系统目录表。
The DB2 UDB system catalog is a collection of tables that describe database objects.
DB 2udb系统编目是描述数据库对象的表的集合。
The optimizer USES the following system catalog information as it creates a query plan.
当优化器创建查询计划时，它将使用下列系统目录信息。
Ensure that there is sufficient free space on the system catalog and the system temporary tablespaces.
确保系统目录和系统临时表空间中具有足够的自由空间。
Prior to DB2 9, most of the objects have only definer in the corresponding system catalog table or view.
在DB 29之前，大多数对象在相应的系统编目表或视图中具有惟一的定义者。
You must hold DBADM or SYSADM authority to grant or revoke the SELECT privilege on system catalog views.
必须要有DBADM或SYSADM权限，来授予或撤消系统编目视图上的SELECT权限。
When a database is created, SELECT privilege on the system catalog views is granted to PUBLIC (Figure 6).
在创建一个数据库时，系统编目视图上的SELECT权限便被授给PUBLIC(图6)。
The SYSSTAT schema contains a small number of updatable views that are based on the system catalog tables.
SYSSTAT模式包含少量的基于系统编目表的可更新视图。
An entry is added to the system catalog to indicate to the query optimizer that such a remote index exists.
一个条目被添加到系统编目中，以向查询优化器表明存在那样的一个远程索引。
Use the following command to create a table based on the system catalog that simulates customer information.
使用以下命令，根据模拟客户信息的系统目录创建一个表。
Regular dbspaces: Regular dbspaces hold database objects like system catalog tables, user tables, and indices.
常规dbspace：常规dbspace用来存放数据库对象，如系统目录表、用户表和索引。
The RUNSTATS utility updates statistics in the system catalog tables to help with the query optimization process.
RUNSTATS实用程序用于更新系统目录表中的统计信息，以帮助查询优化过程。
Almost everything that is known about a database can be found in a metadata repository called the system catalog.
我们所知道的所有关于数据库的信息几乎都可以在称作系统编目的元数据存储库中找到。
You can use the system catalog views to retrieve information about storage management objects such as table Spaces.
可以使用系统编目视图来检索关于表空间之类的存储管理对象的信息。
You can use the system catalog views to retrieve information about the dependencies that objects have on one another.
可以使用系统编目视图来检索关于对象相互之间依赖关系的信息。
Of course, you cannot explicitly create or drop these system catalog tables, but you can query and view their content.
当然，不能显式地创建或删除这些系统编目表，但是可以查询和显示这些表的内容。
A new version column is added to sysfragments system catalog table to keep track of changes to statistics information.
在sysfragments系统目录表格中添加一个新版本的列，跟踪统计信息更改。
Use the following command to populate the CUSTOMER_INFO table with data using dummy information from the system catalog.
使用以下命令，用来自系统目录的虚构信息向customer_info表填充数据。
As the calculation of the savings is based just on statistics information in the system catalog, the calculation is fast.
由于对节省空间的计算只基于系统编目中的统计信息，所以这种计算速度很快。
In a relational language, such a query would require a join that might span several data tables and system catalog tables.
而在关系语言中，这种查询需要进行也许跨越了多个数据表和系统目录表的联接。
You can also use the system catalog views to retrieve information about database partitions and database partition groups.
还可以使用系统编目视图来检索关于数据库分区和数据库分区组的信息。
You can use the system catalog views to easily retrieve information about user-defined data types or routines. For example
可以使用系统编目视图来轻松地检索关于用户定义数据类型或例程的信息。
Table 4 lists the respective federated objects and the DB2 system catalog views that can be used to locate the information.
表4列出了各个联邦对象以及可用于定位信息的DB 2系统编目视图。
The runstats utility can be used to update statistics in system catalog tables to facilitate the query optimization process.
可以使用runstats实用程序来更新系统编目表中的统计信息，使查询优化过程更容易一些。
应用推荐