Space Analyst Functionality
Go Up to Using Space Analyst
Space Analyst offers functionality that help you analyze space. The Space Analyst support the following functionality:
- Note: Functionality differ by platform.
- Analysis Report
- Convert to Dictionary Managed
- Convert to Locally Managed
- Resize
- DBCC
- Drop
- Estimate Size
- Extract
- Index Details
- Map
- Move Log
- Databases Wizard (Sybase ASE)
- Databases Device Wizard (Sybase ASE)
- Segment Wizard (Sybase ASE)
- Tables Wizard (DB2 LUW)
- Tablespaces Wizard (DB2 LUW)
- Open Editor
- Open Wizard
- Options
- Place
- Quick Reorganize /Reorg
- DBCC
- Refit
- Reinitialize
- Reorganize
- Shrink
- Table Details
- Update Statistics
Contents
Space Analyst - Analysis Report
The Analysis Report dialog lets you build an HTML analysis report for the selected tablespace. You can run reports on a recurring basis and dynamically alter any saved thresholds that flag space problems in the tablespace being analyzed.
For Oracle, the report includes sections for particular reorganization needs, including:
- Fragmentation index for the tablespace
- Tables with high block inefficiencies
- Tables or indexes with next extent space deficit problems
- Tables or indexes with maximum extent limit problems
- Tables or indexes with percent increase greater than zero
- Tables with chained/migrated row problems
- Indexes with B-tree depth problems
For Microsoft, the report contains different sections that highlight particular reorganization needs, including:
- Free space levels for the database and log
- Tables with forwarded record problems
- Indexes with average fragmentation problems
- Tables or indexes with extent fragmentation problems
- Tables or indexes with logical fragmentation problems
- Tables or indexes with scan density problems
- Tables or indexes with average page density problems
For Sybase ASE, the report contains different sections that highlight particular reorganization needs, including:
- Free space levels for the database and log
- Tables with forwarded row problems
- Tables with empty page problems
- Tables with deleted row problems
- Tables with low fragmentation scores
- Indexes with unused space problems
- Indexes with empty leaf problems
- Indexes with height/level problems
- Indexes with low fragmentation scores
For IBM DB2 for Linux, Unix, and Windows, the report contains different sections that highlight particular reorganization needs, including:
- Tables with overflow problems
- Tables with space utilization problems
- Tables with page utilization problems
- Tables with index space contention
- Indexes with cluster ratio problems
- Indexes with used space% problems
- Indexes with balance problems
- Indexes with deleted RID problems
- Indexes with empty leaf problems
- Indexes with low uniqueness
- Free levels of tablespace and log space
To open the Analysis Report dialog box:
- Open the Space Analyst.
- On the Command menu, click the Analysis Report.
For all platforms, browse to or type a report title and make your desired selections from the drop-down lists. After the report executes, you can print it or save it.
To print the report:
- Click Print from the Analysis Report toolbar.
To save the report:
- Select Save from the File menu on the main toolbar.
Space Analyst - Convert to Locally-managed
The Convert to Locally-Managed dialog lets you convert a dictionary-managed tablespace to locally-managed. Objects in locally-managed tablespaces have unlimited extents; they will never fail to extend due to an imposed maximum extent limit.
Important Notes
There are a few restrictions on these conversion procedures (for example, Oracle9i UNDO tablespaces currently can't be converted, etc.), so you should check the Oracle documentation for the specifics on performing a conversion.
The Convert to Locally-Managed option is only available if the selected tablespace(s) are:
- ONLINE
- In Read/Write mode
- Dictionary managed
- Not UNDO tablespaces
- Not Temporary tablespaces
- Not the SYSTEM tablespace
The table below describes the options and functionality on the Convert to Locally-Managed dialog
Option | Description |
---|---|
Tablespaces to be Converted |
Displays the tablespaces to be converted to locally-managed. |
Conversion Options |
OPTIONAL: Lets you type allocation unit and relative file number information. |
Completing the Convert to Locally-Managed Dialog Box for Space Analyst
To complete this dialog box, do the following:
- Select Convert to Locally-Managed.
- OR
- Right-click the target object, and then select Convert to Locally-Managed.
- The Space Analyst opens the dialog box.
- Do one of the following:
Button | Description |
---|---|
Opens the Preview dialog. | |
Opens a scheduling application. | |
Executes the task. |
Space Analyst - Convert to Dictionary-Managed
- Note: The Convert to Dictionary-Managed functionality is for Oracle 9i only.
The Convert to Dictionary-Managed dialog lets you convert a locally-managed tablespace to dictionary.
Important Notes
The Convert to Dictionary-Managed dialog is only available if the selected tablespace(s) are:
- ONLINE
- In Read/Write mode
- Locally managed
- Not UNDO tablespaces
- Not Temporary tablespaces
- Not the SYSTEM tablespace
The table below describes the options and functionality on the Convert to Dictionary-Managed dialog:
Option | Description |
---|---|
Tablespaces to be Converted |
Displays the tablespaces to be converted to dictionary-managed. |
Completing the Dictionary-Managed Dialog Box for Space Analyst
To complete this dialog box, do the following:
- Select Convert to Dictionary-Managed.
- OR
- Right-click the target object, and then select Convert to Dictionary-Managed.
- The Space Analyst opens the dialog box.
- Do one of the following:
Button | Description |
---|---|
Opens the Preview dialog. | |
Opens a scheduling application. | |
Executes the task. |
Space Analyst - Extract
The Extract functionality lets you extract the database DDL in an ISQL editor.
To extract the database DDL in an ISQL editor, do the following:
- Click the Extract DDL button.
- OR
- Select Extract.
- OR
- Right-click the target object, and then select Extract.
- Space Analyst extract the database DDL in an ISQL editor.
Space Analyst - Map
The Map functionality opens the Tablespace Map tab or Map tabof the Space Analyst for the selected index.
Important Notes
None
Opening the Tablespace Map Tab for Space Analyst
To open the Tablespace Map or Map tab, do the following:
- Select Map.
- OR
- Right-click the target object, and then select Map.
- Space Analyst open the Tablespace Map tab or Map tab.
Space Analyst - Open Editor
The Open functionality lets you modify objects in the object editors.
To open the object editor, do the following:
- In any grid, select an object.
- Click the Open Editor button.
- OR
- Select Open.
- OR
- Right-click the target object, and then select Open.
- Space Analyst opens the object editor.