Get a list of all tables loaded in SAS Visual Analytics LASR memory

[Filipvdr]

Hi,

I need an export in .csv or excel of the management table in SAS VA which shows all tables (loaded/not loaded) and library. Is it stored somewhere? Because i can't rightclick and export.

[RexDeus9]

Hi,

This baffals me. More than one year later and no reasonable SAS resource can answer this!!!!

I am looking for the same thing, but using SAS code (eg proc IMSTAT TABLEINFO) but I can't get any sensible answer NO WHERE.

I will update when there...

Yvan

[Filipvdr]

Hi Yvan,

I did the following steps:

Get a list of al my LASR libraries.

Loop through this list and assign the library.

Using proc datasets getting a list of the tables in the library.

Maybe not the best solution, but it worked for me.

[RexDeus9]

Hi Filipvdr,

Good, nice that you got what you were looking for. In my case, I'm looking
to retrieve a list of all Tables that are 'loaded' in LASR memory.


Thank you,


Yvan

[alexal]

@RexDeus9,

I'm looking to retrieve a list of all Tables that are 'loaded' in LASR memory.

LIBNAME LASRLIB SASIOLA  TAG=VAPUBLIC  PORT=<LASR_PORT> HOST="<HEAD_NODE_FQDN>"  SIGNER="<MIDDLE_TIER_URL>/SASLASRAuthorization" ;

data tablemem;
    set lasrlib._T_TABLEMEMORY;
run;

proc print data=tablemem;
    var tablename;
run;

[Filipvdr]

@alexal: this gives me more the same then proc datasets. The fact is, if i have for example 50 different LASR libraries, i will have to assign them one by one...

[RexDeus9]

Hi Alexal,

Thx, now we're talking, exactly what I needed!


Yvan

[Filipvdr]

Yes, that is what proc datasets gives me.

I also got all tables registered in metadata to retrieve all the tables, not only the loaded ones

[ocrambo]

Hi,

It is possible to get al list of all loaded tables in LASR with proc IMSTAT. And what's not in can't get out 🙂

fill in the correct values of the variables:

%LET POORT=;

%LET AL_LASRHOST= ;
%LET AL_HOST=;
%LET AL_LASRINST=;
%LET AL_SIGNER=;
%LET AL_PATH=;
%LET AL_TABLEMEM=;
%LET AL_LOGGINGENABLED=;
%LET AL_LOGGINGKEEPLOG=KEEPLOG;

and run........

PROC IMSTAT;
      TABLEINFO / port=&Poort.;
RUN;

Cheers

[shekhar_chavan]

Below code can be used to get the list of tables loaded on the LASR:

LIBNAME LASRLIB SASIOLA TAG=VAPUBLIC PORT=10031 HOST=<HOSTNAME> SIGNER="http://<hostname>:<port_no>/SASLASRAuthorization" ;

%let sizecols = InMemorySize UncompressedSize
CompressedSize TableAllocatedMemory
InMemoryMappedSize ChildSMPTableMemory
VirtualMemory ResidentMemory AllocatedMemory;
%let countcols = NumberRecords UseCount RecordLength ComputedColLength;

data tablemem;
set lasrlib._T_TABLEMEMORY;
run;

data lasrmem;
set lasrlib._T_LASRMEMORY;
run;

proc print data=lasrmem;
title "LASR Server Memory Usage";
format &sizecols. sizekmg9.2;
format &countcols. 8.;
sum _numeric_;
run;

proc print data=tablemem;
title "LASR Server Table Memory Usage";
format &sizecols. sizekmg9.2;
format &countcols. 8.;
sum _numeric_;
run;