检查系统目录表的内容。
注意,新的系统目录表将在逆转过程中删除。
Note that the new system catalog tables will be dropped during the reversion process.
系统目录表和数据库本身位于同一个dbspace中。
System catalog tables reside in the same dbspace as the database itself.
只有当进行显式的请求时,对象的统计信息才会在系统目录表中被更新。
Statistics for objects are updated in the system catalog tables only when explicitly requested. There are several ways to update some or all of the statistics.
RUNSTATS实用程序用于更新系统目录表中的统计信息,以帮助查询优化过程。
The RUNSTATS utility updates statistics in the system catalog tables to help with the query optimization process.
要查看是否对数据库执行了RUNSTATS,一种快捷方法便是查询一些系统目录表。
One quick way to see whether RUNSTATS has been performed on your database is to query some system catalog tables. For example, as shown in the script above, you can run this command.
目录表空间被DB 2命名为SYSCATSPACE,它保存了系统目录表。
Named SYSCATSPACE by DB2, the catalog table space holds the system catalog tables.
而在关系语言中,这种查询需要进行也许跨越了多个数据表和系统目录表的联接。
In a relational language, such a query would require a join that might span several data tables and system catalog tables.
一个名为syscatspace的大表空间,用于存储与数据库有关的系统目录表和视图。
A large table space named SYSCATSPACE, which is used to store the system catalog tables and views associated with the database.
然后,系统目录表SYSCAT.DATAPARTITIONS 被更新来反映这个更改。
The system catalog table SYSCAT.DATAPARTITIONS is then updated to reflect the change.
常规dbspace:常规dbspace用来存放数据库对象,如系统目录表、用户表和索引。
Regular dbspaces: Regular dbspaces hold database objects like system catalog tables, user tables, and indices.
数据模型中的关键元素是一组统计信息,该统计信息收集了有关数据库中所包含的数据和系统目录表中所存储的数据的信息。
A key element in the data model is the set of statistics gathered about the data contained in the database and stored in the system catalog tables.
表空间可以由一个或多个容器组成,这些容器可是操作系统的一个文件或一个目录。
A table space can comprise one or more containers, which can be a file or directory at the operating system level.
根据系统目录的内容,账单表是空的。
表1并不全面,但是涵盖了大多数UNIX系统上最重要的目录。
Table 1 isn't comprehensive, but it covers the most important directories that exist on most UNIX systems.
注意,来自所有片段的数据被一同存储,形成了表级别的统计数据,被编码并存储到系统目录sysdistrib中。
Notice that data from all fragments is sorted together to form table level statistics, which is encoded and stored in the system catalog sysdistrib.
使用以下命令,根据模拟客户信息的系统目录创建一个表。
Use the following command to create a table based on the system catalog that simulates customer information.
表9:文件系统装入点目录名定义。
System——存储系统表中的目录信息。
这么做会在每个操作系统的根映像目录下创建文件 rootimg.gz并会用新创建的映像的名称相应更新表osimage和linuximage。
under the root image directory of each operating system and updates the tables osimage and linuximage with the names of the newly created images.
使用以下命令,用来自系统目录的虚构信息向customer_info表填充数据。
Use the following command to populate the CUSTOMER_INFO table with data using dummy information from the system catalog.
确保系统目录和系统临时表空间中具有足够的自由空间。
Ensure that there is sufficient free space on the system catalog and the system temporary tablespaces.
当将命令参数“SETPROFILE”添加到RUNSTATS命令时,将在表描述符和系统目录中注册或存储统计信息配置文件。
A statistics profile is registered or stored in the table descriptor and system catalogs when the command parameter "SET profile" is added to the RUNSTATS command.
DB 2luw下的每个数据库都拥有其独有的目录表,即每个db2子系统保存目录表。
While each database in DB2 LUW holds its exclusive catalog tables, it is every DB2 subsystem that holds catalog tables.
图8显示了一个具有五个表空间的数据库:一个目录表空间、两个常规表空间、一个长表空间和一个系统临时表空间。
Figure 8 shows the database, which has five table Spaces: a catalog, two regular, a long, and a system temporary table space.
语句不能引用系统表或视图,包括目录视图和动态管理视图。
The statement must not reference system tables or views including catalog views and dynamic management views.
下列示例利用系统管理的目录表空间以及数据库管理的临时表空间和用户表空间创建了名为tested的数据库。
The following example creates the database named tested with a system-managed catalog tablespace and database-managed temporary and user tablespaces.
这个例子数据库有5个表空间:一个目录表空间、两个常规表空间、一个长表空间和一个系统临时表空间。
The example database has five table Spaces: one catalog, two regular, one large, and one system temporary table space.
将注册表备份到修复目录中。如果注册表已损坏,这种备份可用来帮助恢复您的系统。
Backup the registry to the repair directory. This backup can be used to help recover your system if the registry is damaged.
将注册表备份到修复目录中。如果注册表已损坏,这种备份可用来帮助恢复您的系统。
Backup the registry to the repair directory. This backup can be used to help recover your system if the registry is damaged.
应用推荐