Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Programatically extract LASR tables limit?

Accepted Solution Solved
Reply
Contributor
Posts: 47
Accepted Solution

Programatically extract LASR tables limit?

[ Edited ]

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


Accepted Solutions
Solution
‎06-28-2017 05:42 PM
SAS Employee
Posts: 284

Re: Programatically extract LASR tables limit?

[ Edited ]
Posted in reply to JuanS_OCS

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

View solution in original post


All Replies
Trusted Advisor
Posts: 1,314

Re: Programatically extract LASR tables limit?

Posted in reply to tammy_dezilva
Solution
‎06-28-2017 05:42 PM
SAS Employee
Posts: 284

Re: Programatically extract LASR tables limit?

[ Edited ]
Posted in reply to JuanS_OCS

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

Contributor
Posts: 47

Re: Programatically extract LASR tables limit?

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

 

SAS Employee
Posts: 284

Re: Programatically extract LASR tables limit?

Posted in reply to tammy_dezilva

@tammy_dezilva, you are welcome!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 249 views
  • 1 like
  • 3 in conversation