psGenerateSubscriptions

Description

   This program generates subscriptions by using replication definitions.
It also generates the code to activate and validate the subscriptions.  If
you do not use -Oa or -On, this program assumes you are doing bulk
materialization.
   If you are doing bulk materialization, you have the option to not validate
the subscriptions after they are activated (-Ov).  If you specify a -V option,
this program will produce a separate Korn shell script which just validates
the subscriptions

Syntax

psGenerateSubscriptions
-Spds -Upds_user -Ppds_password -Dpds_rssd_database
-Arep_def_ds_pattern -Crep_def_db_pattern -Brep_def_name -Ntable_name
-sRDS -uRSD_user -pRDS_password -dRDS_target_database
-Grrs -Hrrs_user -Jrrs_password
-Lsubs_list -Fkorn_script -Vvalidation_korn_script
-Rresults_file -Mmax_init_results_size
-Ooptions
-Qargument_input_file

-S

Data Server Name

-U

Data Server User

-P

Data Server Password

-D

RSSD Database Name

-A

Primary Replication Server Name Pattern [%]

-B

Replication Definition Name Pattern [%]

-C

Data Server Name Pattern [%]

-c

Database Name Pattern [%]

-N

Table name pattern 'name' [!rs%]

-s

Replicate Data Server [-S]

-u

Replicate Data Server Username [-U]

-p

Replicate Data Server Password [-P]

-d

Replicate Target Database [-D]

-G

Replicate Replication Server

-H

Replicate Replication Server Username [-u]

-J

Replicate Replication Server Password [-p]

-T

Maximum Time for Subscription To Reach State [60] seconds

-L

List of Subscriptions File (for input to psCheckSubscriptions)

-F

Korn Shell to Create Subscriptions [standard output]

-V

Korn Shell To Validate Subscriptions [appended to -F]

-R

psSQL Results File [standard output]

-M

psSQL Initial Maximum Size of Results File [0]

-Q

Argument Input File

-O

Options

n

Non-atomic Materialization

s

Activate with Suspension

r

Activate with Suspension at Replicate Only

v

Do NOT validate

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