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

Subscribe to our news:
Partners
Testimonials
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.".
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.".

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

Tablespaces

Storage structures contain database objects. The basic storage structure is the tablespace; it contains tables, indexes, large objects, and data defined with a LONG data type.

 

There are two types of table spaces:

 

•Database managed space (DMS) A table space that is managed by the database manager.
•System managed space (SMS) A table space that is managed by the operating system.

 

All table spaces consist of containers. A container describes where objects are stored. A subdirectory in a file system is an example of a container.

 

 

New tablespaces are created within Create Tablespace Wizard. In order to run this wizard you should either

 

•select the Tablespaces list or any object from that list and then use the Create New Tablespace item from the popup menu

or

•open the server in Server Editor and the Tablespaces tab there and press Insert or select the Create New Tablespace item from the popup menu (Alternatively, use the corresponding link of the Navigation Bar).

 

 

 

Tablespaces are edited within Tablespace Editor. In order to open the editor you should either

 

•select the tablespace for editing in the explorer tree (type the first letters of the tablespace name for quick search);
•select the Edit Tablespace item from the popup menu

or

•open the server in Server Editor and the Tablespaces tab there;
•select the tablespace to edit;
•press the Enter key or select the Edit Tablespace item from the popup menu (alternatively, you can use the corresponding link of the Navigation Bar).

 

 

 

To drop the existing tablespace:

 

•select the tablespace to drop in the explorer tree;
•select the Drop Tablespace item from the popup menu

or

•open the server in Server Editor and the Tablespaces tab there;
•select the tablespace to drop;
•press the Delete key or select the Drop Tablespace item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

 

and confirm dropping in the dialog window.

 


Prev Return to chapter overview Next