topic Re: Programatically extract LASR tables limit? in SAS Visual Analytics

Programatically extract LASR tables limit?

tammy_dezilva — Wed, 28 Jun 2017 05:30:20 GMT

I am wanting to create a report which will show how much space is used by a LASR library plus the limit allocated to it (if it has a limit imposed). I have successfully found the amount used by the tables in the dataset _T_LASRMEMORY but I am also wanting to show what the limit is, so we can see what capacity is left. Neither the _T_LASRMEMORY or _T_TABLEMEMORY tables show the limit.

I know you can see the limit in VA Administrator via the LASR Servers Administrator tab and the Tables Limit column, plus also via Management Console in the extended attributes VA.MaxTotalMemoryForTables but how can I get this programatically? I know I could maintain the value in a table, but I'd rather I didn't have that maintenance to worry about when the limit is changed.

Alternatively, if I could get a report saying the capacity has been reached that would be sufficient. The status shows if over capacity in VA Adminstrator but I'm unsure how to get this status myself. I am using the macro %LASRSERVERRUNNING to see if a LASR server is started or stopped but it doesn't include over capacity.

thanks

Tammy

Re: Programatically extract LASR tables limit?

JuanS_OCS — Wed, 28 Jun 2017 06:55:01 GMT

Hello @tammy_dezilva,

I think this will help you: http://support.sas.com/documentation/cdl/en/inmsref/68736/HTML/default/viewer.htm#p050lknh5xepngn1s2kaa5nijrer.htm

Does it?

Juan

Re: Programatically extract LASR tables limit?

alexal — Wed, 28 Jun 2017 07:58:32 GMT

@tammy_dezilva,

The easiest way is to read the value of maxTotalTableMemory from server object through REST API. First of all, you have to find server ID here (for an example A5MTT44D_AZ00000F):

http://<MIDDLE_TIER_URL>/SASLASRAuthorization/rest/servers
<server port="10011" name="LASR Analytic Server" id="A5MTT44D_AZ00000F" hostname="test.unx.sas.com" description="SAS LASR Analytic server and the machine to which it is associated.">
<links>
<link uri="/servers/A5MTT44D_AZ00000F" rel="self" method="GET" href="http://test.unx.sas.com:7980/SASLASRAuthorization/rest/servers/A5MTT44D_AZ00000F"/>
</links>

Then, get information about the server:

http://<MIDDLE_TIER_URL>/SASLASRAuthorization/rest/servers/A5MTT44D_AZ00000F
<server port="10011" name="LASR Analytic Server" maxTotalTableMemory="-1" id="A5MTT44D_AZ00000F" hostname="test.unx.sas.com" description="SAS LASR Analytic server and the machine to which it is associated.">

-1 means no limit.

Re: Programatically extract LASR tables limit?

tammy_dezilva — Wed, 28 Jun 2017 23:22:28 GMT

Awesome, thank you so much @alexal. That's working a treat now!

Re: Programatically extract LASR tables limit?

alexal — Thu, 29 Jun 2017 07:04:25 GMT

@tammy_dezilva, you are welcome!