psGenerateRepDefs

Description

    This program reads table definitions from the Primary Data Server
and writes a Korn shell script containing Replication Server create
replication definition commands.
    The generated Korn script will execute two psSQL sessions.  One with the
Replication Server and the other with the Primary Data Server.

Syntax

psGenerateRepDefs -Spds -Upds_username -Ppds_password -Dpds_database
-Wowner -Nname
-srep_server -urep_user -prep_pass
-Arep_def_prefix -Tmax_time_for_rssd
-Lrep_def_list_file -FKorn_shell_script
-Rresults_file -Mresults_file_max_size
-Grds -Hrds_user -Jrds_password -Krds_rssd
-Ooptions

-S

Primary Data Server Name

-U

Primary Data Server User Name

-P

Primary Data Server User Password

-D

Primary Data Server Database

-W

Make replication definitions for tables belonging to 'owner' [-U]

-N

Make replication definitions for tables having pattern 'name' [!rs%]

-s

Replication Server Name [-S]

-u

Replication Server User Name [-U]

-p

Replication Server User Password [-P]

-A

Prefix to add to replication definition names

-T

Maximum time (in seconds) allowed for rep defs to appear in RSSD [60]

-L

Output Rep Def List File

-F

Name of output Korn shell script [standard output]

-R

psSQL results file name [standard output]

-M

psSQL initial maximum size in bytes for results file [0]

-G

Replicate RSSD Data Server Name

-H

Replicate RSSD Data Server User [-U]

-J

Replicate RSSD Data Server Password [-P]

-K

Replicate RSSD Name

-O

Options

n

PDS tables do not have the same names as the corresponding RDSs' tables

c

All possible columns are searchable by subscriptions

m

Do not replicate the minimum number of columns

1

Send standby just replication-defined columns

2

Send standby all columns

r

Turn replication on.  This works when the RSSD resides on the Primary Data Server.

DSQUERY

When -S is not specified

SYB_USER

When -U is not specified

SYB_PASS

When -P is not specified

SYB_DATABASE

When -D is not specified

PS_SYSMSG_FILE

Name of the tool's messages file