The REBUILD utility
124
The REBUILD utility
Databases can be rebuilt using the Rebuild batch file, command file, or shell
script, which invokes a series of utilities to rebuild a database, or as part of
the unload process using the Unload an Adaptive Server Anywhere Database
wizard in Sybase Central.
For more information about the Unload an Adaptive Server Anywhere
Database wizard, see "The Unload utility" on page 138.
Rebuilding a database using the rebuild batch or command file
rebuild
old-database
new-database
[
dba-password
]
"The dbunload command-line utility" on page 139
"The dbinit command-line utility" on page 99
"The Interactive SQL utility" on page 106
This batch file, command file, or shell script uses
dbunload
to rebuild old-
database into new-database. This is a simple script, but it helps document
the rebuilding process, and provides a basis for customization. Both database
names should be specified without extensions. An extension of
.db
is
automatically added.
You can use
dbunload
with the -ar command-line option to carry out
unloading and reloading without using the rebuild batch file.
The dba-password must be specified if the password to the DBA user ID in
the old-database is not the initial password SQL.
REBUILD runs the
dbunload
,
dbinit,
and Interactive SQL commands with
the default command line options. If you need different options, you will
need to run the three commands separately.
Syntax
See also
Description
To Next Page
Loading...