Capacity Analyst Repository Installation

From RapidSQL
Jump to: navigation, search

Go Up to Getting Started with the Capacity Analyst

The Capacity Analyst Repository Installation Wizard lets you install the repository on each database the Capacity Analyst runs against. The repository holds all the captured metrics that you want to collect. For example, this can be the space used in an Oracle tablespace or the number of physical reads on a Microsoft SQL Server.

The wizard installs a set of objects to manage the captured data, and a security role to manage access to the repository and objects.

The Analyst Repository Installation Wizard lets you:

  • Create a new repository.
  • Upgrade an existing repository.
  • Assign a repository owner.
  • Assign object placement in the database.
  • View feedback on the repository install actions.

Completing the Analyst Repository Installation Wizard

To install the repository, do the following:

  1. On the DBArtisan toolbar, click the Capacity Analyst icon.
    DBArtisan opens Capacity Analyst. Capacity Analyst detects that no repository is present and opens the Analyst Repository Installation Wizard.
  2. Use the following table as a guide to understanding and setting options in the Wizard,
Panel Option Description

1

Create a new repository

Lets you create a new repository under a new schema.

Upgrade existing repository

Lets you upgrade the version of a current repository. Updates the stored procedures, and adds any new columns to tables. Also lets you use a an existing repository that was created for a different Analyst. NOTE: Available only if the wizard detects the presence of an earlier version.

Use current login information

IBM DB2 ONLY: Select to use the default connectivity information as the login id/password.

Login Name

Lets you type the server administrator ID. NOTE: An administrator ID is not required after the initial repository setup.

Password

Lets you type the server administrator password.

Login As

ORACLE ONLY: Lets you select one of three Oracle login modes: Default - Establishes connection with no system roles. SYSDBA - Lets you perform all DBA-related functions, like startup and shutdown. NOTE: SYSDBA is required for the SYS id when you log into a 9i instance. SYSOPER - Lets you perform many DBA-related functions, like startup and shutdown.

Using

MICROSOFT SQL SERVER: Lets you specify authentication type, either SQL Server Authentication or Windows Authentication.

2

Database

MICROSOFT SQL SERVER ONLY: Lets you select a database. SYBASE ASE ONLY: The following system databases are excluded from the list of potential targets for Repository installation: 'Replication' 'model' 'sybsecurity' 'sybsystemdb' 'sybsystemprocs' 'tempdb' 'dbccdb' 'sybdiag'

Login

MICROSOFT SQL SERVER and SYBASE ASE ONLY: Lets you select an owner. NOTE: Should have the CREATE PROCEDURE privilege on the storage device that is selected. For Oracle, the storage for tables and storage for indexes are tablespaces. The owner must have privileges for the tablespaces.

Owner

ORACLE ONLY: Select a new user to own the repository or click New to open the User Wizard. For details, see Users Wizard (Oracle). NOTE: Should have the CREATE PROCEDURE privilege on the storage device that is selected. For Oracle, the storage for tables and storage for indexes are tablespaces. The owner must have privileges for the tablespaces.

Storage for tables (and its available space)

Lets you separate the storage placement of repository tables and indexes. For Oracle, the storage for tables are tablespaces. Select from the list. Or click New to open the creation wizard.

Storage for indexes (and its available space)

Lets you separate the storage placement of repository tables and indexes. For Oracle, the storage for indexes are tablespaces. Select from the list. Or click New to open the creation wizard.

Password

Lets you specify a password for the repository owner.

Schema

IBM DB2 ONLY: Lets you select a schema. All the tables in the repository will be created for this schema. The default value is IDERACA.

Tablespace for Repository Tables

IBM DB2 ONLY: Lets you select the tablespace on which the repository tables are created.

Tablespace for Repository Indexes

IBM DB2 ONLY: Lets you select the tablespace on which the repository tables are created.

New

IBM DB2 ONLY: Click to open the Tablespace WIzard. FOr details, see Tablespaces Wizard (DB2 LUW).

3

Repository Login

Displays repository login

Execution Log

Displays installation log.

Execution Errors

Displays any errors if they occur.

Finish

Click to complete the installation. Capacity Analyst installs the necessary files and displays the installation process. When the installation finishes, it displays a finished message. Click Finish to open the Capacity Analyst tab. If the installation fails, Capacity Analyst lets you stop the repository installation. Capacity Analyst deletes the objects that it created.

3. When ready, click Install.
Capacity Analyst creates the repository. Capacity Analyst prompts you to grant other user accounts the privilege of using Capacity Analyst.
4. Select a basic security role:
  • Administrator – Users granted this privilege can create, edit, remove, and view capacity collection information.
  • User - Users granted this privilege can only view capacity collection information.
Tip: You can easily grant or remove users from these roles at repository installation time or afterwards. For details, see Managing Repository Security.