Architecting, installing and maintaining your SAS environment

SAS Environment Manager Artifacts Backup

Reply
Contributor
Posts: 45

SAS Environment Manager Artifacts Backup

we have environment manager setup and it's working fine as we observe that the artifacts datasets have accumulated over 100 gigs.  however, we are running out of server space.  just wondering if we just move those artifacts datasets to another drive, would it impact the process?  \SASEnvironmentManager\emi-framework\apm\Data\artifacts  talking about the files in this folder.  if we remove them would the .bat file re-create those files again later?  thanks.

SAS Employee
Posts: 13

Re: SAS Environment Manager Artifacts Backup

I don't think removing the files is a good idea.  There is SAS code that manages the content and lets you prune the data.

The exact path might vary depending on where SAS is installed, the following code...

[Path to SAS installation]\SASEnvironment\SASCode\Jobs\apm_archive_data.sas

 

In the top of that code there is a path, %let sasUsageDir=<path>; that points to where APM data is stored.  The code provides a template for archiving/deleting data over a specified age from the artifacts directory to the archive directory in \APM\Data\.  You could set the archive directory to another location.  By default all of the files wind up in \APM\Data\ so that directory can grow quite large.

 

Does this help?  Do you see the code in your SASHome?

 

Contributor
Posts: 45

Re: SAS Environment Manager Artifacts Backup

yep, found it. just a few simple SQL statements. should've thought of it before. Smiley Happy thanks a bunch.
Contributor
Posts: 45

Re: SAS Environment Manager Artifacts Backup

oops. sorry.  i think we have a problem with the scripts.  the data steps creates temp tables after delete records.  but the server doesn't have enough space for temp table anymore.  sql delete does not physically deletes the records so the file size is still the same.  any ideas?  thanks.

SAS Employee
Posts: 13

Re: SAS Environment Manager Artifacts Backup

Looking at the code I see it uses a data step for the deletes, not proc sql.  The data step should delete the tables rows as long as the data steps finish..  The proc sql is just used to extract the backups to archive. If the server doesn't have room for the temp tables then the delete data steps will fail and all will be left as it was.  You can try setting the saswork and temp to a different larger disk.  That should allow all the steps to finish.

Ask a Question
Discussion stats
  • 4 replies
  • 386 views
  • 2 likes
  • 2 in conversation