Show Master Database Information
You can display information for a master database.
Using ttRepAdmin to Display Information About the Master Database
Use the ttRepAdmin
utility with the -self
-list
options to display information about the master
database.
ttRepAdmin -dsn masterDSN -self -list
This example uses ttRepAdmin
to display information about the master
database described in Multiple Subscriber Classic Replication Schemes.
> ttRepAdmin -dsn masterds -self -list Self host "server1", port auto, name "masterds", LSN 0/2114272
The following table describes the fields.
Field | Description |
---|---|
|
The name of the host for the database. |
|
TCP/IP port used by a replication agent of another database to receive updates from this database. A value of 0 (zero) indicates replication has automatically assigned the port. |
|
Name of the database. |
|
Indicates the oldest location in the transaction log that is held for possible transmission to the subscriber. A value of |
Querying Replication Tables to Obtain Information About a Master Database
Use a SELECT
statement to query the TTREP.TTSTORES
and TTREP.REPSTORES
replication tables to obtain information about a master
database.
SELECT t.host_name, t.rep_port_number, t.tt_store_name FROM ttrep.ttstores t, ttrep.repstores s WHERE t.is_local_store = 0x01 AND t.tt_store_id = s.tt_store_id;
This is the output of the SELECT
statement for the master database
described in Multiple Subscriber Classic Replication Schemes. The fields are the host name, the replication port number, and
the database name.
< server1, 0, masterds>