psDropSubscriptions

Description

   This program creates a script which drops subscriptions.  The script
first logs into the Replicate Replication Server and issues drop subscription
commands.  Afterwards, it calls psCheckSubscriptions to make sure they are
dropped.

Syntax

psDropSubscriptions
-Srds -Urds_user -Prds_password
-Lsubscription_list_file
-Nsubscription_name_pattern -Brep_def_name_pattern -Drds_database_pattern
-Apds_pattern -Cprimary_db -Tprimary_table_name_pattern
-sPDS_RSSD -uPDS_RSSD_user -pPDS_RSSD_password -dPDS_RSSD_database
-Grrs -Hrrs_user -Jrrs_password
-Fkorn_script -Rresults_file -Mmax_init_results_size
-Ooptions
-Qargument_input_file

-S

Data Server Name

-U

Data Server User

-P

Data Server Password

-L

Subscription List File

-N

Subscription Name Pattern [%]

-D

Replicate Database Name Pattern [%]

-B

Replication Definition Name Pattern [%]

-A

Primary Data Server Name Pattern [%]

-C

Primary Database Name Pattern [%]

-T

Primary Table name pattern 'name' [!rs%]

-s

Data Server [-S]

-u

Data Server Username [-U]

-p

Data Server Password [-P]

-d

Primary RSSD Database [-D]

-G

Replicate Replication Server

-H

Replicate Replication Server Username [-u]

-J

Replicate Replication Server Password [-p]

-t

Maximum Time for Subscription To Dematerialize and Drop [60] seconds

-F

Korn Shell to Drop Subscriptions [standard output]

-R

psSQL Results File [standard output]

-M

psSQL Initial Maximum Size of Results File [0]

-Q

Argument Input File

-O

Options

s

Purge with suspension

r

Purge with Suspension at Active Replicate Only

i

Purge Incrementally

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