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 (169 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.