LucidDbSystemProcedures

Overview

This page is an index for LucidDB system-management routines defined in the SYS_ROOT schema. For application-level routines, some of which may also be useful for management purposes, see AppLib.

Kill Session/Statement

• KILL_SESSION
• KILL_STATEMENT
• KILL_STATEMENT_MATCH
• SHUTDOWN_DATABASE

Export

• EXPORT_CATALOG_XMI
• EXPORT_SCHEMA_TO_FILE
• EXPORT_QUERY_TO_FILE

Backup/Restore

• BACKUP_DATABASE
• BACKUP_DATABASE_IF_SPACE_AVAILABLE
• RESTORE_DATABASE

SQL/MED

• TEST_DATA_SERVER
• TEST_ALL_SERVERS_FOR_WRAPPER

DDL Generation

• GENERATE_DDL_FOR...

Misc

• FLUSH_CODE_CACHE
• GET_CURRENT_SESSIONID
• RETRIEVE_REPOSITORY_LOB_TEXT