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:
- Run an interactive SAS session on the SAS compute-tier machine.
- Run the Marketing Optimization autoexec file. When you are prompted, use an external user account (for example, sasdemo) to authenticate.
- Submit the following LIBNAME statement:
- libname mometa "&mometa" server=&moshare authdomain="&modatausr_authdomain";
- Then submit the following statement:
- %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 ....
