Managing a Server, Its Libraries, and Its Users

Server Management: OPERATE Procedure

Use commands in the OPERATE procedure to manage the following:
  • an active server, or a server that is running. You can display information about a server, quiesce a server, reset a server (for subsequent management operations), restart a quiesced server, and stop a server. For information about managing a server, see Server Management Commands.
  • server libraries. You can allocate a library to an active server, display information about a library, and free, quiesce, or stop a library. For information about managing a library, see Library Management Commands.
  • users. You can display information about users, quiesce a user's access, restart a quiesced or a stopped user, or terminate user connections to a server. For information about managing users, see User Management Commands.

Server Log Reporting: OPERATE Procedure

The following log shows part of the server administrator's log for PROC OPERATE. The log reports client/server transactions for users John and Maria, who are working on a server named SHARE1. For information about interpreting server logs that are generated by users, see Interpreting SAS/SHARE Server Log Messages.
Administrator's Log for the OPERATE Procedure

   LOG
   Command ===>

   1    proc operate serverid=share1;
   ======================================================================
   2    display user _all_;

                                              NUMBER OF
                     USER ID      STATUS      LIBRARIES
                     ----------------------------------
                     john(1)      ACTIVE         1
                     maria(2)     ACTIVE         2
                     myid(3)      ACTIVE         0
   ======================================================================
   3    stop user maria;
   User maria(2) stopped from active state.
   User maria is now disallowed from connecting to server SHARE1.
   ======================================================================
   4    display user maria;

                                              NUMBER OF
                     USER ID      STATUS      LIBRARIES
                     ----------------------------------
                     maria(2)     STOPPED        0
   ======================================================================
   5    quiesce user 1;
   User john(1) quiesced from active state.
   ======================================================================
   6    display user 1;
                                              NUMBER OF
                     USER ID      STATUS      LIBRARIES
                     ----------------------------------
                     john(1)      QUIESCED       1

   User john(1) is accessing these libraries:

          USER LIBREF    SERVER LIBREF    LIBRARY NAME
          -------------------------------------------------------------
          DATALIB        SYSUSE          
<SAS-library-name>

   User john(1) is accessing these data sets:

   USER LIBREF    SERVER LIBREF    MEMBER       TYPE         OPEN MODE
   --------------------------------------------------------------------
   DATALIB        SYSUSE           USAGE        CATALOG       UPDATE
   ======================================================================
   7    start user maria;
   User maria started from stopped state and therefore has become unknown
   to server SHARE1.
   ======================================================================
   8    quit;
1PROC OPERATE executes commands 2 through 8 (shown in the preceding output).
2The DISPLAY USER command requests general information about all users who are currently accessing SHARE1. The users are listed by user ID, current status, and the number of library assignments to the server.
3The STOP USER command immediately disconnects user MARIA(2) from the server. If Maria is using the FSEDIT procedure to update an observation when the STOP command is issued, she loses the updates on her display, but she does not lose previous updates. The STOP USER command terminates all attachments to that server, and she is prohibited from accessing that server until the administrator issues a START USER command.
4The DISPLAY USER command shows Maria's current status. No libraries are listed for Maria because the STOP USER command released them.
5The QUIESCE USER command gradually terminates user JOHN(1), which allows John to finish work in the data sets that he currently has open.
6The subsequent DISPLAY USER command reports that John is still accessing member USAGE in library DATALIB. When John closes USAGE in that library, the server releases the library and disconnects John. Because John's session was quiesced by its connect number, John can reconnect to the server when he wants to. He receives a new connection number at that time.
7The START USER command allows Maria to access the server again. Note that the START USER command does not establish a communication path between the server and Maria. It only enables Maria to re-establish a path by using a LIBNAME statement or an SQL CONNECT TO statement. She must explicitly re-access the server.
8The QUIT statement terminates PROC OPERATE.

Freeing a Library that Contains a Locked Data Set

An administrator might need to free a library from a server so that another process can directly manipulate data in the library. Use these steps to free a library from a server. For details about the commands used in these steps, see The OPERATE Procedure.
  1. Use the QUIESCE LIBRARY command to change the library's status from active to stopped.
    The QUIESCE command returns immediately, but the quiesce process does not complete until the final user has voluntarily released the library from use.
  2. Use the DISPLAY LIBRARY command to find out the active users and their user librefs.
    Contact these users and ask them to release the library. Wait a sufficient period of time for users to finish their work. Display library usage again to verify that all users have released the library from access.
  3. Use the STOP USER command to terminate all client sessions that reference SAS views into the specified SAS library.
    These views were identified using the DISPLAY LIBRARY commands. Client sessions that hold open views into the specified library from another library should also be terminated.
  4. If the library has not yet stopped, use the STOP LIBRARY command to change the library's status to stopped. This command immediately terminates all remaining user access to the specified library.
  5. Use the FREE LIBRARY command to release the specified library from use.
    The library should be freed from use.