A slow response might occur when you connect to an application server such as SAS Workspace Server or SAS^® Stored Process Server from a client application such as SAS^® Enterprise Guide^®. The slow response occurs when you have a large number of pre-assigned RDBMS or SAS^® Scalable Performance Data Server^® libraries associated with an application server and you have a large number of logins defined in your SAS^® Metadata Repository.

The problem is that the server initialization code that pre-assigns the libraries must retrieve the login credentials for each library from the SAS Metadata Repository. Instead of requesting only the logins associated with the current user, the process retrieves the entire list of logins for the authentication domain that is associated with the library. To assign the library, the process must then evaluate the metadata authorizations for every login that is returned to determine which logins can be used by the current user. This process repeats for each pre-assigned library.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS Metadata Server	z/OS	9.2 TS2M2	9.3 TS1M0
		Microsoft® Windows® for 64-Bit Itanium-based Systems	9.2 TS2M2	9.3 TS1M0
		Microsoft Windows Server 2003 Datacenter 64-bit Edition	9.2 TS2M2	9.3 TS1M0
		Microsoft Windows Server 2003 Enterprise 64-bit Edition	9.2 TS2M2	9.3 TS1M0
		Microsoft Windows XP 64-bit Edition	9.2 TS2M2	9.3 TS1M0
		Microsoft® Windows® for x64	9.2 TS2M2	9.3 TS1M0
		Microsoft Windows Server 2003 Datacenter Edition	9.2 TS2M2	9.3 TS1M0
		Microsoft Windows Server 2003 Enterprise Edition	9.2 TS2M2	9.3 TS1M0
		Microsoft Windows Server 2003 Standard Edition	9.2 TS2M2	9.3 TS1M0
		Microsoft Windows Server 2003 for x64	9.2 TS2M2	9.3 TS1M0
		Microsoft Windows Server 2008	9.2 TS2M2	9.3 TS1M0
		Microsoft Windows Server 2008 for x64	9.2 TS2M2	9.3 TS1M0
		Microsoft Windows XP Professional	9.2 TS2M2	9.3 TS1M0
		Windows 7 Enterprise 32 bit	9.2 TS2M2	9.3 TS1M0
		Windows 7 Enterprise x64	9.2 TS2M2	9.3 TS1M0
		Windows 7 Home Premium 32 bit	9.2 TS2M2	9.3 TS1M0
		Windows 7 Home Premium x64	9.2 TS2M2	9.3 TS1M0
		Windows 7 Professional 32 bit	9.2 TS2M2	9.3 TS1M0
		Windows 7 Professional x64	9.2 TS2M2	9.3 TS1M0
		Windows 7 Ultimate 32 bit	9.2 TS2M2	9.3 TS1M0
		Windows 7 Ultimate x64	9.2 TS2M2	9.3 TS1M0
		Windows Vista	9.2 TS2M2	9.3 TS1M0
		Windows Vista for x64	9.2 TS2M2	9.3 TS1M0
		64-bit Enabled AIX	9.2 TS2M2	9.3 TS1M0
		64-bit Enabled HP-UX	9.2 TS2M2	9.3 TS1M0
		64-bit Enabled Solaris	9.2 TS2M2	9.3 TS1M0
		HP-UX IPF	9.2 TS2M2	9.3 TS1M0
		Linux	9.2 TS2M2	9.3 TS1M0
		Linux for x64	9.2 TS2M2	9.3 TS1M0
		Solaris for x64	9.2 TS2M2	9.3 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.

---

A fix for this issue for Base SAS 9.21_M1 is available at:

http://ftp.sas.com/techsup/download/hotfix/HF2/A50.html#40125

---

A fix for this issue for Base SAS 9.21_M3 is available at:

http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#40125

---

Connecting to an application server, such as a SAS Workspace or a new SAS® Stored Process instance might take an unreasonable length of time due to inefficient queries that are submitted to the SAS® Metadata Server.

Type:	Problem Note
Priority:	high
Topic:	Data Management ==> Data Sources ==> Metadata Data Management ==> Data Sources ==> Relational & Object Relational DBMS (Database Management System) Data Management ==> Access ==> Client/Server System Administration ==> Performance ==> SAS System Administration ==> Servers ==> Integration Technologies System Administration ==> Servers ==> Metadata

Date Modified:	2010-08-19 14:15:29
Date Created:	2010-06-25 16:18:08