admin config

Displays all Replication Server configuration parameters.

Syntax

admin config [,[[[{“connection” | logical_connection}
   , data_server, database] | [“route”, repserver]] 
   [, configuration_name] | [“table”, data_server, database,
   [, table_name [[, table_owner], [, configuration_name]]]]

Note: If a configuration value is longer than 255 bytes, the admin config command only displays the first 251 bytes and an ellipsis (. . .).

Parameters

“connection” – Displays connection configuration parameters.
logical_connection – Displays logical connection configuration parameters.
“table” – 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.
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)

Example 4 – 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)

Example 5 – 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)

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.
Use admin config, "connection" to view Data Server Interface (DSI) and Replication Agent configuration parameters.

Note: The admin config, "connection" command does not display Distributor and Stable Queue Manager (SQM) thread configuration parameters.

For more information on configuring and tuning Replication Server parameters, refer to Replication Server Administration Guide Volume 1 and Volume 2.