Start of change

TIME_PROTOCOL_INFO view

The TIME_PROTOCOL_INFO view returns information about Network Time Protocol (NTP) servers that are configured.

The TIME_PROTOCOL_INFO view requires 5770SS1 Option 33 - Portable Application Solutions Environment (PASE).

Authorization: The caller must have *IOSYSCFG special authority.

The following table describes the columns in the view. The system name is TIME_PROTO. The schema is QSYS2.

Table 1. TIME_PROTOCOL_INFO view
Column Name System Column Name Data Type Description
TIME_SERVER SERVER VARCHAR(256) The DNS domain name for the NTP server.
PREFERRED_INDICATOR PREFERRED VARCHAR(3) Indicates whether this server is a preferred time source in the NTP client configuration
NO
This is not a preferred time server.
YES
This is a preferred time server.

Example

  • List all the configured time protocol servers.
    SELECT * FROM QSYS2.TIME_PROTOCOL_INFO;
End of change