Where is the info stored for wildcards currently in place in replication? (4298071)

Where is the info stored for wildcards currently in place in replication?

There are two places where the information about wildcards being used in the current replication is stored:

1. The active config file
2. The wildcards.nnnn file in the source /vardir/db subdirectory (where vardir refers to SharePlex Variable directory and nnnn is a number representing the SharePlex activation ID)

Whereas the wildcard entries in config files don’t need any elaboration, it is worth taking a look at the wildcard.nnnn file which looks like something below:

[ORA11GR2@alvsupl14]/home/paul/p92137-11g/var/db> cat ORA11GR2_wildcards.4

 source: "\"SCOTT\".\"ASDF\""

 target: "\"SCOTT\".\"ASDF\""

In SharePlex 8.2 or prior, the wildcard details were contained in the internal table SHAREPLEX_WILDCARD located in the source database. The info is now located in /vardir/db subdirectory.   You may want to notice that these are text files so the info from these is retrievable but the way to retrieve them would be different from the way one would do so from a table within an Oracle database as used to be the case. The files are useful in analyzing the wildcards currently in use as they have bearing on the replication when new objects conforming to those wildcards are created on source.