psCopyIndices

Description

     This program copies indices from one schema to another.
The program copies both constraint and non-constraint indices.
By default, only the non-clustered indices are copied.  If you
want the clustered indices copied as well, specify the -Oc option.
     You can copy the indices to different segments with the -T
option.  With -T you specify the name of an input text file.  The
the text file contains a table with 3 columns:
Table        Segment      Non-clustered Index Segment
You can generate this file by running psGenerateSegmentMap.  An
example segment map file is in:
/disk2/ceccareb/PS/dbaccess/demo/psGenerateSegmentMap
     If you do not put an entry for the segment column, I
assume you want the segment specified by the -X option.  If you
don't specify an entry for the non-clustered index segment, I
assume you want the segment specified by the -x (lower case)
option.  If you don't specify -X or -x, the target segments are
the same as the source segments.

Syntax

psCopyIndices -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname
-starget_server -utarget_user -ptarget_pass -dtarget_db -wtarget_owner
-Tsegment_map -Xtable_segment -xnon-clustered_segment -Ifill_factor
-Rresults_file -Mresults_file_max_size
-Ooptions

-S

Source Sybase Server Name

-U

Source Sybase User Name

-P

Source Sybase User Password

-D

Source Sybase Database

-W

Copy indices of tables belonging to 'owner' only [-U]

-N

Copy indices of tables having pattern 'name' [!rs%]

-s

Target Sybase Server Name [-S]

-u

Target Sybase User Name [-U]

-p

Target Sybase User Password [-P]

-d

Target Sybase Database [-D]

-w

Make target indices owned by 'owner' [-W]

-T

Text file containing a table to segment map

-X

Target table/clustered index segment

-x

Target non-clustered index segment

-I

Index fill factor

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

-O

Options

c

Copy clustered indices too

t

Do NOT check for existence of target 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