Troubleshooting
Problem
Unable to set multiple session parameters via the ALTER_SESSION_PARAMETERS= sections or the Attach= lines in the cogdmor.ini file. Only the first parameter added in each section is getting recognized. For example if the following is used - ; ALTER_SESSION_PARAMETERS=NLS_LANGUAGE=FRENCH NLS_TERRITORY=FRANCE NLS_SORT=BINARY ALTER_SESSION_PARAMETERS=OPTIMIZER_INDEX_CACHING=100 ALTER_SESSION_PARAMETERS=ALWAYS_ANTI_JOIN=NESTED_LOOPS ALTER_SESSION_PARAMETERS=DB_FILE_MULTIBLOCK_READ_COUNT=2 ALTER_SESSION_PARAMETERS=SORT_AREA_SIZE=10000 Only the OPTIMIZER_INDEX_CACHING=100 setting is changed
[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"Impromptu 6.0;Impromptu 7.4;Planning - Contributor 7.3;PowerPlay Transformer 7.3;Upfront 7.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSPN2D","label":"Cognos Planning"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Contributor","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Transformer","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Upfront","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
117011
Was this topic helpful?
Document Information
Modified date:
09 May 2025
UID
swg21337477