The backup utility in DB2 makes physical copies of the data pages.
DB2中的备份实用程序对数据页进行物理上的复制。
Note that only the table data pages and not the index pages are sampled.
请注意,只对表数据页进行抽样,而不是索引页。
Instead, it writes the data directly to the data pages in the tablespace.
相反,它将数据直接写到表空间中的数据页。
TBSCAN: Retrieves rows by reading all required data directly from the data pages.
TBSCAN:通过直接从数据页中读取所有必要的数据来检索行。
Reserve an appropriate amount of free space on data pages (0 if using APPEND mode).
在数据页上预留适当大小的自由空间(如果使用了APPEND模式,则预留的空间为0)。
The NCI will not feature the new columns (fixed include list) but the data pages will.
NCI不会功能新列(包括固定列表)但数据页。
Indexes are collections of sequentially ordered Pointers or keys used for locating data pages.
索引是用来定位数据页的顺序指针或键的集合。
Page level sampling reduces I/O significantly since it reads only a percentage of the data pages.
而页级的抽样则可以显著减少I/O,因为它只读取一定百分比的数据页。
These RIDs are used by the FETCH node to position the corresponding data pages in the table space.
FETCH节点使用这些 RID来定位表空间内的对应数据页面。
"No eXecute" is a hardware functionality used to block malware code execution by marking data pages.
是一种通过将数据页标记为不可执行来防止恶意代码执行的硬件机制。
Incremental backup allows you to back up only index and data pages that have changed since a previous backup.
增量备份允许只备份自上一次备份以来发生变化的索引和数据页。
Thus, the read operations compete with log writing and the write operation for data pages from the buffer pool.
因而,读操作与日志写和缓冲池中的数据页的写操作之间存在竞争。
The structure of the row locator depends on whether the data pages are stored in a heap or a clustered table.
行定位器的结构取决于数据页是存储在堆中还是聚集表中。
A lower value leaves more space on the data pages, which reduces the need to split data pages as indexes grow.
值越小,数据页上留出的空间越多,这降低了随索引的增大而拆分数据页的需要。
In other words, the data pages are not in any order that resembles their table association on your archive media.
换句话说,数据页完全不是按照它们在存档介质上的表关联顺序存放的。
The pages in each level of the index, including the data pages in the leaf level, are linked in a doubly-linked list.
索引中每个级别的页(包括叶级别的数据页)链接在一个双向链接的列表中。
Extents determine how data is striped across multiple containers and ensure that the data pages in a container are contiguous.
区段确定如何跨越多个容器进行数据分段,并确保一个容器里的数据页面是连续的。
With DMS tablespaces, DB2 has more control over how data pages are physically mapped in disk space groupings known as extents.
通过dms表空间,DB2更加可以控制如何将数据页面物理映射到称作区段的磁盘空间分组中。
Although index entries are sequential, there is no guarantee that rows with adjacent index entries will reside on the same data pages.
虽然索引项是连续的,但是不保证包含相邻索引项的行将驻留在同一数据页上。
Note, however, that inlining significantly increases the row size on your data pages. This in turn decreases the number of rows per page.
但是要注意,内联会极大增加数据页面的行大小,从而减少每个页面的行数量。
Read and write are common operations on data pages, while executing code is commonly associated with a page containing executable code.
读、写数据页是普通的操作,因为执行代码通常与含可执行代码的页面相关联。
In this case, db2 would spawn three db2med processes to the archive media and write the data pages from the db2bm processes to them in parallel.
在这个例子中,db 2将生成3个到存档介质的db 2med进程,然后并行地将数据页从db 2 bm进程写到这三个进程。
The qualifying RIDs are then taken by the fetch node to fetch the corresponding records and data pages from the table space into the DB2 buffer pool.
然后通过FETCH节点获取合格的RID以提取来自表格空间的相应记录和数据页面到db2缓冲池。
In other words, it may be removed from the buffer and written back to the disk before subsequent data pages can be read into the memory and processed.
换言之,在后续数据页被读入内存并被处理之前,它们可能已经从缓冲区中删除,并写回磁盘。
A lower value leaves more empty space on the data pages, which reduces the need to split data pages as indexes grow but requires more storage space.
较小的值在资料页中会留下较多空白空间,因此索引增加时就不需要分割资料页,但需要较多的存放空间。
Row level sampling reads all data pages but considers only a percentage of the rows on each page, and therefore only a subset of the corresponding XDA pages.
行级的抽样读取所有数据页,但是只考虑每页上一定百分比的行,因此只包含相应xda页面中的一部分。
In this example, 10 percent of table data pages are used for the collection of table statistics, while for index statistics all of the index pages will be used.
本例中,10%的表数据页用于表统计信息的收集,而对于索引统计信息,将使用所有的索引页。
DB2 has a very efficient and optimized backup utility that multiplexes the data pages it reads from the database and writes them to the target device in a randomized order.
DB2有一个非常高效的备份实用程序,它可以将从数据库读出的数据页分成多个部分,并以随机的顺序将它们写到目标设备。
Dealing with huge databases such as those in data warehouse environment, both Oracle and DB2 provide incremental and differential backup to avoid copying unchanged data pages.
在处理像数据仓库环境中数据库那样的巨型数据库方面,Oracle和DB 2都提供了增量和差异备份,避免复制未更改的数据页。
It caches the file data as pages, just like virtual memory for processes.
它将文件数据缓存为分页,就如同进程的虚拟内存一样。
应用推荐