ASA Database Administration Guide
Database Administration Utilities
The Upgrade utility
Upgrading a database using the dbupgrad command-line utility
Connection parameters (-c) For a description of the connection parameters, see Connection parameters. The user ID must have DBA authority.
For example, the following command upgrades a database called sample40 to a version 9.0 format, connecting as user DBA with password SQL:
dbupgrad -c "uid=DBA;pwd=SQL;dbf=c:\wsql40\sample40.db"
The dbupgrad utility must be run by a user with DBA authority.
Do not install Sybase jConnect support (-i) If you wish to use the Sybase jConnect JDBC driver to access system catalog information, you need to install jConnect support. Use this option if you wish to exclude the jConnect system objects. You can still use JDBC, as long as you do not access system information. If you want, you can add Sybase jConnect support later using Sybase Central.
For more information, see Installing jConnect system objects into a database.
Do not install runtime Java classes (-j) If you do not intend to use Java classes, you can specify either no Java option, or the -j option to avoid including these classes in the database.
The runtime classes add several megabytes to the size of a database. If you do not intend to use Java classes, you can specify the -j option to avoid including these classes in the upgraded database. If you want, you can add Sybase runtime Java classes later using Sybase Central or ALTER DATABASE.
For more information, see Java-enabling a database.
Install runtime Java classes (-ja) Add Java in the database to the upgraded database. Specifying -ja installs version 1.3 of the JDK into the database.
Java in the database is a separately-licensable component. These classes are installed during upgrade only if you have installed the Java-in-the-database option or if the Java classes were in use in the database being upgraded.
The runtime classes add several megabytes to the size of a database, so if you do not intend to use Java classes, you can omit the -ja option to avoid installing them.
You can add Sybase runtime Java classes later using the Upgrade Wizard, or the ALTER DATABASE statement.
For more information, see Java-enabling a database.
Remove runtime Java classes (-jr) Remove Java in the database from the upgraded database.
Install support for the named version of the JDK (-jdk) If you want to install a version of Java, use the -jdk option followed by the version number. Valid values are 1.1.8, and 1.3.
For example, the following command creates a database that supports JDK 1.1.8 applications in the database.
dbupgrad -jdk 1.1.8 java2.db
The -jdk option implies the -ja option.
The runtime classes add several megabytes to the size of a database, so if you do not intend to use Java classes, you can omit the -jdk option to avoid installing them.
You can add Sybase runtime Java classes later using the Upgrade Wizard, or the ALTER DATABASE statement.
For more information, see Java-enabling a database.
Log output messages to file (-o) Write output messages to the named file.
Operate quietly (-q) Do not display output messages. This option is available only when you run this utility from the command prompt.