Search results
A table can be both a multidimensional clustering (MDC) table and a partitioned table. Columns in such a table can be used in both the range-partition-spec and in the MDC key. Table partitioning is multi-column, not multidimensional. For a partitioned MDC table created by Db2 Version 9.7 Fix Pack 1 or later releases, the block indexes are ...
The table-name specified in a REFERENCES clause must identify the table being created or a base table that already exists at the application server, but it must not identify a catalog table, a declared temporary table, a distributed table, or a history table. If the parent is a partitioned table, the unique index that enforces the parent unique constraint must be non-partitioned.
A base table is created with the CREATE TABLE statement and is used to hold persistent user data. For more information see CREATE TABLE. A base table has a name and may have a different system name. The system name is the name used by the IBM® i operating system. Either name is acceptable wherever a table-name is specified in SQL statements.
Processor Value Units (PVUs) A Processor Value Unit (PVU) is a unit of measure used to differentiate licensing of software on distributed processor technologies (defined by Processor Vendor, Brand, Type and Model Number). Full versus Sub-capacity. Processor Value Units (PVUs) PVU tables.
If the page size of the system temporary table space does not match the page size of the table spaces where the table data is located, the Db2® database product tries to find a temporary table space of the correct size. The correct size matches the size of the LONG/LOB objects. This action applies to 8 KB, 16 KB, or 32 KB table objects. Such a table space must exist for the reorganization to ...
When a ROWID column is defined as GENERATED BY DEFAULT in the CREATE TABLE statement, and the CREATE TABLE statement is processed by SET CURRENT RULES = 'STD' or the table space that contains the table is implicitly created, Db2 implicitly creates the unique indexes used to enforce the uniqueness of the ROWID column.
Table. Table allows you to create a table using other controls such as Text, Decimal, Output Text. Set or modify the data binding for the control in the General properties tab. The table control is bound to a list of objects that populates the rows. Set or modify configuration properties for Table in the Configuration properties tab. A ...
Procedure. In the module, select the object to insert the table under. Click Table > Insert, and then click either After or Below. In the window that opens, enter information about the table, and then click OK. Add and modify content in the table by using the Table menu and the Table Properties window. Tip: Before you copy and paste or drag a ...
Tables are logical structures that Db2 maintains. Db2 supports several different types of tables. Tables are made up of columns and rows. The rows of a relational table have no fixed order. The order of the columns, however, is always the order in which you specified them when you defined the table. At the intersection of every column and row ...
The catalog tables describe such things as table spaces, tables, columns, indexes, privileges, application plans, and packages. Authorized users can query the catalog; however, it is primarily intended for use by Db2 and is therefore subject to change. All catalog tables are qualified by SYSIBM. Do not use this qualifier for user-defined tables.
