Function Shuts down the specified database if you
specify a databaseName. (Reconnecting to the database reboots the database.)
For a database for which authentication and SQL authorization are both
enabled, only the
database owner
can perform shutdown of that database.
Please see "Enabling user authentication"
and "Setting the SQL standard authorization mode"
in the
for more information.
Shuts
down the entire system
if and only if you do not specify a databaseName.
When you are
shutting down a single database, it lets perform
a final checkpoint on the database.
When you are shutting down a system,
it lets perform a
final checkpoint on all system databases, deregister the JDBC driver, and
shut down within the JVM before the JVM exits. A successful shutdown always
results in an SQLException indicating that has
shut down and that there is no connection. Once is
shut down, you can restart it by reloading the driver. For details on restarting , see
"Shutting down the system" in the .
Checkpointing means
writing all data and transaction information to disk so that no recovery needs
to be performed at the next connection.
Used to shut down the entire
system only when it is embedded in an application. Any request to
the DriverManager with a shutdown=true attribute raises an exception.
Combining with other attributes
This attribute may be combined with the
deregister=true
attribute.
When you shut down a database, if authentication is turned on, you must
specify this attribute in conjunction with the user=userName and
password=userPassword
attributes. If both authentication and SQL authorization are turned on, the user
must be the database owner.
When you shut down the
system, if both
authentication and SQL authorization are turned on, you must specify this
attribute in conjunction with the user=userName and
password=userPassword
attributes.