About Timmy2383

Timmy2383 · ‎04-05-2017

Oh ok, I see. I use SAS to scan through the logs directory to get a list of relevant logs to scan, then do a loop through the number of logs to scan each log file. I don't have code doing exactly this but I have something that may be able to be used. As a base. I may be able to get you something within the next hour when I get situated at the airport, but maybe someone else will chime in in the meantime.

Timmy2383 · ‎04-05-2017

David, I've implemented something similar in my environment when attempting to gather library and table usage. You might want to try turning on the audit logs as described in this blog post: http://blogs.sas.com/content/sgf/2015/09/30/part-1-auditing-data-access-who-did-what-and-when/

Timmy2383 · ‎03-28-2017

Glad you got it resolved!

Timmy2383 · ‎03-27-2017

1. Can you show what your env_local file looks like?2. Are you starting new SAS sessions for testing after each change?

Timmy2383 · ‎03-27-2017

See if you can use my setup as a template for your own. Here's what the entry for Oracle client in my env_local file looks like: #ORACLE export ORACLE_BASE=/u02/app/oracle export ORACLE_HOME=/u02/app/oracle/product/11.2.0/client export ORACLE_VERSION=11.2.0 export PATH=$ORACLE_HOME/bin:$PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export LD_LIBRARY_PATH

Timmy2383 · ‎03-27-2017

Where is your Oracle client installed and do you have SAS/Access to Oracle licensed/installed?

Timmy2383 · ‎03-27-2017

Probably works the same way as what Kurt suggested, but mine is set in the env_local file under !SASROOT/SASFoundation/9.4/bin/ You need to set the LD_LIBRARY_PATH environment variable in this file. See page 59 in this doc: http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf

Timmy2383 · ‎03-20-2017

By default other users won't be able to see that. If you create metadata objects that you want to share with other groups/users then it's probably better to save it in a line-of-business/group specific metadata folder (my recommendation) or under default "/Shared Data".

Timmy2383 · ‎03-17-2017

I have it set in my grid environment and have no complaints. Though most of my users came from stand-alone Windows 2008 servers, so the hardware alone is much more powerful. The power users typically process datasets in the 500GB range (after compression) and seem fine with it. I don't have any real tests or data to proceed, so may not be too helpful.

Timmy2383 · ‎02-24-2017

Our pleasure! Thanks to @Kurt_Bremser for giving proper clarification and elaboration of my hasty reply.

Timmy2383 · ‎02-23-2017

I had a similar problem for stored processes that are spawning using the Stored Process Server under the SAS General Servers account (instead of Workspace Servers under user's ID). If I recall correctly, I had to 1) make sure the SAS General Servers account had permissions on the library and 2) restart Object Spawners.

Timmy2383 · ‎02-23-2017

Thanks! I look forward to investigating further when I get into work today.

Timmy2383 · ‎02-23-2017

Makes sense. I need the same thing, eventually. For now I've been scraping all that info from PMM config files. Hopefully someone here knows how and we can both benefit.

Timmy2383 · ‎02-23-2017

What are you using as your scheduling server? Platform Process Manager or Operating System Services? Is scraping config files an option or do you have to get it from the metadata?

Timmy2383 · ‎12-09-2016

You should be able to modify the lsb.queues file. It's likely under <LSF_CONF>/lsbatch/sas_cluster/configdir. In my configuration, I created a "priority" queue and assigned the valid execution hosts (i.e. those machines running your app tier/workspace or batch servers). Here's an example of mine: Begin Queue QUEUE_NAME=priority PRIORITY=43 PREEMPTION=PREEMPTIVE HOSTS=host1 host2 host3 DESCRIPTION=Jobs submitted for this queue are scheduled as urgentjobs. Jobs in this queue can preempt jobs in lower priority queues. RERUNNABLE=NO NICE=10 End Queue Just substitute "host1 host2" with the approriate server names for your environment. I then made sure that any job scheduled with Process Manager is submitted to the "priority" queue. Likewise, you may be able to add the "HOSTS=" field to your Default queue.

Online Status	Offline
Date Last Visited	‎04-08-2021 03:11 AM

Re: SAS Studio (midtier) metadata folders

Re: SAS Studio (midtier) metadata folders

SAS Studio (midtier) metadata folders

Re: LSF Scheduling - EG Projects

Re: Local install on laptop, can an administrator do install without m...

Re: SAS Deployment Manager Error

Re: SAS Deployment Manager Error

Re: Process Manager: Flow Editor

Re: Process Manager: Flow Editor

Re: Process Manager: Flow Editor

Re: Uninstall old versions after maintenance release upgrade-in-place

Re: Error Libref is not assigned for dymanic prompt

Re: Error Libref is not assigned for dymanic prompt

Re: scheduled flow in SMC

Re: Using Prompt Values in ODS Tagsets Excel Sheet Names

Re: Editing Oracle Service Names (PATH) in SAS SMC

Re: SAS Studio (midtier) metadata folders

Re: LSF Scheduling - EG Projects

Re: Local install on laptop, can an administrator do install without m...

Re: Process Manager: Flow Editor

Re: Scan Workspace & Batch Server logs for dataset and library informa...

Re: Scan Workspace & Batch Server logs for dataset and library informa...

Re: SAS Oracle Configration

Re: SAS Oracle Configration

Re: SAS Oracle Configration

Re: SAS Oracle Configration

Re: SAS Oracle Configration

Re: Running stored procedure from ms excel

Re: Setting COMPRESS=YES as default on Linux Grid servers

Re: Error Libref is not assigned for dymanic prompt

Re: Error Libref is not assigned for dymanic prompt

Re: scheduled flow in SMC

Re: scheduled flow in SMC

Re: scheduled flow in SMC

Re: IBM Flow Manager & LSF - Issues: Exit code 127 & No Log file being...