The utility database – Sybase 12.4.2 User Manual

Page 38

Advertising
background image

The utility database

18

The date and time of the software build appears in the version string in ISO
datetime format:

YYYY-MM-DD hh:mm:ss

where

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.

YYYY

4-digit year

MM

2-digit month number (0-12)

DD

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

hh

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

mm

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

ss

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

Advertising