Show TOC

rs_helpdbLocate this document in the navigation structure

Provides information about databases that Replication Server knows about.

Syntax
rs_helpdb [<data_server>, <database>]
Parameters
data_server

The data server with the database whose information you want to display.

database

The database whose information you want to display.

Examples
Example 1
rs_helpdb
dsname                           dbname               conn_id   dbid
---------------------------      ----------------     -------   ----
TOKYO_DS                         TOKYO_RSSD           101       101
SYDNEY_DS                        SYDNEY_RSSD          102       102 
TOKYO_DS                         pubs2                105       105
TOKYO_DS                         pubs2_conn2          106       105 

controlling_prs                  errorclass
------------------------------   -------------------------
TOKYO_RS                         rs_sqlserver_error_class
SYDNEY_RS                        rs_sqlserver_error_class
TOKYO_RS                         rs_sqlserver_error_class
TOKYO_RS                         rs_sqlserver_error_class

repserver_errorclass             funcclass
------------------------------   ---------------------------
rs_repserver_error_class         rs_sqlserver_function_class
rs_repserver_error_class         rs_sqlserver_function_class
rs_repserver_error_class         rs_sqlserver_function_class
rs_repserver_error_class         rs_sqlserver_function_class

status
-------------------------------------------------------------------
Log Transfer is ON, Distribution is ON
Log Transfer is ON, Distribution is ON
Log Transfer is ON, Distribution is ON
Log Transfer is ON, Distribution is ON
Usage

  • If you do not provide the <data_server> and <database> parameters, rs_helpdb returns results for all of the databases in the <rs_databases> system table.

  • rs_helpdb is executed in a Replication Server’s RSSD.

  • For each database, rs_helpdb provides the following information:

    <dsname> – the name of the data server with the database.

    <dbname> – the name of the database.

    <connid> – the ID number assigned to uniquely identify each connection to a database throughout the replication system, if you enable multi-path replication.

    <dbid> – the ID number assigned to uniquely identify the database throughout the replication system.

    <controlling_prs> – the Replication Server that manages the database.

    <errorclass> – the error class Replication Server uses to handle errors returned from the data server for this database.

    <repserver_errorclass> – the error class that handles errors returned from the Replication Server for this database.

    <funcclass> – the function-string class used for the database.

    <status> – tells whether log transfer and distribution are on or off for the database.

    <ltype> – the type of database connection (logical or physical).

    <ptype> – the type of database (active database, standby database, or logical connection).