Checking the Access State and Other Properties of the SAS Metadata Server

About SAS Metadata Server States

A SAS Metadata Server can exist in any of the following states:
Online
The metadata server is available to accept client requests from authenticated users.
External systems such as Windows Services Manager report the Online state as running or started.
Offline
The metadata server is paused and is not available to accept client requests. When the metadata server is paused to Offline status, the server does the following:
  • retains all active client connections.
  • temporarily changes the access state of all repositories to Offline.
  • temporarily stops receiving client requests to read or write metadata. If a client application submits a new request, the client displays a message indicating that the server is paused.
  • flushes updated metadata from the server's memory and writes the updated metadata to the metadata repository.
  • closes the SAS data sets that serve as repository containers.
The Offline state is useful if you need to disable users' access while you perform maintenance on the metadata server machine. External systems such as Windows Services Manager report the Offline state as paused.
Administration
The metadata server is paused and will accept requests only from an unrestricted administrative user. When the metadata server is paused to Administration status, the server does the following:
  • retains all active client connections.
  • temporarily stops receiving client requests to read or write metadata, with the following exceptions
    • users who are in the Metadata Server: Unrestricted role can continue to perform all functions in SAS Management Console.
    • users who are in both the Metadata Server: Operation and the Management Console: Advanced role (or who are in the SAS Administrators group) can stop, pause, resume, and reset the metadata server.
    In all other situations, the client displays a message indicating that the server is paused.
The Administration state is useful when you need to disable users' access while you connect to the metadata server to perform administrative tasks such as the following:
  • run diagnostic and repair tools
  • upgrade metadata to a new version
  • promote metadata and related content
  • modify metadata for components of a SAS Application Server
In addition, the server is automatically placed in the Administration state in the following situations:
  • When you execute the Metadata Analyze and Repair tools.
  • If a problems occur during server initialization when the server is started or resumed. When the server is in the Administration state, the administrator can log on to SAS Management Console, examine the server log to determine the source of the problem, make any necessary corrections, and resume the server.
External systems such as Windows Services Manager report the Administration state as paused.
Stopped
The Stopped state terminates the SAS Metadata Server process and breaks all client connections. The metadata server, and all SAS servers that depend on it, must be started before clients can connect again.

Use SAS Management Console to Check the Access State and Other Properties of the SAS Metadata Server

To use SAS Management Console to check the access state and other properties of the SAS Metadata Server:
  1. In the SAS Management Console Plug-ins tab, expand the Metadata Manager node.
  2. Right-click the Active Server node and select Properties. The Active Server Properties dialog box appears.
    In this dialog box, the General tab displays the following:
    • the server’s current state and, if the server is paused, any comments that were entered by the administrator
    • information about whether a backup is currently running
    • the server’s locale, version, and alert e-mail address
  3. Select the Statistics tab to see server statistics including CPU seconds, memory utilization, thread utilization, and I/O activity.

Use PROC METAOPERATE to Check the Access State of the SAS Metadata Server

To check the access state of the SAS Metadata Server, you can use PROC METAOPERATE to issue a STATUS action. The syntax is as follows:
PROC METAOPERATE
  SERVER='host-name'
  PORT=port-number
  USERID='user-ID'
  PASSWORD='password'
  PROTOCOL=BRIDGE
  ACTION=STATUS;
RUN;
Any user who can log on to the SAS Metadata Server can issue a STATUS action.
If the SAS Metadata Server is running normally, information similar to the following is written to the SAS log:
NOTE: Server dXXXX.us.company.com SAS Version is 9.03.01M0P040611
NOTE: Server dXXXX.us.company.com SAS Long Version is 9.03.01M0P040611.
NOTE: Server dXXXX.us.company.com Operating System is X64_S08R2.
NOTE: Server dXXXX.us.company.com Operating System Family is WIN.
NOTE: Server dXXXX.us.company.com Operating System Version is 6.1.
NOTE: Server dXXXX.us.company.com Client is userid@DOMAIN.
NOTE: Server dXXXX.us.company.com Metadata Model is Version 12.04.
NOTE: Server dXXXX.us.company.com is RUNNING on 09May11:10:31:26.
If the SAS Metadata Server is paused, information similar to the following is written to the SAS log:
NOTE: Server dXXXX.us.company.com SAS Version is 9.03.01M0P040611
NOTE: Server dXXXX.us.company.com SAS Long Version is 9.03.01M0P040611.
NOTE: Server dXXXX.us.company.com Operating System is X64_S08R2.
NOTE: Server dXXXX.us.company.com Operating System Family is WIN.
NOTE: Server dXXXX.us.company.com Operating System Version is 6.1.
NOTE: Server dXXXX.us.company.com Client is userid@DOMAIN.
NOTE: Server dXXXX.us.company.com Metadata Model is Version 12.04.
NOTE: Server dXXXX.us.company.com is PAUSED on 09May11:10:31:26.
A SAS Metadata Server that is stopped will not respond to a PROC METAOPERATE request.
For more information about PROC METAOPERATE, see SAS Language Interfaces to Metadata.