dsschecksuppllog - DSS 6 | Data Source Solutions Documentation

Documentation: dsschecksuppllog - DSS 6 | Data Source Solutions Documentation

dsschecksuppllog

Usage

dsschecksuppllog [-Rurl] [-lx]... [-v] hub Test all or specific source locations on the hub.
dsschecksuppllog [-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 dsschecksuppllog 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 dsschecksuppllog.

Parameter Description

Parameter	Description
`-lx`	Test locations specified by x. If this option is not supplied, then dsschecksuppllog 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. The character '!' can be treated as a special (reserved) character in certain shells. In such cases, use single quotes (' ') or a back slash (\) when specifying the location(s) to be excluded. For example, `dsschecksuppllog -l '!myloc' myhub` or `dsschecksuppllog -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 dsschecksuppllog.
`-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 dsslogin 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 dsschecksuppllog 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.

The character '!' can be treated as a special (reserved) character in certain shells. In such cases, use single quotes (' ') or a back slash (\) when specifying the location(s) to be excluded. For example, dsschecksuppllog -l '!myloc' myhub or dsschecksuppllog -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 dsschecksuppllog.

-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 dsslogin 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.

dsschecksuppllog -l 'myloc' -v myhub