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

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 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.

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.