Sybase 12.4.2 manual Utility database

The utility database

The date and time of the software build appears in the version string in ISO datetime format: YYYY-MM-DD hh:mm:ss where

YYYY

MM

DD

hh

mm

ss

4-digit year

2-digit month number (0-12)

2-digit day of month number (0-31)

2-digit numbmer of complete hours that have passed since midnight (00-23)

2-digit number of complete minutes that have passed since the start of the hour (00-59)

2-digit number of complete seconds that have passed since the start of the minute (00-59)

The message log continues to exist until you drop the database. If your message log ever becomes too large, you can archive it while no users are connected to the database, and then create a new, empty dbname.iqmsg file before allowing another user to connect.

The utility database

The utility database is essentially a database that never holds data. The database server uses it at times when it needs a database to connect to, but either no real database exists, or none should be running. Adaptive Server IQ installation creates the utility database automatically.

Be sure you do not delete this database. You need it to do any of these things:

•Start the database server using the START ENGINE command with no database specified

•Create or drop a database when you have no other database to connect to

•Start the database server or connect to a database when any other databases you have are either corrupt or unavailable due to media failure

•Restore a database

By default, the utility database has the user ID dba and the password sql. You can change these to other values during installation, or later by editing the connection parameters in the util_db.ini file in your executable directory.

18