4.2.11 com.sun.jts.dblogging.selectservernamequery
com.sun.jts.dblogging.selectservernamequery retrieves the server name of the stored transaction logs from a database.
Description
com.sun.jts.dblogging.selectservernamequery defines the SQL to be used by the transaction manager while retrieving the server name of the stored transaction logs from a database.
Specifiable values
Type: String
Initial value
Not specified
Default value
- If the definition item is omitted
-
select distinct servername from txn_log_table where instancename = ?
Examples
asadmin> create-jvm-options --target instance1 '-Dcom.sun.jts.dblogging.selectservernamequery= select distinct servername from txn_log_table where instancename = ?'
Notes
Used in the server