sybadmin

dbcc_all.sh was modified such that the -daily
parameter was changed to -extra. The order of the
<normal> and <extra> commands in
"dbcc.<server>.cfg" configuration file was
changed. The bcpout.sh script was added, which
allows you to make "bcp out" for multiple tables
in one command. Sample configuration files are now
included in the archive (in the "etc"
subdirectory).

The target directory was changed to avoid the
conflicts that can sometimes occur between dump
processes while accessing $SYBADMIN/dump/work.
Now, when "dumpdb_all.sh" or "dumptran_all.sh" are
called, a unique directory is created and used for
dumps. The default target directory for
"dumpdb.sh" and "dumptran.sh" has not changed.

A new script, "updatestats_all.sh", was added:
update statistics for databases/tables specified
in config file. "dumpdb.sh" now adds "create/alter
database for load" commands in the
"load_database.sql" script for proper database
fragments creation.

An updatestats.sh script was added, which
updates statistics on a given database or
tables. The log can now be truncated when
dumptran.sh is started from a terminal.

This release adds support for server-specific configuration files for
"*_all.sh" scripts, to allow different dump/dbcc behavior for each
server.