增加下列结构的有效性:索引或索引分区,表或表分区,索引表。
Validate the structure of an index or index partition, table or table partition, index-organized table.
类型表、范围分区或mdc表。
完整的表空间(非分区的或分区表的所有分区)。
Complete table space (Non-partitioned or all partitions of a partitioned table).
源表必须是非分区表,或者是只拥有一个分区且没有已附加或已分离的分区的分区表。
The source table must be a nonpartitioned table or a partitioned table that has only one partition and no attached or detached partitions.
于是,对于大型的表,工作负载可以分布在多个分区上,而更小的表也可以存储在一个或多个数据库分区上。
A workload can then be spread across multiple partitions for large tables, while allowing smaller tables to be stored on one or more database partitions.
当一个数据库由两个或更多数据库分区组成,并且每个数据库分区存储位于其中的每个表的一部分表数据时,就属于数据库分区的情况。
Database partitioning occurs when a database consists of two or more database partitions, where each database partition stores a subset of table data for each table that resides within it.
这个例程用新的分区键创建了现有表的一个副本并用来自原始表的数据对它进行部分或全部加载。
This routine creates a copy of your existing table with the new partitioning key and loads it partially or fully with the data from the original table.
如果不为索引或长列指定表空间,分区索引和长列数据会存储在与数据相同的表空间中。
If you don't specify an index or long table space, partitioned indexes and long column data will go in the same table space as the data.
XML数据的表空间位置由LONGin子句决定,其可在分区级别、表级别、或它们的任何组合中指定。
The table space placement for XML data is determined by the LONG in clause, which can be specified at partition level, table level, or any combination thereof.
用于已声明的临时表的用户临时表空间可以在IBMDEFAULTGROUP或任何用户创建的数据库分区组中创建,但不能在IBMTEMPGROUP中创建。
A user temporary tablespace, for declared temporary tables, can be created in IBMDEFAULTGROUP or any user-created database partition group, but not in IBMTEMPGROUP.
由于DB2z/OS实用程序在分区表空间的表空间级或分区级运行,所以它们会影响表空间中存在的所有表。
Since DB2 z/OS utilities run at either table space level or partition level for partitioned-table space, they would affect all tables present in the table space.
在DB 2for LUW中,您可以将这种表的各个分区放在一个或多个表空间上。
In DB2 for LUW, you can place individual partitions of such table on one or more table Spaces.
还记得吗,我们的示例表(Transactions历史表)对于每个月都有一个单独的分区,而我们是每天添加一次或多次数据。
Recall our sample table (Transactions history table) has a separate partition for each month, yet we are adding data one or more times per day.
得到一切后,即使在驱动器的分区表,引导记录,主文件表或根目录是丢失或损坏。
Get everything back even when the drive's partition table, boot record, Master File table or root directory is lost or corrupt.
得到一切后,即使在驱动器的分区表,引导记录,主文件表或根目录是丢失或损坏。
Get everything back even when the drive's partition table, boot record, Master File table or root directory is lost or corrupt.
应用推荐