Programatically extract LASR tables limit?

[tammy_dezilva]

Hi

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

[JuanS_OCS]

Hello @tammy_dezilva,

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

Does it?

Juan

[alexal · Accepted solution]

@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.

[tammy_dezilva]

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

[alexal]

@tammy_dezilva, you are welcome!