| Table Name: | dist_srvr |
| Table Number: | 374 |
| Group: | Replication Engine |
| Description: | Holds database names and descriptions of all the databases, including the local database, which can participate in replication. Reserved; future |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| live_ind | LONG | int | DIRECT | Indicates whether participating server is currently live or not. Reserved; future | ||||
| local_ind | LONG | tinyint | DIRECT | Local server indicator; i.e., 0=remote, 1=local | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number. Reserved; future | Search (2) | ||
| proxy_db | CHAR | varchar | 32 | Database name on proxy server. Reserved; future | ||||
| proxy_name | CHAR | varchar | 32 | Name of alternate server that will receive data distribution if the server is not live. Reserved; future | ||||
| recovering | LONG | int | DIRECT | Indicates whether server is currently in recovery mode. Reserved; future | ||||
| srvr_db | CHAR | varchar | 32 | Database name of database server. Reserved; future | ||||
| srvr_id | LONG | int | DIRECT | ID of database server. Matches the site_id field in dictionary table adp_db_header. Reserved; future | Search (2) | |||
| srvr_name | CHAR | varchar | 2 | 80 | Name of database server. Reserved; future | |||
| status | LONG | int | DIRECT | Status of server; i.e., 0=down, 1=up. Reserved; future | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| dist_srvr2dist_birth | OTM | dist_birth | dist_birth2dist_srvr | Objects first replicated from the server | |||
| birth_srvr2dist_birth | OTM | dist_birth | birth_srvr2dist_srvr | Objects first created on the server | |||
| srvr2dist_index | OTM | dist_index | dist_index2srvr | Reserved; future | |||
| dist_srvr2dist_obj | OTM | dist_obj | dist_obj2dist_srvr | Server replicated from | |||
| dist_srvr2queue | OTM | queue | queue2dist_srvr | Queue connected to the distribution server | |||
| srvr2user | OTM | user | user2srvr | Users having the server as home server. Reserved; future | |||
| srvr2ver_index | OTM | ver_index | ver_index2srvr | Reserved; future |
| Index Name | Fields | Flags |
|---|---|---|
| server_id | srvr_id | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| objindex | objid | clustered, unique located on PRIMARY |
| server_id | srvr_id | nonclustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 134 | entry2clone | act_entry, dist_birth, dist_obj, dist_srvr, to_do_entry |
| 155 | object2clone | dist_birth, dist_obj, dist_srvr |
| dist_srvr | |||