This option is the starting point for all new CAST AIP schema installation operations. If you want to:
- create a new Combined Installation (Analysis, Dashboard and Management Service in one go)
- create a new Analysis Service
- create a new Dashboard Service
- create a new Management Service
- create a new Measurement Service (CAST Storage Service only)
...then this is the option you require. You can either use an existing database/schema for your CAST AIP database/schema or create a new database/schema on the host server.
Please note that in order to carry out database/schema installation operations, the username you are using to connect to the selected server must have sufficient privileges (you can change the way you connect to the server in the Open Profile Connection dialog box).
To proceed with a new installation:
- Select Database/Schema Installation > Database/Schema Installation from the menu bar.
- The CAST Base Installation dialog box will then be displayed:
This dialog box enables you to choose what type of installation operation you want to carry out with CAST Server Manager. Choose the configuration you require and click the Next button An explanation of each option is shown below:
Left column options Right column options What is installed? When should I choose this option? Initial platform base(s) installation Application Analytics platform installation All four CAST AIP schemas are installed automatically with the following suffixes: - Management Service (_MNGT)
- Analysis Service (_LOCAL)
- Dashboard Service (_CENTRAL)
- Measurement Service (_MEASURE)
Choose this option if you are installing CAST AIP from scratch and require access to all functionality (and have appropriate licensing to do so). Note this option is ONLY available if you are using the CAST Storage Service as your chosen storage host. This is because the Measurement Service can only be installed on a CAST Storage Service.
Additional Analysis platform Three CAST AIP schemas are installed automatically with the following suffixes: - Management Service (_MNGT)
- Analysis Service (_LOCAL)
- Dashboard Service (_CENTRAL)
Choose this option if you are not licensed or do not intend to use the CAST Health Dashboard. CAST-MS only Only the Management Service schema is installed. You are free to choose the name of the schema. Choose this option only if you require an additional Management Service, i.e. for situations where you are distributing the CAST AIP schemas across multiple host CAST Storage Services/RDBMS. Additional Knowledge Base Select this option if you want to install a CAST Analysis Service (Knowledge Base) that will be used to store results of a source code analysis.
Additional Central Base
Select this option if you want to install a Dashboard Service (Central) for your CAST Engineering Dashboard.
Additional Measurement Base
Select this option if you want to install a Measurement Service for your CAST Health Dashboard.
N/A One additional CAST AIP schema is installed: the type depends on the option you have selected. Choose these options only if you require additional Analysis, Dashboard or Measurement Services, i.e. for situations where you are distributing the CAST AIP schemas across multiple host CAST Storage Services/RDBMS, or where you are migrating from a previous version that did not include the specific schema. Note that the Additional Analysis platform option is ONLY available if you are using the CAST Storage Service as your chosen storage host. This is because the Measurement Service can only be installed on a CAST Storage Service.
- The CAST Schema/Database Creation dialog box will then be displayed. This will differ according to the selections made above:
Displayed for: - all ADDITIONAL options - Initial platform base(s) installation > CAST-MS only
Displayed ONLY for: - Initial platform base(s) installation > Application Analytics platform installation
- Initial platform base(s) installation > Additional Analysis platform
This dialog box enables you to choose how you want to install the items:
New Schema/Database User (schema) Name / Schema Name / Database Name Enter the name you want to give the schema/database (for Oracle, this is the schema user name). If you choose a name that already exists in the system catalog on the target server, then Server Manager will prompt you.
Notes
- For all server types please note the following CAST requirements:
- The name must be in upper case - the following characters are authorized: 0-9, A-Z and _ (underscore)
- The name must NOT start with a number - RDBMS specific naming rules also apply - please see the on-line Help for your specific RDBMS for more information.
User Password (Oracle only) Enter a password for the user associated to the schema you want to create. Make sure you remember this as it may be required to carry out other operations.
Existing Schema/Database User (schema) Name / Schema Name / Database Name Enter the name of an existing schema/database (for Oracle, this is the schema user name). Alternatively, use the Browse button to view a list of schemas/databases that already exist on the server.
Notes
- This option will not be available when using the following options (new schemas/databases must be created):
- Initial platform base(s) installation > Application Analytics platform installation
- Initial platform base(s) installation > Additional Analysis platform
This dialog box will be displayed when you click the Browse button in the CAST Schema/Database Creation dialog box. It lists all existing databases/schemas on the server you are connected to. Select the database/schema you want to use for the installation operation and click OK.
Options
- Limit display to 20 rows > displays the first 20 database/schemas
- Name like > enter a search to help narrow down the number of returned databases/schemas - clicking Reload will apply the filter to the list.
Prefix for new Schema/Database Prefix Enter a prefix that will be used to define the names of the new databases/schemas for the CAST AIP databases/schemas. For example, choosing TEST will result in an installation as follows:
- TEST_MNGT
- TEST_LOCAL
- TEST_CENTRAL
- TEST_MEASURE
Notes
- For all server types please note the following CAST requirements:
- The name must be in upper case - the following characters are authorized: 0-9, A-Z and _ (underscore) - RDBMS specific naming rules also apply - please see the on-line Help for your specific RDBMS for more information.
Password (apply to all) - Oracle only Enter a password for the user associated to the schemas you want to create. Make sure you remember this as it may be required to carry out other operations.
Notes
- During the installation process of the three schemas, CAST Server Manager will prompt you for the password - as such please do not leave the installation unattended.
- For all server types please note the following CAST requirements:
- At this point you will be prompted to enter various configuration options for your new or existing database/schema - this includes the creation of tablespaces (Oracle), log files and other parameters required by CAST.
Please note, however, that if you use the Combined Install options, it is not possible to define separate tablespaces/data spaces for each installed item. Instead, one tablespace/data space will be used for all three CAST AIP schemas. If you require separate tablespace/data space for EACH CAST AIP schema, please install each individually.
Select the most appropriate server environment below:
For the CAST Storage Service, the Database Creation dialog box enables you to choose the Data and Temporary Tablespace for your schemas. You can also, optionally, choose to store Tables and Indexes in separate Tablespace. If you are planning to use user defined tablespace rather than default system tablespaces, this must be created in pgAdmin or by using scripts before using CAST Server Manager. New SchemaOption "Use different data space for Indexes and Tables" NOT selected By default, CAST Server Manager allows you to choose the location for your Data Tablespace and the Temporary Tablespace:
Option "Use different data space for Indexes and Tables" selected If you prefer to store the schema's Tables and Indexes in separate Tablespaces (as oppose to in one general Data Tablespace), you can select the option Use different data space for Indexes and Tables. This will display additional fields entitled Table Tablespace Name and Index Tablespace Name along with the default Temporary Tablespace Name field.
|
For Microsoft SQL-Server, the Database Creation dialog box enables you to define the names and locations of your Primary and Log Files. You can also, optionally, choose to store Tables and Indexes in separate files away from the Primary File. New DatabaseUse different data space for Tables and Indexes not selected. By default, CAST Server Manager will offer to create one Primary File in which to store all objects associated with the new database and one log file for trace requirements.
If you choose to store the database's system Tables and Indexes in separate files away from the Primary File, you can select the option Use different data space for Tables and Indexes. This will display two further fields entitled Filegroup for Table and Filegroup for Index along with the default Primary File and Log File fields. The Primary File and Log File fields are identical to those described above.
Existing DatabaseUse different data space for Tables and Indexes not selected. When you have chosen to carry out the installation procedure in an existing database on the server (this database needs to be manually created on the server prior to using CAST Server Manager), and the Use different data space for Tables and Indexes option is not selected, then there is no possibility to change where the CAST installation components will be stored. Instead, the Database Creation dialog box displays (in read-only) where the components will be installed.
Please note that:
Use different data space for Tables and Indexes selected. When you have chosen to carry out the installation procedure in an existing database on the server (this database needs to be manually created on the server prior to using CAST Server Manager), and the Use different data space for Tables and Indexes option is selected, then CAST Server Manager will give you the opportunity to choose where you want to install the Tables and Indexes Filegroups (these Filegroups need to be manually created on the server prior to using CAST Server Manager). Other items will be installed to the existing PRIMARY Filegroup. Use the drop down list to select a different Filegroup for the Tables and Indexes.
Please note that:
|
For Oracle, the Database Creation dialog box enables you to define the names and locations of your schema's Data and Temporary Tablespace. You can also, optionally, choose to store Tables and Indexes in separate Tablespace. Notes
New SchemaUse different data space for Indexes and Tables not selected. By default, CAST Server Manager allows you to choose the location for your Data Tablespace and the Temporary Tablespace.
Use different data space for Indexes and Tables selected. If you choose to store the schema's Tables and Indexes in separate Tablespaces (as oppose to in one general Data Tablespace), you can select the option Use different data space for Indexes and Tables. This will display additional fields entitled Table Tablespace Name and Index Tablespace Name along with the default Temporary Tablespace Name field.
Existing SchemaUse different data space for Indexes and Tables not selected. When you have chosen to carry out the installation procedure in an existing schema on the server (this schema needs to be manually created on the server prior to using CAST Server Manager), and the Use different data space for Indexes and Tables option is not selected, then there is no possibility to change where the CAST installation components will be stored - they will be stored by default in the existing schema's default data Tablespace and temporary Tablespace. Instead, the Database Creation dialog box displays (in read-only) where the components will be installed.
Please note that:
Use different data space for Indexes and Tables selected. When you have chosen to carry out the installation procedure in an existing schema on the server (this schema needs to be manually created on the server prior to using CAST Server Manager), and the Use different data space for Indexes and Tables option is selected, then CAST Server Manager will give you the opportunity to choose where you want to install the Index Tablespace (this Tablespace needs to be manually created on the server prior to using CAST Server Manager). It will not be possible to choose where to install the Table Tablespace, because CAST Server Manager will detect the default Tablespace of the user you are using to connect to the server with and use this - this will be displayed in read-only mode. Use the drop down list to select a different Tablespace for the Indexes.
Please note that:
|
What happens next?
The database/schema creation and component installation process will then start for all options:
- A dialog box displaying a summary of the proposed installation will then be displayed:
- Click Proceed to start the component installation.
- A dialog box will inform you of installation progress:
- When all previous operations have been successfully completed, the Server Browser will display the installed components next to your new database/schema in the "Installed Product" heading:
Notes
- You can also use the icon located on the toolbar to proceed with the a database/schema installation.
See Also
Privileges | Application Interface