Updating a subscription database (updatesubdb) v7
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
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.
- On this page
- Synopsis
- Parameters
- Examples