psCheckDB

Description

     This program writes dbcc checkalloc(database, fix) for all your
specified databases.   It will skip the master database.

Syntax

psCheckDB -Sserver -Uusername -Ppassword -Ddatabase_pattern
-FKorn_script -Llog_file -Mmax_msg_log_file_size
-Ttime_out
-Eemail_address_when_error
-Ooptions

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User's Password

-D

Sybase Database Name Pattern [!tempdb]

-F

Korn Shell script name

-L

Messages Log File. [standard output]

-M

Maximum Size of Log File [1,000,000 bytes]

-E

Email address to send errors when there are errors

-T

Time out

-O

Options

f

Do not fix the allocation chains

x

Execute script immediately [-F is required]

DSQUERY

When -S is not specified.

SYB_USER

When -U is not specified.

SYB_PASS

When -P is not specified.

PS_SYSMSG_FILE

Name of the tool's messages file.