Examples: | CONNECT and LIST Examples Using a Spawner |
Note | The filter does not support wildcard characters. The search is case-insensitive. |
libname.data-set-name
. data-set-name can be a regular data set name or take the form: libname.datasetname
.
Requirement | You must have the proper permissions to write the data set. |
Note | There is no requirement about where the data set is located. |
Alias | ABANDONED |
Alias | CAT= |
Default | Appenders, Counters, Information, Loggers, and Properties. |
Note | You must also specify a category when using NAME=. |
Example | list attrs cat = "Counters"; |
Note | You must also specify a category when using NAME=. |
Example | list attrs cat = "Information" name = "Server.ProcessIdentifier"; |
Notes | For all categories, the filter only returns a match
if the specified string ends with a period. For example, the filter
string App will return a match for App.Program .
|
FILTER attempts to match attributes across all categories, unless you also specify CATEGORY= to narrow the match to one category. | |
Example | list attrs filter = "Server."; |
Alias | ATTRS |
Requirement | You must be the owner of the server or cluster process or have the administer permission in SAS metadata for the server to see all attributes. |
Alias | CLSIDS |
Alias | CONTROL INFO |
Note | The filter does not support wildcard characters. The search is case-insensitive. |
Alias | SERVERS, DEFINED SERVERS |
Alias | INFO |
Default | When name= is not specified, all loggers are listed. |
Example | list log filter=’name=App.Server.Logger’ |
Example | list log filter="start=01aug2011:08:00:00 name=App.Server.Logger" |
Default | When end= is not specified, the current date and time is used. |
Example | list log filter='end=31aug2011:17:00:00 name=App.Server.Logger' |
Default | When level= is not specified, all levels are listed. |
Example | LIST LOG filter="level=warn,error name=App.Server.Logger" |
Note | The value level= takes precedence over threshold=. When threshold= is not used, all levels are listed. |
Example | list log filter="threshold=error name=App.Server.Logger" |
Default | When no column name is specified, message is the default. |
Example | list log filter='columns=(name,datetime) name=App.Server.Logger' |
Alias | LOG CONFIG, LOG CFG |
Note | The configuration is transcoded into the current session locale and, if it is printing to the log, the output is in XML format. |
TotalRealExecutionTime | total time spent on calls. |
TotalSystemCPUTime | total system CPU time spent on calls. |
TotalUserCPUTime | total user CPU time spent on calls. |
TotalCalls | total calls to the server. |
ElapsedObjectTime | elapsed time since the server object was launched. |
ElapsedServerTime | elapsed time since the server object was last started. |
Status | current state of server. The potential states are: |
Alias | PERF |
Alias | STIME |
Note | The filter does not support wildcard characters. The search is case-insensitive. |
Alias | SPAWNED, LAUNCHED |
Note | LIST TYPES does not require a connection. It is a client-side operation and only lists the server types that PROC IOMOPERATE knows about. |