LucidDbSysRoot SHUTDOWN DATABASE

Syntax

CALL SYS_ROOT.SHUTDOWN_DATABASE( kill_sessions , jvm_shutdown_delay_millis )

Purpose

Shuts down the LucidDB database, and optionally kills the entire JVM in which it is running by calling System.exit.

Parameters

• kill_sessions: [BOOLEAN] if true, automatically kill any open sessions; if false, abort the shutdown if any sessions remain (other than the one invoking this procedure)
• jvm_shutdown_delay_millis: [BIGINT] number of milliseconds to delay before calling System.exit, or -1 to leave the JVM running

Example

-- kill sessions and shut down JVM after 5 seconds
call sys_root.shutdown_database(true, 5000);

-- do not kill other sessions or JVM
call sys_root.shutdown_database(false, -1);