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.
Contents
- Storage Objects for DB2 UDB: Bufferpools
- Storage Objects for DB2 UDB: Tablespaces
- Storage Objects for Oracle: Datafiles, Tablespaces, Rollback Segments and Redo Log Groups.
...
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 |
...
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 |
...
A right-click on a datafile within the Schema Browser allows it to be altered.
Oracle Rollback Segment
1. Connect to Server | 2. Right-click on Rollback Segments | 3. Enter Rollback Segment Properties | 4. Set Storage Properties | 5. Preview SQL |
...
Rollback segments can be dropped with a right-click through the Schema Browser.
Oracle Redo Log Group
...