Problem Note 49672: MIMain_PRF_Long STP jobs run longer than expected
 |  |  |  |  |
When running the SizeProfilingActivityRun or SizeProfilingPublishUnpublish stored processes on the MIMain_PRF_Long stored process servers for SAS® Size Profiling, you might notice the jobs taking longer than expected to run. Upon inspection of the stored process logs, you might notice the P_SGM library is inefficiently allocated repetitively resulting in long run times. This has been observed when the str_grp_mbr folder of the data mart contains a very large number of files.
There is no workaround for this issue. However, in some environments adding a '-ENGINE V9' option to your SAS configuration file might improve the speed of the individual library allocations resulting in decreased job run time.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.2_M1 | 3.2_M3 | 9.3 TS1M2 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 3.2_M1 | 3.2_M3 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Linux for x64 | 3.2_M1 | 3.2_M3 | 9.3 TS1M2 | 9.3 TS1M2 | ||
A fix for this issue for SAS Revenue Optimization 5.2_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K36.html#49672A fix for this issue for SAS Size Optimization 3.2_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K37.html#49672| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2014-03-06 12:48:23 |
| Date Created: | 2013-04-17 09:41:48 |