但是编目表不受这个选项的影响。
是否需要同时列出数据库编目表?
Do you need the database catalog tables to be listed along with other tables in the list?
更新数据库服务器用于优化查询的系统编目表。
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.
SYSCAT模式包含编目表的有用只读视图。
The SYSCAT schema contains useful read-only views of the catalog tables.
对于每个数据库,都创建和维护一组系统编目表。
A set of system catalog tables is created and maintained for each database.
根据所存储数据的类型,可以将编目表分成很多类。
The catalog tables can be classified into broad categories based on the type of data that they store. For example.
编目分区是存放数据库编目表的数据库分区。
The catalog partition is the database partition where the catalog tables for the database are stored.
在创建一个数据库时,也会顺带创建一组编目表和视图。
A set of catalog tables and views is created whenever a database is created.
但是根据数据库的编目表创建数据模型并不是惟一的选择。
But creating a data model based on a database's catalog tables is not the only option.
在SYSSTAT模式里的编目表中可以验证该调用的结果。
The results of the call can be verified in the catalog tables in the SYSSTAT schema.
SYSSTAT模式包含少量的基于系统编目表的可更新视图。
The SYSSTAT schema contains a small number of updatable views that are based on the system catalog tables.
显示的编目表实际上是视图;对于每个表,这个图中忽略了几列。
The catalog tables shown are actually views; from each, several columns are omitted in this figure.
在DB 29之前,大多数对象在相应的系统编目表或视图中具有惟一的定义者。
Prior to DB2 9, most of the objects have only definer in the corresponding system catalog table or view.
从源服务器的SYSJARCONTENTS编目表中提取出jar文件。
Extract the JAR files from the source server's SYSJARCONTENTS catalog table.
如果确认注释XML模式有效,则提取映射信息并把它以可用的二进制格式存储在编目表中。
If the annotated XML schema is deemed valid, mapping information is extracted and stored in catalog tables in a ready-to-use binary format.
当然,不能显式地创建或删除这些系统编目表,但是可以查询和显示这些表的内容。
Of course, you cannot explicitly create or drop these system catalog tables, but you can query and view their content.
分区数据库的编目表只存储在发出CREATEDATABASE命令时所在的那个分区上。
The catalog tables for partitioned databases reside only on the partition from which the CREATE database command was issued.
数据库管理器创建和维护两组系统编目视图,这些视图是在基本系统编目表之上定义的。
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.
一个编目视图可以基于一个或多个编目表,并且视图中的列名常常与它们在编目表中对应的列不同。
A catalog view can be based on one or more catalog tables, and the view column names are often different than their counterparts in the catalog table.
每个数据库有自己的编目表空间、临时表空间和用户表空间,这些表空间是在成功创建数据库时默认创建的。
Each database has its own catalog table space, temporary table space, and user table space which are created by default upon successful database creation.
RationalDataArchitect将检查编目表(在某些数据库系统中也称系统表),并根据该信息创建数据模型。
Rational Data Architect will go through the catalog tables, also known as system tables in some database systems, and create a data model based on that information.
如果检查后发现带注释的XML模式有效,那么映射信息将被提取并以即用型(ready - to - use)二进制格式存储在编目表中。
If the annotated XML schema is deemed valid, the mapping information is extracted and stored in catalog tables in a ready-to-use binary format.
可以使用系统编目视图来检索关于表空间之类的存储管理对象的信息。
You can use the system catalog views to retrieve information about storage management objects such as table Spaces.
下面的场景展示了在DB2编目本身的一个表 SYSIBM.SYSTABLES 上收集的统计信息。
The following scenario shows collected statistics on a table of the DB2 catalog itself, the table SYSIBM.SYSTABLES.
这是因为表名和列名在被写入到DB2的内部编目之前通常要换成大写形式。
This is because table and column names are typically folded into uppercase before being written to DB2's internal catalog.
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.
应用推荐