Information Store database properties

The Information Store database properties files specify the names and details of database objects that are used in the Information Store. There are separate files for IBM® Db2®, Microsoft™ SQL Server, and PostgreSQL.

The InfoStoreNamesDb2.properties, InfoStoreNamesSQLServer.properties, and InfoStoreNamesPostgres.properties files are in the toolkit\configuration\fragments\opal-services-is\WEB-INF\classes directory.

The settings in these files control the following database objects:
  • The names of the database schemas
  • The name of the deletion by rule role
  • The collation sequence
  • For Db2, the page size
  • For Db2, the names of the buffer pools
  • For SQL Server, the logical names and locations of the filegroup files
Note: If you change the values for any of the settings after the Information Store is created, you must either manually change the names of the database objects in your database management system or re-create the database.

Settings for Db2, SQL Server, and PostgreSQL

The InfoStoreNamesDb2.properties, InfoStoreNamesSQLServer.properties, and InfoStoreNamesPostgres.properties files contain the following settings:

MetadataSchema

The metadata schema contains objects that relate to the definitions of data structures in the Information Store.

By default, the value is IS_Meta

DataSchema

The data schema contains objects that store all the data that is available for analysis.

By default, the value is IS_Data

WebChartSchema

The web chart schema contains temporary objects used during manipulation of the web chart.

By default, the value is IS_WC

VisualQuerySchema

The visual query schema contains temporary objects used during visual query processing.

By default, the value is IS_Vq

FindPathSchema

The find path schema contains objects that support find path results.

By default, the value is IS_FP

StagingSchema

The staging schema contains temporary objects that support the ingestion process.

By default, the value is IS_Staging

PublicSchema

The public schema contains objects that represent a public API for the Information Store. It also contains procedures, tables, and views related to the deletion by rule feature.

By default, the value is IS_Public

DeletionByRuleRoleName

The deletion-by-rule role name.

By default, the value is Deletion_By_Rule

Collation

The collation sequence used for the Information Store. You can only change this setting before you create the Information Store database. Defaults to CLDR181_LEN_S1 for Db2 and Latin1_General_100_CI_AI_SC for SQL Server.

Note: For PostgreSQL, collation works a little differently and there are three settings instead of one. For more information, see the section at the bottom of this topic.

Settings for Db2

The InfoStoreNamesDb2.properties file contains the following settings that are specific to deployments that use IBM Db2 to host the Information Store database:

SystemTempTableSpace

The system temporary table space.

By default, the value is IS_TEMP_TS

UserTemp16KTableSpace

The user temporary 16K table space to hold global temporary objects.

By default, the value is IS_16K_TS

BigTableSpace

The partitioned table spaces to hold data objects and indexes.

By default, the value is IS_BIG_TS

BigIndexTableSpace

By default, the value is IS_BIG_INDEX_TS

SmallTableSpace

The non-partitioned table spaces to hold data objects and indexes.

By default, the value is IS_SMALL_TS

SmallIndexTableSpace

By default, the value is IS_SMALL_INDEX_TS

LobTableSpace

The table spaces to hold LOB data objects and indexes.

By default, the value is IS_LOB_TS

LobIndexTableSpace

By default, the value is IS_LOB_INDEX_TS

IngestionTempTableSpace

The temporary table space to hold global temporary objects during ingestion.

By default, the value is IS_16K_TS

PageSize

The page size.

By default, the value is 16K

BufferPool16K

The 16K buffer pool.

By default, the value is IS_16K_BP

Settings for SQL Server

The InfoStoreNamesSQLServer.properties file contains the following settings that are specific to deployments that use Microsoft SQL Server to host the Information Store database.

For the Filename settings, you must specify a file name or absolute path. If you specify a file name, it is located relative to the value that is specified in the environment.properties file for the db.database.location.dir property. If you specify a file path, it is considered an absolute path.

ISSchema

The Information Store schema contains internal configuration information about the Information Store database.

By default, the value is IS_Core

PrimaryName

The SQL Server database primary data file contains the startup and configuration information for the Information Store database. The logical name of the primary data file.

By default, the value is IStore_System_Data

PrimaryFilename

The filename or absolute path for the primary data file.

By default, the value is IStore-p1.mdf

UserTableName

The user table filegroup contains all the tables and data for the Information Store database. The logical name of the user table in the user table filegroup.

By default, the value is User_Table_Data

UserTableFilename

The filename or absolute path for the user table file.

By default, the value is IStore-ut1.ndf

IndexName

The index filegroup contains the indexes for the Information Store database. The logical name of the index file.

By default, the value is IStore_Indexes

IndexFilename

The filename or absolute path for the index file.

By default, the value is IStore-i1.ndf

LobName

The LOB filegroup contains the tables that Store LOB data. The logical name of the lob file.

By default, the value is IStore_Lobs

LobFilename

The filename or absolute path for the index file.

By default, the value is IStore-b1.ndf

MemoryOptimizedName

The memory-optimized filegroup holds one or more containers that contain data files, delta files, or both for memory-optimized tables. The logical name of the memory-optimized file.

By default, the value is IStore_Memory_Optimized

MemoryOptimizedFilename

The filename or absolute path for the memory-optimized file.

By default, the value is IStore-mo1.ndf

SqlLogName1

The transaction log files used for the Information Store. The logical name of the first SQL log.

By default, the value is IStore_Logs_1

SqlLogFilename1

The filename or absolute path for the first SQL log file.

By default, the value is IStore-log1.ldf

SqlLogName2

The logical name of the second SQL log.

By default, the value is IStore_Logs_2

SqlLogFilename2

The filename or absolute path for the second SQL log file.

By default, the value is IStore-log2.ldf

DDLBatchSize

The number of DDL statements in each batch.

By default, the value is 5

DMLBatchSize

The number of DML statements in each batch.

By default, the value is 1000

Settings for PostgreSQL

The InfoStoreNamesPostgres.properties file contains the following settings that are specific to deployments that use PostgreSQL to host the Information Store database.

ISSchema

The Information Store schema contains internal configuration information about the Information Store database.

By default, the value is IS_Core

Collation_Deterministic, Collation_Locale

The (ICU) collation used for the Information Store in PostgreSQL. You can only change these settings before you create the Information Store database.

If Collation_Deterministic is true, all operators are case- and accent-sensitive.

If Collation_Deterministic is false:

  • "exact" operators follow the rules of the Collation_Locale
  • the "like" operator is governed by Collation_Sensitivity

By default, the values are false and en-US-u-ks-level1 (US English, case- and accent-insensitive).

Collation_Sensitivity

The case- and accent-sensitivity of the "like" operator when Collation_Deterministic is false. The value must be one of CIAI, CIAS, CSAI, or CSAS.

By default, the value is CIAI (case- and accent-insensitive).

CollateClause

The collation used throughout columns in the Information Store in PostgreSQL. This setting is required for correct sorting of text-based columns when using non-deterministic collation. If you plan to use deterministic collation (such as case-sensitive collation), set this property to be empty.

By default, the value is COLLATE public.istore_collation.

DatabaseTablespace

The default tablespace for the Information Store database. This tablespace, like all the others, must be present in the PostgreSQL cluster before the database is created.

By default, the value is pg_default.

BigDataTablespace

The tablespace for big data tables.

By default, the value is pg_default.

BigIndexTablespace

The tablespace for indexes on big data tables.

By default, the value is pg_default.

SmallDataTablespace

The tablespace for small data tables.

By default, the value is pg_default.

SmallIndexTablespace

The tablespace for indexes on small data tables.

By default, the value is pg_default.

After you update the database properties, you can either modify other aspects of the deployment toolkit or deploy the system to update the deployment with any changes.