Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP SQL Anywhere, on-demand edition 1.0 » SAP SQL Anywhere, on-demand edition » Search queries » Cloud object attributes

 

Server attributes

Server attributes describe the cloud servers.

Attribute name Description
object_id

A unique ID identifying the object within the cloud.

object_type

The object type.

The following values are supported:

  • Object   All cloud objects.

  • AgentAction   An agent action.

  • Backup   A backup.

  • Cloud   The cloud.

  • Database   A database.

  • DatabaseCopy   A copy of a database.

  • DataType   Internal use only.

  • Event   An event.

  • EventType   An event type.

  • Filter   A filter.

  • Host   A host.

  • MaintenancePlan   A maintenance plan.

  • Rule   A rule.

  • Schedule   A schedule.

  • Server   A cloud server.

  • StagingDirectory   A staging directory.

  • Tag   A tag.

  • Task   A task.

  • TaskDefinition   A task definition.

  • User   A cloud user.

  • InstallImage   Internal use only.

  • BackupCopy   A copy of a backup.

  • MaintPlanExecution   An execution of a maintenance plan.

  • MaintPlanExecutionDetail   A database backup from a maintenance plan.

object_uri

The relative URI to this object.

unique_id

A GUID that uniquely identifies the object across all clouds.

object_status

The object status.

The following values are supported:

  • VALID   The object has not been deleted.

  • DISABLED   The object is in the process of being created or deleted.

  • DELETED   The object has been deleted. The information about the object is retained for historical purposes for a period of time.

object_name

The object name.

creation_time

The time (with timezone) when the object was created.

last_log_modified_time

The time (with timezone) when the object was last modified.

resource_uri

A relative URI to the feed containing objects of this type.

modifying_task

The ID of the task currently modifying the object, or NULL.

title

The title of the object. For object types with a name, this is the same as the object_name attributes. For other types such as Event, Backup, and Task, the title attribute is set to a human-readable string generated to be short (one line).

summary

A description of the object. For object types that support a user-edited description, this is the user-edited description. For other types such as Event, Backup and Task, this is a longer descriptive string (one or more paragraphs).

running_status

The current status of the object.

The following values are supported:

  • stopped   Not running.

  • starting   In the process of being started.

  • running   Running and responding to requests.

  • stopping   In the process of being stopped.

  • disconnected   Inaccessible, but expected to be running.

  • dropping   In the process of being dropped.

  • dropped   Dropped.

  • waiting_for_uid_pwd   Waiting for the correct user ID and/or password.

  • stopped_unconditionally   Stopped when the parent object was stopped unconditionally.

  • failed   Not running (failed).

  • unresponsive   Running but not responding to requests.

run_mode

The expected status of the object.

The following values are supported:

  • stop   The object should not be running.

  • run   The object should be running and accepting requests.

  • maintenance   The object is being maintained.

start_time

The time when the object's running_status is set to "running".

max_active_event_severity

The highest severity level among all active events on this object.

The following values are supported:

  • Critical   The event is an error that may affect the proper functioning of the cloud.

  • Error   The event is an error associated with a task or single object.

  • Warning   The event is an unusual or anomalous condition that may cause future errors. (For example, when the free disk space on a host is low, a warning event is recorded.)

  • Info   The event is normal, and recorded for information only.

  • Debug   Internal use only.

host_id

The ID of the host the cloud server runs on.

tcpip_addresses

The list of host names or IP addresses and ports used by the cloud server for TCP/IP.

http_addresses

The list of host names or IP addresses and ports used by the cloud server for HTTP.

https_addresses

The list of host names or IP addresses and ports used by the cloud server for HTTPS.

current_load_state

The cloud's measure of how loaded this host is.

The following values are supported:

  • spare_capacity   This host has CPU and disk capacity that is not currently being used. It could run additional cloud servers or tenants.

  • ok   This host or cloud server is processing its workload normally.

  • overloaded   This host or cloud server has been overloaded for at least 10 minutes. Consider moving some cloud servers or tenants off of this host to improve performance.

version

The cloud software version used for the cloud server.

sa_version

The SQL Anywhere software version used for the cloud server.

sa_version_on_restart

The SQL Anywhere software version used for the cloud server after a restart.

installimage_annotation

An eight-byte description of a special instance of software.

page_size

The maximum page size allowed for databases running on the cloud server.

server_commandline

The command line options used when starting the cloud server.

is_cloud_arbiter

The value 1 indicates that the cloud server is the arbiter for the cloud; otherwise, the value is 0.

is_cloud_partner

The value 1 indicates that this cloud server is an HA partner for the cloud, otherwise, the value is 0.

is_cloud_partner_or_arbiter

The value is 1 if this cloud server is either a high availability partner for the cloud or the arbiter for the cloud, otherwise 0.

tcp_port

The port number the cloud server is currently using for TCP/IP communication.

http_port

The port number the cloud server is currently using for HTTP communication.

https_port

The port number the cloud server is currently using for HTTPS communication.

file_size

The size of the cloud server files, in bytes.

host_name

The name of the host the cloud server runs on.

 See also