Provides information about databases that Replication Server knows about.
rs_helpdb [data_server, database]
The data server with the database whose information you want to display.
The database whose information you want to display.
rs_helpdb
dsname dbname dbid --------------------------- ------------------------- ---- TOKYO_DS TOKYO_RSSD 101 SYDNEY_DS SYDNEY_RSSD 102 TOKYO_DS pubs2 105 controlling_prs errorclass ------------------------------ ------------------------- TOKYO_RS rs_sqlserver_error_class SYDNEY_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 status ------------------------------------------------------------------- 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.
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).
