Reference Manual
   CHAPTER 4. Database Administration Utilities     

The REBUILD component

Databases can be unloaded and rebuilt using either of two rebuild components: the Rebuild wizard in Sybase Central or the Rebuild batch or command file, which invokes a series of utilities to rebuild a database.

  Rebuilding a database using the Rebuild wizard in Sybase Central

Sybase Central's Rebuild wizard lets you change the database configuration while rebuilding a database. The configuration settings that can be changed include page size and some database attributes (encryption, tailing blanks, and case sensitivity).

  To rebuild a database:

1. Open the Database Utilities folder in the left panel.

2. Double-click Rebuild Database in the right panel. The Rebuild wizard is displayed.

3. Follow the instructions in the wizard.

  Rebuilding a database using the REBUILD batch or command file

Syntax 

rebuild old-database new-database [dba-password]

See also 

The DBUNLOAD command-line utility

The DBINIT command-line utility

Description 

This Windows NT batch file or UNIX script uses dbunload to rebuild old-database into new-database. This is a simple script, but it helps document and automate the rebuilding process. Both database names should be specified without extensions. An extension of DB will automatically be added.

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.