psDropRepDefs

Description

   This program writes a Korn shell script.  The script logs
into the Primary Replication Server and drops replication
definitions.
   The reason you do not specify the RSSD name nor the Data
Server where the RSSD lives is because I get this information from
from the Replication Server.   You just have to make sure that
the user and password you supply are for the Data Server I find.

Syntax

psDropRepDefs
-Sprs_server -Uprs_username -Pprs_password
-uRSSD_username -pRSSD_password
-Lrep_def_list_file
-Adata_server_pattern -Cdatabase_pattern
-Brep_def_names -Ntable_names -Tmax_drop_time
-Grds -Hrds_user -Jrds_password -Krds_rssd
-FKorn_script -Rresults_file -Mresults_file_max_size

-S

Primary Replication Server Name

-U

Primary Replication Server User

-P

Primary Replication Server Password

-u

Data Server User

-p

Data Server Password

-L

Rep Def List File

-A

Data Server pattern. Only drop rep defs on tables from these data servers.

-C

Database pattern. Only drop rep defs on tables in these databases.

-B

Replication Definition Name Pattern

-N

Mark tables having pattern 'name' [!rs%]

-T

Maximum time (in seconds) allowed for rep defs to drop from the RSSD [60]

-G

Replicate Data Server Name

-H

Replicate Data Server User [-u]

-J

Replicate Data Server Password [-p]

-K

Replicate Data Server RSSD

-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]

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