Problem Note 58214: The SAS® Shared Services database might grow quickly in an environment with SAS® Grid Manager, Platform Suite for SAS®, and SAS® Environment Manager
In an environment where you run SAS Grid Manager, Platform Suite for SAS, and SAS Environment Manager, the Shared Services database might increase in size very quickly. This increase occurs because Central Authentication Service (CAS) is in use and the SAS Grid Manager Agent plug-in for SAS Environment Manager creates a new ticket-granting ticket (TGT) and service ticket (ST) to communicate with the SAS® 9.4 Platform Web Services.
When you encounter this problem, you might notice slow performance. In certain environments, tens of thousands of rows are added daily to the sas_audit table. If you think you have encountered this issue, run the following command after you connect to the Shared Services database to determine how many rows exist for the account LSF_Admin:
SharedServices=# select user_id, count(*) as count from sas_audit group by user_id order by user_id;
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | Platform Grid Management Service | Solaris for x64 | 9.4 TS1M3 | |
Linux for x64 | 9.4 TS1M3 | |
HP-UX IPF | 9.4 TS1M3 | |
64-bit Enabled Solaris | 9.4 TS1M3 | |
64-bit Enabled AIX | 9.4 TS1M3 | |
Microsoft® Windows® for x64 | 9.4 TS1M3 | |
*
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.
The Shared Services database might increase quickly in an environment that contains SAS Grid Manager, Platform Suite for SAS, and Environment Manager. This increase might be a result of the number of rows that are added for the LSF_Admin account in the sas_audit table.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2016-05-18 08:58:17 |
Date Created: | 2016-05-16 10:43:09 |