Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Jeff Rule: "I have to tell you I am really impressed. I have never had a software company turn around a bug fix like this so fast. I have been doing database work for over 20 years and that has never happened.".
Ilakshi Rathod : "This tool is just wonderful. I have never seen any tool for DB2. This tool provides very good features which helps in ease us work as well as quick resolution of any errors.".

More

Add your opinion

Customers
SQL Maestro Group / Products / DB2 / DB2 Maestro / Documentation
Download Buy

DB2 Maestro online Help

Prev Return to chapter overview Next

Create Tablespace Wizard

Create Tablespace Wizard guides you through the process of creating a new server tablespace.

 

The basic principles of Create Object Wizards in DB2 Maestro are covered by the corresponding topic. See below to find the description of wizard steps that are unique to the current object.

 

Specify tablespace options according to your needs. The detailed description is given below.

 

 

Type (LARGE, REGULAR, SYSTEM TEMPORARY, or USER TEMPORARY)

Specifies the type of table space that is to be created. If no type is specified, the default is determined by the MANAGED BY clause.

 

Database partition group

Specifies the database partition group for the table space. The database partition group must exist.

 

Page size

Defines the size of pages used for the table space. The valid values for integer without the suffix K are 4 096, 8 192, 16 384, or 32 768. The valid values for integer with the suffix K are 4, 8, 16, or 32. Any number of spaces is allowed between integer and K, including no space.

 

Managed by (SYSTEM,DATABASE)

SYSTEM specifies that the table space is to be an SMS table space. When the type of table space is not specified, the default behavior is to create a regular table space.

DATABASE specifies that the table space is to be a DMS table space. When the type of table space is not specified, the default behavior is to create a large table space.

 

Extent size

Specifies the number of pages that will be written to a container before skipping to the next container. The extent size value can also be specified as an integer value followed by K (for kilobytes) or M (for megabytes). If specified in this way, the floor of the number of bytes divided by the page size is used to determine the value for the extent size. The database manager cycles repeatedly through the containers as data is stored.

 

Prefetch size

Specifies to read in data needed by a query prior to it being referenced by the query, so that the query need not wait for I/O to be performed.

 

Buffer pool name

The name of the buffer pool used for tables in this table space.

 

Overhead

Specifies the I/O controller overhead and disk seek and latency time. This value is used to determine the cost of I/O during query optimization.

 

Transferrate

Specifies the time to read one page into memory. This value is used to determine the cost of I/O during query optimization.

 

Drop recovery

Indicates whether dropped tables in the specified table space can be recovered.

 

 



Prev Return to chapter overview Next