If the metadata server is online, then you can use PROC
METADATA to check the status of metadata repositories. To do so, use
PROC METADATA to issue a GetRepositories method call that sets the
OMI_ALL flag to
1
. The GetRepositories
method is part of the SAS Open Metadata Interface.
The syntax is as follows:
PROC METADATA
SERVER="host-name"
PORT=port-number
USERID="your-user-ID"
PASSWORD="your-password"
IN="<GetRepositories>
<Repositories/>
<Flags>1</Flags>
<Options/>
</GetRepositories>";
RUN;
Note:
-
To run this program, you must have
ReadMetadata permission to all repositories on the SAS Metadata Server.
-
If the metadata server is paused
to an Offline state, then you cannot use PROC METADATA to issue a
GetRepositories method call.
-
If the metadata server is paused
to an Administration state, then special user credentials are required
to use PROC METADATA to issue a GetRepositories method call. The user
must either (1) be a member of the
Metadata Server: Unrestricted role or (2) be listed in adminUsers.txt, either with or without
an asterisk.
For each repository
that is registered to the metadata server, the GetRepositories method
returns the values of the following attributes:
Id
specifies the repository's
unique object identifier.
Name
specifies the name
assigned to the repository.
Desc
contains a description
of the repository.
Access
indicates the repository's
intended access mode, which is specified in the Access attribute of
the repository's metadata definition. This field corresponds to the
repository's Access field in SAS Management
Console. The possible values are OMS_FULL
(which is displayed as Online
in
SAS Management Console), OMS_READONLY
, OMS_ADMIN
, and OMS_OFFLINE
.
CurrentAccess
contains information
that is used by metadata server processes. This field is displayed
because it is sometimes used by SAS Technical Support in the resolution
of metadata repository issues.
Path
indicates the path
where the repository's data sets are located.
RepositoryFormat
contains the revision
level of the metadata model that is used by the repository. A RepositoryFormat
level that is less than the level of the server can cause the repository
to have a PauseState
(access state)
of ReadOnly.
For more information about the METADATA procedure
and the GetRepositories method, see
SAS Language Interfaces to Metadata.