Page History

Image RemovedImage RemovedAqua 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

...

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

...

Tablespaces can be dropped with a right-click through the Schema Browser.

Oracle Datafiles

...

A right-click on a datafile within the Schema Browser allows it to be altered.

Oracle Rollback Segment

...

Rollback segments can be dropped with a right-click through the Schema Browser.

Oracle Redo Log Group

...