hvrchecksuppllog

Usage

hvrchecksuppllog [-Rurl] [-lx]... [-v] hub Test all or specific source locations on the hub.
hvrchecksuppllog [-Rurl] [-lx]... [-v] hub chn Test all or specific source locations in the channel on the hub.

Description

This command is only supported for SQL Server.

Command hvrchecksuppllog checks if all the source locations specified in the command have supplemental logging (articles or CDC enabled for replication) enabled in tables for that location.

Options

This section describes the options available for command hvrchecksuppllog.

Parameter Description

Parameter	Description
`-lx`	Test locations specified by x. If this option is not supplied, then hvrchecksuppllog will test all locations within the channel. Values of x may be one of the following: loc: Only location loc. l1-l2: All locations that fall alphabetically between l1 and l2 inclusive. !loc: All locations except loc. !l1-l2: All locations except for those that fall alphabetically between l1 and l2 inclusive. Character '!' can be treated as a special (reserved) character in certain shells. Therefore, use single quotes (' ') or a backslash (\) when specifying the location(s) to be excluded. For example: `hvrchecksuppllog -l '!myloc' myhub` `hvrchecksuppllog -l \!myloc myhub` pattern: All locations matching the specified pattern. Pattern matching can be done using the special symbols , ? or [characters], where '' is any sequence of characters, '?' matches any character (exactly one), and '[]' matches a selection of characters. For example: 'loc' matches location names starting with 'loc'. 'loc' matches location names ending with 'loc'. 'loc?' matches location names 'loc1', 'loc2', 'loc3', but not 'loc12'. 'a[c0-9]' matches location names with first letter 'a' and second letter 'c' or a digit. 'a\|b' Multiple patterns may be specified. In this case, the pattern matches location names starting with 'a' and 'b'. @filename: All locations listed in filename (a .txt file containing location names, one per line). Several `-lx` instructions can be supplied together to hvrchecksuppllog.
`-Rurl`	Remote hub server. Access the hub server running on a remote machine, via the REST interface. This option is required for remote CLI access. When using this option, command hvrlogin should be run first, for authentication.
`-v`	Verbose. Display each table found with corresponding supplemental logging information.

-lx

Test locations specified by x. If this option is not supplied, then hvrchecksuppllog will test all locations within the channel.

Values of x may be one of the following:

loc: Only location loc.
l1-l2: All locations that fall alphabetically between l1 and l2 inclusive.
!loc: All locations except loc.
!l1-l2: All locations except for those that fall alphabetically between l1 and l2 inclusive.
Character '!' can be treated as a special (reserved) character in certain shells. Therefore, use single quotes (' ') or a backslash (\) when specifying the location(s) to be excluded. For example:
hvrchecksuppllog -l '!myloc' myhub
hvrchecksuppllog -l \!myloc myhub
pattern: All locations matching the specified pattern. Pattern matching can be done using the special symbols *, ? or [characters], where '*' is any sequence of characters, '?' matches any character (exactly one), and '[]' matches a selection of characters. For example:
- 'loc*' matches location names starting with 'loc'.
- '*loc' matches location names ending with 'loc'.
- 'loc?' matches location names 'loc1', 'loc2', 'loc3', but not 'loc12'.
- 'a[c0-9]' matches location names with first letter 'a' and second letter 'c' or a digit.
- 'a*|b*' Multiple patterns may be specified. In this case, the pattern matches location names starting with 'a' and 'b'.
@filename: All locations listed in filename (a .txt file containing location names, one per line).

Several -lx instructions can be supplied together to hvrchecksuppllog.

-Rurl

Remote hub server. Access the hub server running on a remote machine, via the REST interface.

This option is required for remote CLI access. When using this option, command hvrlogin should be run first, for authentication.

-v Verbose. Display each table found with corresponding supplemental logging information.

Examples

Example 1. Check supplemental logging on a specific location

The following command tests location myloc and displays the corresponding supplemental logging information.

hvrchecksuppllog -l 'myloc' -v myhub