IBM Tivoli Composite Application Manager for Microsoft Applications, Version 6.3

MS SQL Availability Database Details attributes

The MS SQL Availability Database Details attribute group provides information about the availability databases that are hosted by the SQL Server instance. This attribute group is supported for SQL Server 2012 Enterprise Edition, or later.

Database ID The ID of the availability database that is hosted by the SQL Server instance. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
Database Name The name of the availability database that is hosted by the SQL Server instance. The following values are valid:
External value Internal value Description
Not Collected Not_collected The value cannot be collected.
Not Applicable Not_applicable The value is not supported.
Database State Indicates the current state of the availability database. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected.
Online 1 The database is available for access.
Restoring 2 The database is currently unavailable because of one of the following reasons:
  • One or more files of the primary group are being restored.
  • One or more secondary files are being restored offline.
Recovering 3 The database is currently unavailable and is being recovered. If the database recovery is successful, the database state changes to Online. If the database recovery fails, the database state changes to Suspect.
Recovery Pending 4 The database is currently unavailable because of one of the following reasons:
  • Some files are missing.
  • The database cannot start because of system resource limitations.
Suspect 5 The database is currently unavailable because of the following reasons:
  • The primary file group is damaged.
  • Database cannot be recovered during the SQL Server startup.
Emergency 6 The database is currently in the single-user mode, and is being repaired or restored. The following actions are completed when the database is in the Emergency mode:
  • The database is marked read-only.
  • Logging is disabled.
  • Access is limited to the members of the sysadmin fixed server role.
Offline 7 The database is not available for access.
Group Database ID The ID of the availability group database that is hosted by the SQL Server instance. The following values are valid:
External value Internal value Description
Not Collected Not_collected The value cannot be collected.
Not Applicable Not_applicable The value is not supported.
No Data nodata No data is collected.
Group ID The ID of the availability group to which the availability database belongs. The following values are valid:
External value Internal value Description
Not Collected Not_collected The value cannot be collected.
Not Applicable Not_applicable The value is not supported.
No Data nodata No data is collected.
Group Name The name of the availability group to which the availability database belongs. The following values are valid:
External value Internal value Description
Not Collected Not_collected The value cannot be collected.
Not Applicable Not_applicable The value is not supported.

Hub Timestamp The time when data is inserted at the hub.

Local Indicates whether the availability replica is hosted by the local SQL Server instance. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected.
No 1 The replica is not hosted by the local instance.
Yes 2 The replica is hosted by the local instance.

Originnode The key for the table view in the format serverid:hostname:MSS.

Replica ID The ID of the availability replica. The following values are valid:
External value Internal value Description
Not Collected Not_collected The value cannot be collected.
Not Applicable Not_applicable The value is not supported.
No Data nodata No data is collected.
Role Indicates whether the availability database is a primary or a secondary database. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected.
Resolving 1 The system is trying to gather information about the role of the database.
Primary 2 The database is the primary database.
Secondary 3 The database is the secondary database.
Invalid 4 The availability group that is associated with the database is offline.

Server The name of the SQL Server.

Suspend Reason The reason for a database to enter the suspended state. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected. This enum is shown if the database is not suspended.
Suspend From User 1 The reason for the database to be suspended is Suspend From User.
Suspend From Partner 2 The reason for the database to be suspended is Suspend From Partner.
Suspend From Redo 3 The reason for the database to be suspended is Suspend From Redo.
Suspend From Apply 4 The reason for the database to be suspended is Suspend From Apply.
Suspend From Capture 5 The reason for the database to be suspended is Suspend From Capture.
Suspend From Restart 6 The reason for the database to be suspended is Suspend From Restart.
Suspend From Undo 7 The reason for the database to be suspended is Suspend From Undo.
Suspend From Revalidation 8 The reason for the database to be suspended is Suspend From Revalidation.
Synchronization Health Indicates the health of the availability database replica. The replica is healthy if the synchronized and the asynchorinzed replicas are in the Synchronized state. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected.
Not Healthy 1 The synchronization health of the database replica that is hosted on the SQL Server instance is not healthy.
Partially Healthy 2 The synchronization health of the database replica that is hosted on the SQL Server instance is partially healthy.
Healthy 3 The synchronization health of the database replica that is hosted on the SQL Server instance is healthy.
Synchronization State The current synchronization state of the availability database replica. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected.
Not Synchronizing 1 On a primary database, this value indicates that the database is not ready to synchronize the transaction log with the secondary database.
On a secondary database, this value indicates that the database is not synchronizing because of one of the following reasons:
  • The database has not started log synchronization.
  • The database is being suspended.
  • The database is going through the transition state during the startup.
  • The database role is changing.
Synchronizing 2 On a primary replica, this value indicates that the database is ready to accept a scan request from the secondary database.
On a secondary replica, this value indicates that an active data movement is in progress.
Synchronized 3 On a primary replica, this value indicates that at least one secondary database is synchronized, and is available as a target for a failover without data loss.
On a secondary replica, this value indicates that all secondary databases are synchronized with the corresponding primary databases.
Reverting 4 Indicates that the availability database replica is in the Reverting state.
Note: If the availability database replica is forced to shut down when the replica is in the Reverting state, you may not be able to start the replica again.
Initializing 5 Indicates that the availability database replica is in the Initializing state.
Note: If the availability database replica is forced to shut down when the replica is in the Initializing state, you may not be able to start the replica again.
Synchronized Commit Indicates whether the transaction commit is synchronized with the database replica. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected.
Not Synchronized 1 The transaction commit is not synchronized with the database replica.
Synchronized 2 The transaction commit is synchronized with the database replica.
Parent topic: Attributes in each attribute group

Feedback