Displays all Replication Server configuration parameters.
admin config [,[[[{“connection” | logical_connection} , data_server, database] | [“route”, repserver]] [, configuration_name] | [“table”, data_server, database, [, table_name [[, table_owner], [, configuration_name]]]]
Displays connection configuration parameters.
Displays logical connection configuration parameters.
Specifies the name of a table being queried on. Use together with table_name which is a character string of up to 200 characters. table_owner is an optional qualifier for the table name, representing the table owner.
If you do not specify a table name, admin config displays configuration parameters for all tables.
The data server and database being queried on.
If the configuration parameters to be displayed are related to a connection, the server must be a data server, and database must be supplied. If the parameters to be displayed are related to a route, server must be a Replication Server, and you cannot supply database.
Displays route configuration parameters.
Specifies the target Replication Server of the route.
The configuration parameter whose values and status you want to display.
Displays all Replication Server global configuration parameters:
admin config go
Configuration Config Run Default Value Value Value ------------------- ------ ----- ------- cm_max_connections 65 65 64 dsi_cmd_batch_size 8193 8193 8192 Legal Values Datatype Status ------------------- -------- ----------------- range: 1,2147483647 integer Restart required range: 1,2147483647 integer Restart required (2 rows affected)
Displays all configuration parameters for route to Replication Server, TOKYO_RS:
admin config, "route", TOKYO_RS
Displays all configuration parameters for connection to pdb1:
admin config,"connection",ost_wasatch_04,pdb1 go
Configuration Config Run Default Value Value Value ------------------- ------ ----- ------- dsi_cmd_batch_size NULL NULL 8192 Legal Values Datatype Status ------------------- -------- ----------------- range: 1,2147483647 integer Connection/Route restart required (1 row affected)
Displays all configuration parameters after using dsi_command_convert to set d2none on the tb1 table in the pubs2 database of the SYDNEY_DS data server:
admin config, “table”, SYDNEY_DS, pubs2
admin config displays:
Configuration Config Run Default Value Value Value ------------------- ------ ----- ------- dsi_compile_enable <server default> <server default> on dsi_command_convert d2none d2none none Legal Values Datatype ------------------------------------------------------ -------- list: on,of string list: none, i2none, d2none, u2none, i2di, u2di, t2none string Status Table -------------------- ----- Restart not required dbo.tb1 Restart not required dbo.tb1 (2 rows affected)
Displays the configuration parameters only for dsi_command_convert after using dsi_command_convert on the tb1 table in the pubs2 database of the SYDNEY_DS dataserver:
admin config, “table”, SYDNEY_DS, pubs2, tb1, dsi_command_convert
admin config displays:
Configuration Config Run Default Value Value Value ------------------- ------ ----- ------- dsi_command_convert d2none d2none none Legal Values Datatype ------------------------------------------------------ -------- list: none, i2none, d2none, u2none, i2di, u2di, t2none string Status Table -------------------- ----- Restart not required dbo.tb1 (1 row affected)
Use admin config to retrieve the different types of configuration parameters—server, connection, logical connection, route—used to customize and tune the Replication Server:
For more information on configuring and tuning Replication Server parameters, refer to Replication Server Administration Guide Volume 1 and Volume 2.