Databases

The <databases> element defines the database that i2 Analyze uses to store data. The <database> element contains attributes that define information about the database, and the mechanism that is used to connect to it.

For example:

<database database-type="InfoStore" 
dialect="db2" database-name="ISTORE" instance-name="DB2" 
xa="false" host-name="<host>" id="infostore" 
port-number="50000" />

Where:

Attribute

Description

database-type

The value must be InfoStore in this version of i2 Analyze.

dialect

Specifies the type of database engine. This attribute can be set to one of postgres, db2, or sqlserver.

database-name

A name that identifies the database to the database engine.

instance-name

The instance name that was specified during installation of your database engine. If you are using SQL Server, you can either specify the port-number or instance-name attribute. For SQL Server on Linux, you must use the port-number attribute. This attribute is not applicable to PostgreSQL databases.

xa

Determines whether distributed transactions are enabled for this database.

host-name

The hostname of the server where the database is located.

id

A unique identifier that is used to distinguish this database throughout the system. The value must match the id in the <i2-data-source> element.

port-number

The port on the database server to send requests to. If you are using SQL Server, you can either specify the port-number or instance-name attribute.

Remote database attributes

If your database is on a remote server from the i2 Analyze application, you must use the following attributes in the topology.xml file:

Attribute

Description

os-type

Identifies the operating system of the server where the database is located. This attribute can be set to one of WIN or UNIX. If you are using Db2, you can also specify AIX.

node-name

Identifies the node to create in the Db2 node directory. The value of the node-name attribute must start with a letter, and have fewer than 8 characters. For more information about naming in Db2, see Naming conventions. This attribute is not applicable to PostgreSQL or SQL Server databases.

For example, if you are using PostgreSQL:

<database database-type="InfoStore" dialect="postgres"
    database-name="ISTORE" xa="false" id="infostore"
    host-name="<remote.hostname>" port-number="5432" os-type="WIN" />

For example, if you are using IBM Db2:

<database database-type="InfoStore" dialect="db2" instance-name="DB2"
    database-name="ISTORE" xa="false" id="infostore"
    host-name="<remote.hostname>" port-number="50000"
    node-name="node1" os-type="WIN" />

For example, if you are using Microsoft SQL Server:

<database database-type="InfoStore" dialect="sqlserver" instance-name="SQLSERVER"
    database-name="ISTORE" xa="false" id="infostore"
    host-name="<remote.hostname>" os-type="WIN" />