Provides information about databases that Replication Server knows about.
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
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).