Problem Note 31147: Performance issues might occur with the SAS® OLAP Server in the z/OS environment
A SAS OLAP Server running in the z/OS environment might experience performance issues,
including slow response time to queries. This can happen because the SAS OLAP Server uses a
large number of TK memory pools, which causes excessive CPU usage when these pools are created and deleted.
A hot fix is available that reduces CPU time for the SAS OLAP Server and results in improved response time to OLAP cube queries.
Select the Hot Fix tab in this note to access the hot fix for this issue.
In addition to applying the hot fix, you must set the following new TKMVSENV environment variable
to take advantage of the server improvements:
set TKOPT_KEEPPOOL=
Add this line to the member of your installation data set
high-level-qualifier.encoding.SRVENV that corresponds to your OLAP server. The member name should match the started task name of
your SAS OLAP Server, where high-level-qualifier is the prefix of your SAS installation
data sets and encoding is your encoding (W0 for US, W9 for the UK, W3 for Germany, and so on).
This TK environment variable should be set only for the SAS OLAP Server on z/OS. Setting this
TK environment variable for any other SAS server or spawner could have an adverse effect in
performance for that SAS server or spawner on z/OS.
Refer to Problem Note 31641 for related information about other
TKMVSENV environment variables that should be considered for tuning the server environment.
Operating System and Release Information
| SAS System | Base SAS | z/OS | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Performance issues with SAS OLAP Server found in TKM under z/OS
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2008-04-18 10:33:08 |
| Date Created: | 2008-02-08 12:51:52 |
