admin config

Description

Displays all Replication Server configuration parameters.

Syntax

admin config [,[{"connection" | logical_connection}, data_server, database] |
     ["route", repserver]] [, configuration_name]

Parameters

”connection”

Displays connection configuration parameters.

logical_connection

Displays logical connection configuration parameters.

data_server, database

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.

”route”

Displays route configuration parameters.

repserver

Specifies the target Replication Server of the route.

configuration_name

The configuration parameter whose values and status you want to display.

Examples

Example 1

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)

Example 2

Displays all configuration parameters for route to Replication Server, TOKYO_RS:

admin config, "route", TOKYO_RS

Example 3

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)

Usage

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.