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 SP 6 » 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 time zone) when the object was created.

last_log_modified_time

The time (with time zone) 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.