Create TIBCO ActiveMatrix Administrator Server

The Create TIBCO ActiveMatrix Administrator Server wizard is used to configure many aspects of your server including the database, authentication method, monitoring, log service, and more.

Database Requirements

You can review this wizard documentation before you start the configuration, to decide how you want to set up the server.

Note: The wizard takes 15 minutes or more to complete depending on the configuration options.
When you run the wizard, specify a database for Administrator server and for several system services. If you are using an external database (and do not use HSQLDB as an external database), set up the external database before you run the wizard.
  1. Package, install, and configure the database driver using the Configure Third-Party Driver wizard.
  2. Configure the external database.
    Privileges Granted Based on the Database Type
    Database Type Configuration Notes
    Oracle Required : You must not have the DBA privilege, and you must be assigned to the database schema.

    Permissions: Grant the following permissions:

    grant create session

    Microsoft SQL Server
    Required: Set 'read_committed_snapshot' to ON by executing:
    1. alter database <amx-database> set read_committed_snapshot on
    2. Use the case insensitive collation setting for <amx-database>
    3. Assign <amx-user> the default database <amx-database>

    Permissions: grant db_datareader, db_datawriter to <amx-user> for the <amx-database>.

    IBM DB2

    Required: Configure the database with a 32KB page size (instead of the default 4KB page size).

    Permissions: Create dmluser with connect database permission.

    PostgreSQL (Starting with TIBCO ActiveMatrix Hotfix 002)
    1. Create the database user using pgAdmin or SQL Shell and grant required privilege.
    2. Create the database. The user created in the step a must be the owner of the database.
    3. In pgAdmin or SQL shell, run the following queries for the database created in the step b : 
      CREATE FUNCTION pg_catalog.text(bigint) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int8out($1));';
CREATE CAST (bigint AS text) WITH FUNCTION pg_catalog.text(bigint) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int4out($1));';
CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer) AS IMPLICIT;

CREATE FUNCTION pg_catalog.text(smallint) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int2out($1));';
CREATE CAST (smallint AS text) WITH FUNCTION pg_catalog.text(smallint) AS IMPLICIT;
  3. Start the database server.
Note: If you use an HSQLDB external database, concurrent user access to the Administrator server is not supported.

Database Requirements For DDL Generator Users

ActiveMatrix supports a DDL generator utility that you can use before you run TIBCO Configuration Tool. When you use DDL scripts produced by the DDL generator, you need different database permissions than if you do not use DDL scripts. The database user must have connect and resource privileges, and must not have DBA privileges. The database user must be assigned to the default schema.

Components Configured by the Create TIBCO ActiveMatrix Administrator Server Wizard

The following table summarizes the components that are configured in the Create TIBCO ActiveMatrix Administrator Server wizard, their function, and the decisions you must take, the information you must gather, and actions you must perform before running the wizard.

Component Function Options and Actions
Administrator Server Administers TIBCO ActiveMatrix applications and infrastructure. Provide the name of the communication group within which status messages are exchanged and the name of the Administrator server. Provide communication properties for the Administrator server.
TIBCO Host Instance The TIBCO Host instance that manages the SystemNode node on which the Administrator server runs. Provide configuration details for the TIBCO Host instance.
Development Node A node on which to deploy applications. Provide the name and management port of the development node and the name of the environment that contains the node. If you intend to complete the tutorials in Administration Tutorials, you must create the development node, accept the default values for the environment and node names, and deploy all product applications on the development node. Customize the name and management port of the node and the name of the environment that contains the node.
Notification and Messaging Bus Server Propagates status messages between hosts, nodes, and the ActiveMatrix Administrator server and messages between applications. Provide configuration details for the Enterprise Message Service server.
Database Stores ActiveMatrix Administrator configuration data. Choose an internal or external database. If you choose an external database, provide configuration details for the database server.
Authentication Realm Stores user and group data. Choose a database or LDAP authentication realm. Provide configuration details for the authentication realm.
  • A database authentication realm stores user and group authentication data in a database. Users and groups in this realm can be edited within ActiveMatrix Administrator. You have the option to use the same database for authentication and administration data.

    If you choose database, and are using a database different than the one the ActiveMatrix Administrator server uses, provide the configuration details for the database server. See Database Requirements.

  • An LDAP authentication realm uses the user and group authentication data stored in an LDAP server. Users and groups in this realm can only be edited with LDAP server management tools.

    If you choose an LDAP realm, the LDAP server must be running.

TIBCO Credential Server Provides credentials to enable secure interactions between ActiveMatrix Administrator servers, hosts, and nodes. Choose an autogenerated or external keystore. If you choose an external keystore, provide configuration details for the keystore.
Logging Notification Server A log service is a TIBCO ActiveMatrix application that offers logging services.

Choose the ActiveMatrix Administrator notification server or another notification server. If the latter, provide the notification server.

Log Service Aggregates and stores log entry data. Choose the ActiveMatrix Administrator database or another database. If you are using a database different than the one the ActiveMatrix Administrator server uses, see Database Requirements.
Payload Service Stores large payloads associated with log entries. Choose the ActiveMatrix Administrator database or another database. If you do not use the ActiveMatrix Administrator database, see Database Requirements.
Field Description
Configure to Secure All Communication with SSL Check to secure all communication channels with SSL. When you select this checkbox, the Enable SSL checkbox on the Notification and Messaging Bus Server and ActiveMatrix Administrator server screens are selected. See Secure Communication Channels for background information.

Default: Cleared.