从属于系统表空间的数据文件的丢失中恢复。
Recovering from the loss of a data file that belongs to the system tablespace.
所有DB 2表空间都可以使用这个选项,包括系统表空间和临时表空间,以及数据库管理的表空间。
This option is available for all DB2 tablespaces, including system and temporary tablespaces and database managed tablespaces.
表空间可以由一个或多个容器组成,这些容器可是操作系统的一个文件或一个目录。
A table space can comprise one or more containers, which can be a file or directory at the operating system level.
这些是没有用于表空间的系统文件缓存的默认设置的结果。
These results are for our default setup with no file system caching for table Spaces.
临时表空间可以是系统的,也可以是用户的。
可以使用系统编目视图来检索关于表空间之类的存储管理对象的信息。
You can use the system catalog views to retrieve information about storage management objects such as table Spaces.
例如,如果由于表空间配置有问题,系统在I/O 方面存在瓶颈,那么减少不必要的代码页转换仍然无济于事。
For example, reducing unnecessary code page conversion is not goign to help if your system is heavily I/O bound due to an unfortunate table space configuration.
操作系统(包括调页空间)、DB 2日志和DB 2表空间应当拥有各自的专用磁盘。
The operating system (including paging space), DB2 logs, and DB2 table Spaces should each have their own dedicated disks.
这个表空间是最适合数据库管理器需求的一种特殊用途文件系统的一个实现。
This table space is an implementation of a special-purpose file system designed to best meet the needs of the database manager.
重要的是,要注意当每一个数据库表空间创建时,文件系统缓存已经通过指定NOFILESYSTEM cache子句并被禁用。
It is important to note that file system caching was disabled by specifying the no file system CACHE clause when each table space in the database was created.
DB 2同样总是需要一个也是4KB页面大小的系统临时表空间。
As well, DB2 always required a system temporary table space that had a 4 KB page size too.
如果存在这样的表空间,那么必须将这些容器也复制到新的系统中(如果改变其路径,也需要在配置文件中列出)。
If there are any such table Spaces, then those containers must be copied to the new system as well (and if their paths are changing then they need to be listed in the configuration file).
如前所述,当您在UNIX中创建一个文件系统时,将为inode表分配大约百分之一的总磁盘空间。
As mentioned earlier, when you create a file system in UNIX, about 1 percent of the total disk space is allocated to the inode table.
目录表空间被DB 2命名为SYSCATSPACE,它保存了系统目录表。
Named SYSCATSPACE by DB2, the catalog table space holds the 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.
对于步骤2来说,我对头文件进行了更新:在系统调用表中为这几个新函数安排空间。
For step 2, I update the header files to make room for the new functions in the system call table.
一旦将数据放在dms表空间上,就可以根据表空间的容器进一步选择是使用原始设备还是文件系统。
Once you have settled on DMS table Spaces, you can furthermore choose between raw devices or file system based containers for the table space.
操作系统通过一个内部表将处理器地址空间中的内存段映射到内存页,该表定义哪些内存段由哪些处理器所拥有,等等。
Operating systems map memory segments in a processes' address space to memory pages through an internal table which defines what memory segments are owned by what processes, and so on.
只有通过添加空间到底层文件系统,您才能够将空间添加到您的表空间。
You will be able to add space to your table space only by adding space to underlying file-system.
为应用程序堆、语句堆、缓冲池和临时表空间这些区域中的本地处理调优联邦系统。
Tune the federated system for local processing in the areas of application heap, statement heap, buffer pool, sort heap, and temp tablespace.
最好从系统临时表空间创建用户临时表空间。
It is best to create user temporary table space from the system one.
IBMCATGROUP-用于包含系统编目的表空间的默认数据库分区组。
IBMCATGROUP - default database partition group for the tablespace containing the system catalogs.
确保系统目录和系统临时表空间中具有足够的自由空间。
Ensure that there is sufficient free space on the system catalog and the system temporary tablespaces.
IBMTEMPGROUP -用于系统临时表空间的默认数据库分区组。
IBMTEMPGROUP is - default database partition group for system temporary tablespaces.
下列 REORG示例重新组织客户表,并使用系统临时表空间 TEMPSAPCE1作为工作区域以存储中间结果。
The following REORG example reorganizes the customer table using the system temporary tablespace TEMPSAPCE1 as a work area to store the intermediate results.
考虑对所有小于52kb的表进行自动表重组,在线执行所有索引重组,并在重组时使用系统临时表空间。
Consider all tables for automatic table reorganization that are smaller than 52kb, perform all index reorganizations online, and use a system temporary table space when doing reorganization.
对于DMS设备容器表空间,操作系统不在文件系统缓存器中缓存页面。
For DMS device container tablespaces, the operating system does not cache pages in the file system cache.
图8显示了一个具有五个表空间的数据库:一个目录表空间、两个常规表空间、一个长表空间和一个系统临时表空间。
Figure 8 shows the database, which has five table Spaces: a catalog, two regular, a long, and a system temporary table space.
还要通过仔细地将表空间映射到磁盘上来组织好磁盘子系统,从而获得最佳性能。
The disk subsystem is organized for optimal performance by carefully mapping the tablespaces onto the disks.
记住,可以对表空间使用自动调整选项以及详细的监控配置,如果某个表空间已满并需要调整大小,系统会及时通知您。
Keep in mind that auto-sizing options are available for database table Spaces as well as detailed monitoring configurations that notify you if specific table Spaces are full and need resizing.
应用推荐