SAS Master Data Management batch and real-time updates invoke a database process to analyze SAS Master Data Management database indices. These index analyses should take place only after batch job updates. They should not take place on single-record updates that use mrm_add_[entity type] data services, because this process can slow down performance, particularly on larger data volumes.

Patches are available for these issues. Important: Back up the SAS Master Data Management database before applying these fixes.

Patch 20417 and Patch 20418 deliver updated database schema creation scripts for both SQL Server and Oracle that limits index analysis to batch processing only. These scripts need to be run manually by a database administrator using the account created for SAS Master Data Management. By default, the user account/schema is named “mdm41” for both SQL Server and Oracle.

SAS Master Data Management patches are located here.

• Patch 20417 fixes the issue on SAS^® Data Management Studio.
• Patch 20418 fixes the issue on SAS^® Data Management Server.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
Dataflux	DataFlux Data Management Server	Solaris for x64	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Linux for x64	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		HP-UX IPF	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		64-bit Enabled Solaris	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		64-bit Enabled AIX	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Windows 7 Professional x64	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Windows 7 Enterprise x64	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft Windows Server 2012 Std	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft Windows Server 2012 R2 Std	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft Windows Server 2012 R2 Datacenter	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft Windows Server 2012 Datacenter	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft Windows Server 2008 for x64	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft Windows Server 2008 R2	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft Windows 8.1 Pro 32-bit	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft Windows 8.1 Pro	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft Windows 8.1 Enterprise x64	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft Windows 8.1 Enterprise 32-bit	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft Windows 8 Pro x64	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft Windows 8 Enterprise x64	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1
		Microsoft® Windows® for x64	2.5	2.5_M1	9.4 TS1M0	9.4 TS1M1

* 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.

---

SAS Master Data Management batch and real-time updates invoke a database process to analyze SAS Master Data Management database indices. Index analysis should take place only after batch job updates and not on single-record updates.

Type:	Problem Note
Priority:	medium

Date Modified:	2014-03-20 15:11:58
Date Created:	2014-01-15 13:36:04