IBM Support

TM1 server performance improvements for AIX - 10.2 RP2 FP1

Product Documentation


Abstract

A number of performance improvements have been implemented on AIX for 10.2 RP2 FP1. The improvements were achieved by revising the AIX tuning recommendations and product enhancements. Depending on the application and usage, tests have shown these changes result in a 5-25% improvement over previous versions of TM1.

Content

Revised AIX tuning recommendations
These environment settings are appropriate for all TM1 releases on AIX as of September, 2014.

export AIXTHREAD_SCOPE=S
export AIXTHREAD_MNRATIO=1:1
export MALLOCOPTIONS=multiheap:32,pool:0x20000000
export SPINLOOPTIME=300
export AIXTHREAD_MUTEX_FAST=ON
export LDR_CNTRL=DATAPSIZE=16M@TEXTPSIZE=16M@STACKPSIZE=16M
export AIXTHREAD_AFFINITY=first-touch
export MEMORY_AFFINITY=MCM
export OBJECT_MODE=64
export YIELDLOOPTIME=0

In addition to setting the environment variables, the Virtual Memory Manager (VMM) must be tuned for the size and number of large pages to reserve. Only root users or users that have privileges granted can adjust the VMM.

Please consult the AIX documentation for the complete set of vmo options used to tune VMM parameters.

Note: Enabling Large Pages will increase the TM1 Server memory by 10-15%.

The following command will enable large pages with the recommended settings for the TM1 Server:
vmo -o lgpg_regions=2000 -o lgpg_size=16777216

To grant privileges to non-root users, use the following command:
chuser capabilities=CAP_BYPASS.RAC_VMM,CAP_PROPAGATE userid

To verify that the TM1 Server is running with large pages enabled, run the following command:
ps -Zdef | grep tm1

Enabling object alignment for the Power Platform
A new tm1s.cfg file option has been provided for 10.2 RP2 FP1. This option allows for memory alignment that is specific to the Power platform. Testing has shown that enabling this option will provide the most benefit for high user count usage scenarios. Single or low user count usage scenarios may see little to no benefit. By default, the option is disabled.

To enable the option, add the following line to your tm1s.cfg file:

CacheFriendlyMalloc=T

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Web","Platform":[{"code":"PF002","label":"AIX"}],"Version":"10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27043554