Repository Information
Go Up to Getting Started with the Capacity Analyst
The Repository Information dialog displays a tree view to present the information about the repository. The table below describes the standard nodes all datasource platforms:
Node | Description |
---|---|
Repository Owner |
Displays the login name of the repository owner. |
Object Placement |
Displays the database (for SQL Server and Sybase ASE), tablespace (for Oracle), placement for tables and indexes (filegroup name - SQL Server, segment name - Sybase ASE, tablespace - Oracle and DB2). |
Repository Version |
Schema and logic version for the tables/indexes and procedures respectively. |
Microsoft SQL Server
The Repository Information dialog displays the following information for Microsoft SQL Server:
- Repository owner
- Repository version
- Object placement
- Database
- Filegroup name where tables are stored
- Filegroup name where indexes are stored.
- Dates
- Date Created
Sybase ASE
The Repository Information dialog displays the following information for Sybase ASE:
- Repository owner
- Repository version
- Object placement
- Database
- Segment name where tables are stored
- Segment name where indexes are stored.
- Dates
- Date Created
Oracle
The Repository Information dialog displays the following information for Oracle:
- Repository owner
- Repository version
- Object placement
- Tablespace name where indexes and tables are stored
- Dates
- Date Created
- Date Updated
IBM DB2
The Repository Information dialog displays the following information for IBM DB2:
- Repository schema
- Repository owner
- Repository version
- Object placement
- Tablespace name where indexes and tables are stored
- Dates
- Date Created
Completing the Repository Information Dialog Box
- In the DBArtisan Datasource Navigator/Explorer, connect to a datasource that has repository installed.
- On the Analyst toolbar, click the Capacity Analyst button.
- On the Capacity Collection Editor toolbar, select Command, Repo Management, and then Manage Analyst Repo.
- Capacity Analyst opens the Repository Information dialog.
- To save repository information as a report, click Save.
- Capacity Analyst opens the Save Grid dialog.
- In Save In, select the location for the repository file.
- In File Name, type the file name.
- In Save as Type, select a file type.
- Click Save.
- Capacity Analyst generates the report and returns to the Repository Information dialog.
- Click OK.
- Capacity Analyst closes the Repository Information dialog.