Troubleshooting
Problem
When attempting to build large cubes on IBM Cognos Transformer v10.1.1 (RP1) or later on AIX 7.1, the build process stops logging at the 'Sorting the workfile' stage. You may also notice that the Transformer process (cogtr) reaches 2GB in size at that stage and disappears shortly afterward. The same cube may also build succesfully, never reaching 2GB in size, on earlier releases of Transformer and/or AIX.
Cause
As of version 10.1.1 of IBM Cognos, memory allocation settings are no longer required as the product has implemented TCMalloc, a new memory allocator that is installed by default. The presence of the following tuning parameters will cause this issue for IBM Cognos Transformer on AIX 7.1:
MALLOCOPTIONS=multiheap
MALLOCTYPE=buckets
MALLOCMULTIHEAP=heaps:n (where n=2 times the number of CPUs)
Environment
AIX 7.1
IBM Cognos Transformer v10.1.1 (RP1) or later
Diagnosing The Problem
Work with your AIX administrator to determine if these memory allocation parameters are currently enabled on your server.
Resolving The Problem
Only the below AIX tuning parameters should remain when using IBM Cognos Transformer v10.1.1 (RP1) or later:
AIXTHREAD_MINKTHREADS = 32
AIXTHREAD_MNRATIO = 1:1
AIXTHREAD_MUTEX_FAST = ON
AIXTHREAD_SCOPE = S
SPINLOOPTIME = 4000
YIELDLOOPTIME = 20
All memory allocation parameters, such as the ones listed in the Cause section of this article, should be removed.
Related Information
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21633990