Recommended Configuration Settings for Usage Tracking using SQL Server

Use these configuration settings to optimize usage tracking using a SQL Server database for RCU.

Configuration Settings to optimize usage tracking using SQL Server

Where? Configuration Settings More Information

Where?	Configuration Settings	More Information
`odbc.ini`	In the section for SQL Server [sql_server_db], add the following two settings: `EnableQuotedIdentifiers=1` `WorkArounds2=2`	After setting these parameters, stop and start managed BI Server nodes (for example, to stop and start OBIS1, issue stop.sh -i obis1, and start.sh -i obis1).
`NQSConfig.ini`	Add the following parameters using these examples substituted with your own connection pool name and SQL Server database name. `PHYSICAL_TABLE_NAME="U_T"."OAS_UT_DB"."DEV_BIPLATFORM"."S_NQ_DB_ACCT" ; CONNECTION_POOL="U_T"."U_T" ; PHYSICAL_QUERY_TABLE_NAME="U_T"."OAS_UT_DB"."DEV_BIPLATFORM"."S_NQ_ACCT" ; INIT_BLOCK_TABLE_NAME="U_T"."OAS_UT_DB"."DEV_BIPLATFORM"."S_NQ_INITBLOCK" ; INIT_BLOCK_CONNECTION_POOL="U_T"."U_T" ;`	After setting these parameters, stop and start managed BI Server nodes (for example, to stop and start OBIS1, issue stop.sh -i obis1, and start.sh -i obis1).
In the Console	Set the following parameters using these examples substituted with your own connection pool name and SQL Server database name. `Usage Tracking Connection Pool = U_T.U_T Usage Tracking Initialization Block Table = U_T.OAS_UT_DB.DEV_BIPLATFORM.S_NQ_INITBLOCK Usage Tracking Physical Query Logging Table = U_T.OAS_UT_DB.DEV_BIPLATFORM.S_NQ_DB_ACCT Usage Tracking Logical Query Logging Table = U_T.OAS_UT_DB.DEV_BIPLATFORM.S_NQ_ACCT`	After setting these parameters, restart the whole OBI stack.

odbc.ini

In the section for SQL Server [sql_server_db], add the following two settings:

EnableQuotedIdentifiers=1
WorkArounds2=2

After setting these parameters, stop and start managed BI Server nodes (for example, to stop and start OBIS1, issue stop.sh -i obis1, and start.sh -i obis1).

NQSConfig.ini

Add the following parameters using these examples substituted with your own connection pool name and SQL Server database name.

PHYSICAL_TABLE_NAME="U_T"."OAS_UT_DB"."DEV_BIPLATFORM"."S_NQ_DB_ACCT" ; CONNECTION_POOL="U_T"."U_T" ; PHYSICAL_QUERY_TABLE_NAME="U_T"."OAS_UT_DB"."DEV_BIPLATFORM"."S_NQ_ACCT" ; INIT_BLOCK_TABLE_NAME="U_T"."OAS_UT_DB"."DEV_BIPLATFORM"."S_NQ_INITBLOCK" ; INIT_BLOCK_CONNECTION_POOL="U_T"."U_T" ;

After setting these parameters, stop and start managed BI Server nodes (for example, to stop and start OBIS1, issue stop.sh -i obis1, and start.sh -i obis1).

In the Console

Set the following parameters using these examples substituted with your own connection pool name and SQL Server database name.

Usage Tracking Connection Pool = U_T.U_T Usage Tracking Initialization Block Table = U_T.OAS_UT_DB.DEV_BIPLATFORM.S_NQ_INITBLOCK Usage Tracking Physical Query Logging Table = U_T.OAS_UT_DB.DEV_BIPLATFORM.S_NQ_DB_ACCT Usage Tracking Logical Query Logging Table = U_T.OAS_UT_DB.DEV_BIPLATFORM.S_NQ_ACCT

After setting these parameters, restart the whole OBI stack.