Information Store database properties
The Information Store database properties files specify the names and details of database objects that are using in the Information Store. There is a separate file for IBM® Db2® and Microsoft™ SQL Server.
The InfoStoreNamesDb2.properties and InfoStoreNamesSQLServer.properties files are in the toolkit\configuration\fragments\opal-services-is\WEB-INF\classes directory.
- 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
Settings for Db2 and SQL Server
The InfoStoreNamesDb2.properties and InfoStoreNamesSQLServer.properties files contain the following settings:MetadataSchemaThe metadata schema contains objects that relate to the definitions of data structures in the Information Store.
By default, the value is
IS_MetaDataSchemaThe data schema contains objects that store all the data that is available for analysis.
By default, the value is
IS_DataWebChartSchemaThe web chart schema contains temporary objects used during manipulation of the web chart.
By default, the value is IS_WC
VisualQuerySchemaThe visual query schema contains temporary objects used during visual query processing.
By default, the value is
IS_VqFindPathSchemaThe find path schema contains objects that support find path results.
By default, the value is
IS_FPStagingSchemaThe staging schema contains temporary objects that support the ingestion process.
By default, the value is
IS_StagingPublicSchemaThe 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_PublicDeletionByRuleRoleNameThe deletion-by-rule role name.
By default, the value is
Deletion_By_RuleCollationThe collation sequence used for the Information Store. You can only change this setting before you create the Information Store database. Defaults to
CLDR181_LEN_S1for Db2 andLatin1_General_100_CI_AI_SCfor SQL Server.
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:
SystemTempTableSpaceThe system temporary table space.
By default, the value is
IS_TEMP_TSUserTemp16KTableSpaceThe user temporary 16K table space to hold global temporary objects.
By default, the value is
IS_16K_TSBigTableSpaceThe partitioned table spaces to hold data objects and indexes.
By default, the value is
IS_BIG_TSBigIndexTableSpaceBy default, the value is
IS_BIG_INDEX_TSSmallTableSpaceThe non-partitioned table spaces to hold data objects and indexes.
By default, the value is
IS_SMALL_TSSmallIndexTableSpaceBy default, the value is
IS_SMALL_INDEX_TSLobTableSpace-
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 IngestionTempTableSpaceThe temporary table space to hold global temporary objects during ingestion.
By default, the value is
IS_16K_TSPageSizeThe page size.
By default, the value is
16KBufferPool16KThe 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.
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.ISSchemaThe Information Store schema contains internal configuration information about the Information Store database.
By default, the value is
IS_CorePrimaryNameThe 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_DataPrimaryFilenameThe filename or absolute path for the primary data file.
By default, the value is
IStore-p1.mdfUserTableNameThe 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_DataUserTableFilenameThe filename or absolute path for the user table file.
By default, the value is
IStore-ut1.ndfIndexNameThe index filegroup contains the indexes for the Information Store database. The logical name of the index file.
By default, the value is
IStore_IndexesIndexFilenameThe filename or absolute path for the index file.
By default, the value is
IStore-i1.ndfLobName-
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 MemoryOptimizedNameThe 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_OptimizedMemoryOptimizedFilenameThe filename or absolute path for the memory-optimized file.
By default, the value is
IStore-mo1.ndfSqlLogName1The transaction log files used for the Information Store. The logical name of the first SQL log.
By default, the value is
IStore_Logs_1SqlLogFilename1The filename or absolute path for the first SQL log file.
By default, the value is
IStore-log1.ldfSqlLogName2The logical name of the second SQL log.
By default, the value is
IStore_Logs_2SqlLogFilename2The filename or absolute path for the second SQL log file.
By default, the value is
IStore-log2.ldfDDLBatchSizeThe number of DDL statements in each batch.
By default, the value is
5DMLBatchSizeThe number of DML statements in each batch.
By default, the value is
1000