Hvrchecksuppllog
Name
hvrchecksuppllog - Checks supplemental logging of the specified tables.
Synopsis
hvrchecksuppllog [-hclass] [-ttbl]... [-uuser[/pwd]] [-v] hubdb chn loc
Description
This command is only supported for SQL Server.
Command hvrchecksuppllog checks if all tables in the channel or location specified in the command have supplemental logging (articles or CDC enabled for replication) enabled.
Argument hubdb specifies the connection to the hub database. For more information about supported hub databases and the syntax for using this argument, see Calling HVR on the Command Line. Argument chn represents the channel that contains the tables which need to be checked. Argument loc represents the location name in the channel which contains the tables.
Options
This section lists and describes all options available for hvrchecksuppllog.
| Parameter | Description |
|---|---|
| -hclass | Location class of the hub database. Valid values for class are db2, db2i, ingres, mysql, oracle, postgresql, sqlserver, or teradata. For more information, see Calling HVR on the Command Line. |
| -ttbl | Check only for specific table tbl. This option can be supplied multiple times. If this option is not supplied, then hvrchecksuppllog will check all tables within the channel. |
| -uuser[/pwd] | Connect to the hub database using the DBMS account user. For some databases (e.g. SQL Server) a password must also be supplied. |
| -v | Verbose. Display each table found with corresponding supplemental logging information. |