We’re smarter together. Learn from this collection of community knowledge and add your expertise.

My SAS Marketing Optimization datastore is huge and is running slow. How do I fix that?

by Community Manager on ‎12-23-2015 05:10 PM (170 Views)

SAS Marketing Optimization functionality writes to various SAS data sets that are stored in a datastore. As a result, there are times in which you might want to clean up orphaned or rogue entries in the datastore, particularly if you see a decrease in performance.

 

To clean up the datastore:

  1. Run an interactive SAS session on the SAS compute-tier machine.
  2. Run the Marketing Optimization autoexec file. When you are prompted, use an external user account (for example, sasdemo) to authenticate.
  3. Submit the following LIBNAME statement: 
  4. libname mometa "&mometa" server=&moshare authdomain="&modatausr_authdomain";
  5. Then submit the following statement:
  6. %mo_datastore_cleanup();

These steps do the following:

  • automatically make a backup copy of the datastore in the .../datastore/backups directory.
  • keep the datastore locked down
  • rewrite the tables to eliminate deleted observations from the tables

 

Operating System and Release Information

Product Family

Product

System

Product Release

SAS Release

Reported

Fixed*

Reported

Fixed*

SAS System

SAS Marketing Optimization

Microsoft® Windows® for x64

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows 8 Enterprise 32-bit

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows 8 Enterprise x64

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows 8 Pro 32-bit

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows 8 Pro x64

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows 8.1 Enterprise 32-bit

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows 8.1 Enterprise x64

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows 8.1 Pro

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows 8.1 Pro 32-bit

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows Server 2003 Datacenter Edition

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows Server 2003 Enterprise Edition

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows Server 2003 Standard Edition

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows Server 2003 for x64

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows Server 2008

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows Server 2008 R2

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows Server 2008 for x64

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows Server 2012 Datacenter

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows Server 2012 R2 Datacenter

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows Server 2012 R2 Std

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows Server 2012 Std

6.1_M1

 

9.3 TS1M2

 

Microsoft Windows XP Professional

6.1_M1

 

9.3 TS1M2

 

Windows 7 Enterprise 32 bit

6.1_M1

 

9.3 TS1M2

 

Windows 7 Enterprise x64

6.1_M1

 

9.3 TS1M2

 

Windows 7 Home Premium 32 bit

6.1_M1

 

9.3 TS1M2

 

Windows 7 Home Premium x64

6.1_M1

 

9.3 TS1M2

 

Windows 7 Professional 32 bit

6.1_M1

 

9.3 TS1M2

 

Windows 7 Professional x64

6.1_M1

 

9.3 TS1M2

 

Windows 7 Ultimate 32 bit

6.1_M1

 

9.3 TS1M2

 

Windows 7 Ultimate x64

6.1_M1

 

9.3 TS1M2

 

Windows Vista

6.1_M1

 

9.3 TS1M2

 

Windows Vista for x64

6.1_M1

 

9.3 TS1M2

 

64-bit Enabled AIX

6.1_M1

 

9.3 TS1M2

 

64-bit Enabled HP-UX

6.1_M1

 

9.3 TS1M2

 

64-bit Enabled Solaris

6.1_M1

 

9.3 TS1M2

 

HP-UX IPF

6.1_M1

 

9.3 TS1M2

 

Linux for x64

6.1_M1

 

9.3 TS1M2

 

Solaris for x64

6.1_M1

 

9.3 TS1M2


 

For updates to this info, visit Usage Note 54673: Using the datastore cleanup utility when the SAS Marketing Optimization datastore ....

 

Contributors
Your turn
Sign In!

Want to write an article? Sign in with your profile.


Looking for the Ask the Expert series? Find it in its new home: communities.sas.com/askexpert.