Eg. Create tablespace rbstemp datafile '/path/rbstemp01.dbf' size 50M'.
例如,Create tablespacerbstempdatafile '/path/rbstemp01.dbf' size50M'。
Additional table Spaces can be created by executing the create TABLESPACE statement.
额外的表空间可以通过执行CREATE tablespace语句创建。
And if you want to create a table space named MY_SPACE1 in this database, simply execute a create TABLESPACE statement that looks like this.
如果您想创建一个名为MY _ SPACE1的表空间,只需执行如下所示的CREATE tablespace语句。
This is accomplished by specifying the COMPRESS YES option in the CREATE TABLESPACE statement, and then executing either the LOAD or REORG utility on the table space.
这是通过在CREATE tablespace语句中指定COMPRESSYES选项,然后对表空间执行LOAD或REORG实用程序来实现的。
IMPORTANT: For DB2, you must create an additional regular user tablespace with a page size of 16 KB.
重点:对于DB2,必须创建一个额外的、页面大小为16 KB的常规用户表空间。
Create regular tablespace TS page, size 16k, managed by system using (FNIS buffer pool BP).
创建常规表空间TS页面,大小16K,由系统管理(fnis缓冲池BP)。
Before copying the contents of table SALES to tablespace IBMDB2SAMPLEREL, you have to create an empty table in the destination tablespace that has the same structure as table SALES.
在把sales表的内容复制到IBMDB2SAMPLEREL表空间之前,必须在目标表空间中创建一个空表,此表的结构应该与sales表相同。
Create DB2 database, buffer pool, and tablespace with more than 4k.
创建DB 2数据库、缓冲池和表空间,使用大于4k的页面大小。
As shown in Listing 16, create a tablespace with one container named cont1.
如清单16所示,用名为cont1的容器创建表空间。
The following example shows how to create or alter a tablespace to use this option.
下面的例子展示了如何创建或修改表空间,以便使用NO FILE SYSTEM CACHING选项。
Create a table named table1 in the cont1 tablespace, as shown in Listing 17.
在cont1表空间中创建名为table1的表,如清单17所示。
Create a table named table1 in the cont1 tablespace, as shown in Listing 17.
在cont1表空间中创建名为table1的表,如清单17所示。
应用推荐