4.3 The DBA TablesThe tables accessed through the DBA tab display a read-only view of the database tables. A DBA can use the information to diagnose some user issues without accessing the console database directly or issuing SQL commands. The tables provide helpful information that a cloud administrator can use when troubleshooting.For security reasons, the DBA tab does not display the table in which the server stores personal information about registered users, and columns containing sensitive information are obfuscated.4.3.1 activationThe activation table stores the user activation codes that are generated during registration or password recovery. The table contains one entry for each activation code generated.
The row identifier for the activation table. 4.3.2 attachedvolumeThe attachedvolume table provides information about volumes attached to cluster instances. The table contains one entry for each attached volume.
4.3.3 backupsThe backups table provides information about the current backups stored by the server. A backup consists of multiple snapshots (one for each EBS volume in a cluster).
Manual Backup if the backup was invoked by a user; Auto Backup if the backup was a scheduled system backup. 4.3.4 consoleurlThe consoleurl table provides a list of the resources currently made available by the console switcher.
4.3.5 dbengineThe dbengine table provides information about the currently defined database engines. The table contains one entry for each engine.
true if the engine is no longer supported; false if the engine is supported. 4.3.6 instancesThe instances table provides information about the currently active EDB Ark nodes for the EDB Ark service account. The table contains one entry for each instance (master or replica node).
true if auto-scaling is enabled on the cluster; false if auto-scaling is disabled. The current state of the database:
0 – Stopped
4.3.7 nodestatisticsThe nodestatistics table displays information gathered by the cluster manager about the activity for each node. The table contains one record for each time that the cluster manager collected information.
The row identifier for the nodestatistics table. 4.3.8 pcshistoryThe pcshistory table provides a sortable list of the transactions that have been displayed on the Events tabs of the registered users of the EDB Ark service account.
The row identifier for the pcshistory table. 4.3.9 propertyThe property table displays persistent properties used in the console, such as the console name used during backups and wall messages.
4.3.10 rhelrepoThe rhelrepo table provides information about the repositories required by the described Red Hat Subscription Manager services.
4.3.11 rhelsubscriptionThe rhelsubscription table provides information about currently defined Red Hat Subscription Manager services.
4.3.12 serverimageThe serverimage table provides information about currently defined EDB Ark server images.
The virtual machine OS user (as provided on the Add Server dialog). 4.3.13 snapshotsThe snapshots table provides information about cluster backups that reside in the cloud.
Manual Backup if the backup was invoked by a user; Auto Backup if the backup was a scheduled system backup.