Updating a subscription database (updatesubdb) v7

Suggest edits

For SMR only: The updatesubdb command lets you change the connection information for an existing subscription database definition identified by its subscription database ID.

Synopsis

-updatesubdb
  -repsvrfile subsvrfile
  -subdbid dbid
  -dbhost host
  -dbport port
  -dbuser user
{ -dbpassword encrypted_pwd | -dbpassfile pwdfile }
[ -oraconnectiontype { sid | servicename } ]
  -database dbname
[ -urloptions jdbc_url_parameters ]

The subscription database definition to update is identified by the subdbid parameter.

See Adding a subscription database for details on the database connection information to supply for a subscription database definition.

Parameters

subsvrfile

The file containing the subscription server login information.

dbid

The subscription database ID of the subscription database definition to update.

host

The IP address of the host where the subscription database server is running.

port

The port number on which the database server is listening for connections.

user

The subscription database user name.

encrypted_pwd

The password of the database user in encrypted form. See Encrypting passwords to learn how to use the encrypt command to generate an encrypted password.

pwdfile

The file containing the password of the database user in encrypted form.

-oraconnectiontype

Specify sid to use the Oracle system ID (SID) to identify the subscription database in the database parameter. Specify servicename to use the Oracle service name to identify the subscription database in the database parameter.

Note

For Oracle 12c, use the service name.

dbname

The Postgres or SQL Server database name, the Oracle SID, or the Oracle service name of the subscription database.

jdbc_url_parameters

Extended usage of JDBC URL parameters such as for support of SSL connectivity. (See Using secure sockets layer (SSL) connections for information on SSL connectivity to the subscription database.) Specifying the urloptions parameter completely replaces any existing JDBC URL parameters that were previously specified with this database. Omitting the urloptions parameter deletes any existing JDBC URL parameters that were previously specified with this database.

Examples

This example updates an existing subscription database definition with subscription database ID 2.

$ java -jar edb-repcli.jar -updatesubdb -repsvrfile ~/subsvrfile.prop \
>   -subdbid 2 \
>   -dbhost 192.168.2.7 -dbport 5444 \
>   -dbuser subuser -dbpassfile ~/pwdfile \
>   -database subdb
Updating subscription database ...
Subscription database with ID 2 is updated successfully.
← Prev

Printing Subscription Database Details (printsubdbidsdetails)

Next →

Removing a subscription database (removesubdb)