Page History
Aqua Data Studio provides visual editors for creating database Storage objects. By navigating the schema browser you may locate the Storage container (a hard drive shaped icon) underneath server connections. Storage objects vary based on database vendor and version.
...
To create a DB2 Buffer Pool, expand the DB2 Storage container and right-click on Buffer Pools to select Create Buffer Pool. Enter a Buffer Pool name and select a page size. Under the Buffer Pool Size section, select the size and the number of Non-blocked and Blocked Pages. Select the Block size in pages. Under the Options, section choose Self Tuning or Use default Buffer Pool size. Select Create Buffer Pool on database restart or Create Buffer Pool immediately. Preview the SQL in the SQL Preview tab. Click OK to finish.
DB2 Buffer Pools
|
|
|
|
| 1. Connect to Server | 2. Right-click on Buffer Pools | 3. Enter Buffer Pool Settings | 4. Preview SQL |
...
To create a DB2 Tablesplace, expand the DB2 Storage container and right-click on Tablespaces to select Create Tablespace. Give the Tablespace a name, enter the path to the container and select the Type. Select the Buffer Pool to use and give the tablespace page size. Under the Storage tab give the Extent Size, Prefetch Size, and set the Overhead and Transfer rate in milliseconds. Preview the SQL in the SQL Preview tab. Click OK to finish.
DB2 Tablespaces
|
|
|
|
|
| 1. Connect to Server | 2. Right-click on Tablespaces | 3. Enter Tablespace Settings | 4. Set Storage Properties | 5. Preview Tablespace SQL |
...
To create Oracle Tablespaces, connect to an Oracle server and expand the tree to view the Storage container. Right-click on Tablespaces within the Storage container and select create Tablespace. Enter Tablespace Settings for Datafile name, file directory location, Status, and Type. In the Storage Tab, set the properties for Extent Management (Automatic or Uniform Allocation), Segment Space Management (Automatic or Manual), and Logging. Adjust the Block Size as needed. Preview the SQL in the Preview SQL tab. Click OK to finish.
Oracle Tablespaces
|
|
|
|
|
| 1. Connect to Server | 2. Right-click on Tablespaces | 3. Enter Tablespace Settings | 4. Set Storage Properties | 5. Preview SQL |
...
Tablespaces can be dropped with a right-click through the Schema Browser.
Oracle Datafiles
| ||||
| 1. Connect to Server | 2. Right-click on Datafiles | 3. Enter Datafile Settings | 4. Set Storage Properties | 5. Preview SQL |
...