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

SAP Sybase SQL Anywhere, on-demand edition 1.0 Support Package 3 » SAP Sybase SQL Anywhere, on-demand edition 1.0 » Search queries » Cloud object attributes

 

Host attributes

Host attributes describe the hosts that are managed by the cloud.

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.

tcpip_addresses

The list of IP addresses used by the host.

preferred_tcpip_addresses

The list of host names or IP addresses used to connect to the host.

use_static_tcpip_addresses

A value that indicates whether the static_tcpip_addresses value should be used.

static_tcpip_addresses

The list of static IP addresses supplied when the host was added to the cloud.

machine_name

The machine name of the host.

cpu_performance

The measured performance of the host.

disk_read_rand_io_per_sec

The measured number of random read I/O requests that can be performed per second.

disk_read_seq_bytes_per_sec

The measured number of bytes that can be read per second with sequential reads.

IsPortableDevice

A value that indicates whether the host is a portable device such as a laptop computer.

NativeProcessorArchitecture

The native processor architecture of the host.

bitness

The bitness of the operating system the host is running on. The value is 32 or 64.

NumLogicalProcessors

The number of logical processors (including cores and hyperthreads) enabled on the host.

NumPhysicalProcessors

The number of physical processors enabled on the cloud server computer. This value is NumLogicalProcessors divided by the number of cores or hyperthreads per physical processor. On some non-Windows platforms, cores or hyperthreads are counted as physical processors.

Platform

The operating system of the host. For example, if the host is running on Windows XP, this property returns WindowsXP.

PlatformVer

The operating system of the host, including build numbers, service packs, and so on.

CompactPlatformVer

A condensed version of the PlatformVer property.

ProcessorArchitecture

A string that identifies the processor type of the host.

current_load_state

The cloud's measure of how loaded the 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.

tcp_ports

The TCP/IP port numbers and/or a set of port ranges separated by commas.

http_ports

The HTTP port numbers and/or a set of port ranges separated by commas.

https_ports

The HTTPS port numbers and/or a port ranges separated by commas.

agent_version

The version number of the cloud agent on the host.

default_installimage_id

The ICloudInstallImage record of the most recent software version installed on the host.

polling_server

The identifier of the cloud server on the host that the cloud agent is polling (or NULL).

next_tcp_port

The next available TCP port available for a cloud server.

next_http_port

The next available HTTP port available for a cloud server.

next_https_port

The next available HTTPS port available for a cloud server.

file_size

The total size of data files on this host, in bytes

disk_free_space

The amount of free space on the partition that stores the data files, in bytes.

backup_size

The total size of backup files on this host, in bytes.

num_crash_dumps

The number of unsubmitted crash dumps on the host

has_cloud_partner_or_arbiter

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

allow_backups

Set to 1 if this host allows future backups to be stored on it, and 0 otherwise.

polling_server_name

The name of the cloud server on the host that the cloud agent is polling (or NULL).

default_installimage_name

The ICloudInstallImage name of the most recent software version installed on the host.

 See also