SUPPORT / SAMPLES & SAS NOTES
 

Support

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

DetailsHotfixAboutRate It

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

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemPlatform Grid Management ServiceSolaris for x649.4 TS1M3
Linux for x649.4 TS1M3
HP-UX IPF9.4 TS1M3
64-bit Enabled Solaris9.4 TS1M3
64-bit Enabled AIX9.4 TS1M3
Microsoft® Windows® for x649.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.