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

BackupCopy attributes

Records the location and status of all copies of backups in 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.

backup_id

The ID of the backup.

host_id

The ID of the host storing the backup copy.

status

The status of the backup copy.

The following values are supported:

  • Pending

    Backup not yet completed.

  • Success

    Backup completed successfully.

  • Fail

    Backup completed unsuccessfully.

  • ValidationFail

    Backup completed successfully but validation failed.

  • ValidationUnknown

    Only used for backup sets. Means at least one backup copy in the set was not validated.

dir

The directory where the backup files are stored.

file_size

The size of the backup files, in bytes.

validation_type

The type of validation that is performed on the backup copy.

The following values are supported:

  • D

    Validate that all pages in the database belong to the correct object, perform a checksum validation, and validate the correctness of indexes.

  • F

    Perform a full validation.

  • S

    Perform a checksum validation.

  • X

    Perform an express validation.

  • N

    Do not perform validation.

expiration_date

The earliest date that the backup copy will be deleted automatically. If NULL, this backup copy will not be deleted automatically.

database_id

The ID of the database.

db_version

The version of the database.

type

The type of the backup (Full or Incremental).

The following values are supported:

  • Full

    Full backup.

  • Incremental

    Incremental backup.

apply_after

The id of the full backup that must be restored before this incremental backup can be applied, or NULL.

final

Set to 1 if any incremental backups based on this full backup have been deleted. Always 0 for incremental backups.

incremental_index

An index used for ordering the incremental backups of a given full backup. Set to NULL for full backups.

database_name

The name of the database identified by database_id.

database_uri

The URI of the database identified by database_id.

backup_creation_time

The date that the backup (not the copy) was created.

backup_set_status

The status of the backup set.

The following values are supported:

  • Pending

    Backup not yet completed.

  • Success

    Backup completed successfully.

  • Fail

    Backup completed unsuccessfully.

  • ValidationFail

    Backup completed successfully but validation failed.

  • ValidationUnknown

    Only used for backup sets. Means at least one backup copy in the set was not validated.

backup_set_size

The size of the backup set.

backup_set_date

The date of the most recent backup in the backup set.

elapsed_time

If the backup status is pending, the number of seconds since the backup began. NULL if the backup is not pending.

backup_name

The name of the backup.

host_name

The name of the host storing the backup copy.