BMC Digital Workplace Catalog Server performance configuration settings

This topic contains the following information:

BMC Digital Workplace Catalog Server configuration settings

The following tables describe the BMC Digital Workplace Catalog server configuration settings:

BMC Digital Workplace Catalog server configuration settings (ar.conf)

Parameter and value	Comments
Max-Entries-Per-Query: 2,000	None
Allow-Unqual-Queries: T	None
Cache-Mode: 0	Disable development cache mode
CMDB-Service-Suspended: T	None
Full-Text-Mode: PRIMARY	None
Max-Database-Connections: 400	Default
DB-Case-Insensitive : T	Parameter is set when we have DWP Catalog Tenant is created on Oracle. Refer section - DB-Case-Insensitive Parameter

BMC Digital Workplace Catalog server thread settings (ar.conf)

Parameter and value	Number of threads (port number minimum/maximum)	Comments
Private-RPC-Socket: 390601	1/1	Alert queue
Private-RPC-Socket: 390603	3/6	Escalation queue
Private-RPC-Socket: 390620	8/8	Fast queue
Private-RPC-Socket: 390635	8/8	List queue
Private-RPC-Socket: 390680	2/2	Approval queue

Jetty Server Configuration (jetty.xml)

Parameter	Value	Comments
maxThreads	200	Maximum Threads
minThreads	10	Minimum Threads

BMC Digital Workplace Catalog Server Java virtual machine (JVM) settings

The following table contains JVM settings for the BMC Digital Workplace Catalog server:

JVM Settings (arserverd.conf)

Paramters	Value	Comments
jvm.minimum.heap.size	6442450944	JVM minimum heap size
jvm.maximum.heap.size	6442450944	JVM maximum heap size

JVM options
-XX:+UseCompressedOops
-XX:+UseConcMarkSweepGC
-XX:+UseParNewGC
-XX:MaxMetaspaceSize=512M
-XX:NewRatio=2
-XX:+IgnoreUnrecognizedVMOptions

For more information, see the BMC Communities article, Tuning JVM Settings.

Jetty maxThreads and Max-Database-Connections Configuration

Below are the recommendations for Jetty maxThreads and Max-Database-Connections:

Recommended value of Jetty maxthreads and Max-Database-Connections is 200 Jetty 'maxThreads' and 400 'Max-Database-Connections' as default.
If any custom API’s are spawning 2 to 3 database connections per API that can be monitored, use netstat and tune the Max-Database-Connections parameter value accordingly.
Keep the Jetty maxThreads value in the 200 to 500 range. Start with the default of 200 and, if required, increase to higher limits gradually by monitoring the application, but do not exceed 500. Unnecessarily setting the jetty maxThreads to an upper limit can lead to performance issues.

DB-Case-Insensitive Parameter

If Oracle database is created with Case Sensitive, value of parameter DB-Case-Insensitive should be set to F in ar.conf. With that server will set NLS_COMP and NLS_SORT as follows in sql session. Having these values to BINARY, searching will be faster with default indexes.

ALTER SESSION SET NLS_COMP=BINARY

ALTER SESSION SET NLS_SORT=BINARY

If Oracle database is created with Case Insensitive, value of parameter DB-Case-Insensitive should be set to T in ar.conf. With that server will set NLS_COMP and NLS_SORT as follows in sql session. But with that, linguistic indexes needs to be manually created else there would performance impact.

ALTER SESSION SET NLS_COMP=LINGUISTIC

ALTER SESSION SET NLS_SORT=BINARY_CI

For Example :

Re-Create Index on Columns C56311 and C56314 on table T214 - ACT_HI_ACTINST

CREATE INDEX CALBROADMIN."I214_56311_563141_Sort" ON CALBROADMIN.T214 (NLSSORT("C56311",'nls_sort=''BINARY_CI''') ASC, NLSSORT("C56314",'nls_sort=''BINARY_CI''') ASC)

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "CALBRO" ;

Re-Create Index on Column C56311 on table T219 - ACT_HI_PROCINST

CREATE INDEX CALBROADMIN."I219_56311_1_Sort" ON CALBROADMIN.T219 (NLSSORT("C56311",'nls_sort=''BINARY_CI'''))