# Built-in system procedures

Some built-in procedures are not compatible with SQL syntax used by other relational databases. These procedures can only be used with Derby.

- SYSCS_UTIL.SYSCS_BACKUP_DATABASE system procedure
  The SYSCS_UTIL.SYSCS_BACKUP_DATABASE system procedure backs up the database to a specified backup directory.
- SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE system procedure
  The SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE system procedure backs up the database to a specified backup directory and enables the database for log archive mode.
- SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT system procedure
  The SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT system procedure backs up the database to a specified backup directory and enables the database for log archive mode.
- SYSCS_UTIL.SYSCS_BACKUP_DATABASE_NOWAIT system procedure
  The SYSCS_UTIL.SYSCS_BACKUP_DATABASE_NOWAIT system procedure backs up the database to a specified backup directory.
- SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE system procedure
  The SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE system procedure checkpoints the database by flushing all cached data to disk.
- SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure
  Use the SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure to reclaim unused, allocated space in a table and its indexes.
- SYSCS_UTIL.SYSCS_CREATE_USER system procedure
  The SYSCS_UTIL.SYSCS_CREATE_USER system procedure adds a new user account to a database.
- SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE system procedure
  The SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE system procedure disables the log archive mode and deletes any existing online archived log files if the DELETE_ARCHIVED_LOG_FILES input parameter is non-zero.
- SYSCS_UTIL.SYSCS_DROP_STATISTICS system procedure
  The SYSCS_UTIL.SYSCS_DROP_STATISTICS system procedure drops all existing cardinality statistics for the index that you specify or for all of the indexes on a table.
- SYSCS_UTIL.SYSCS_DROP_USER system procedure
  The SYSCS_UTIL.SYSCS_DROP_USER system procedure removes a user account from a database.
- SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure
  The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure removes as many compiled statements (plans) as possible from the database-wide statement cache.
- SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure
  The SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure exports the results of a SELECT statement to an operating system file.
- SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system procedure
  Use the SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system procedure to export the result of a SELECT statement to a main export file, and place the LOB data into a separate export file. A reference to the location of the LOB data is placed in the LOB column in the main export file.
- SYSCS_UTIL.SYSCS_EXPORT_TABLE system procedure
  The SYSCS_UTIL.SYSCS_EXPORT_TABLE system procedure exports all of the data from a table to an operating system file.
- SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE system procedure
  Use the SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE system procedure to export all the data from a table, and place the LOB data into a separate export file. A reference to the location of the LOB data is placed in the LOB column in the main export file.
- SYSCS_UTIL.SYSCS_FREEZE_DATABASE system procedure
  The SYSCS_UTIL.SYSCS_FREEZE_DATABASE system procedure temporarily freezes the database for backup.
- SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure
  The SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure imports data to a subset of columns in a table. You choose the subset of columns by specifying insert columns. This procedure is also used to import a subset of column data from a file by specifying column indexes.
- SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure
  The SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure supports all functionalities of SYSCS_UTIL.SYSCS_IMPORT_DATA with the additional feature to skip column headers in the input file and recognize columns in the input file by name that are parsed to the COLUMNINDEXES argument.
- SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedure
  Use the SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedure to import data to a subset of columns in a table, where the LOB data is stored in a separate file. The main import file contains all of the other data and a reference to the location of the LOB data.
- SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure
  The SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure imports data from an input file into all of the columns of a table. If the table receiving the imported data already contains data, you can either replace or append to the existing data.
- SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure
  The SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure supports all functionalities of SYSCS_UTIL.SYSCS_IMPORT_TABLE with the additional feature to skip column headers in the input file.
- SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure
  Use the SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure to import data to a table, where the LOB data is stored in a separate file. The main import file contains all of the other data and a reference to the location of the LOB data.
- SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE system procedure
  Use the SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE system procedure to reclaim unused, allocated space in a table and its indexes.
- SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS system procedure
  The SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS system procedure invalidates all stored prepared statements (that is, all statements in the SYSSTATEMENTS system table).
- SYSCS_UTIL.SYSCS_MODIFY_PASSWORD system procedure
  The SYSCS_UTIL.SYSCS_MODIFY_PASSWORD system procedure is called by a user to change that user's own password.
- SYSCS_UTIL.SYSCS_REGISTER_TOOL system procedure
  The SYSCS_UTIL.SYSCS_REGISTER_TOOL system procedure loads and unloads optional tools packages.
- SYSCS_UTIL.SYSCS_RESET_PASSWORD system procedure
  The SYSCS_UTIL.SYSCS_RESET_PASSWORD system procedure resets a password that has expired or has been forgotten.
- SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY system procedure
  Use the SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY system procedure to set or delete the value of a property of the database on the current connection.
- SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS system procedure
  The SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS system procedure turns a connection's runtime statistics on or off.
- SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING system procedure
  Statistics timing is an attribute associated with a connection that you turn on and off by using the SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING system procedure.
- SYSCS_UTIL.SYSCS_SET_USER_ACCESS system procedure
  The SYSCS_UTIL.SYSCS_SET_USER_ACCESS system procedure sets the connection access permission for the user specified.
- SYSCS_UTIL.SYSCS_SET_XPLAIN_MODE system procedure
  When runtime statistics are being captured, you can control the mode of processing by using the SYSCS_UTIL.SYSCS_SET_XPLAIN_MODE procedure.
- SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA system procedure
  The SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA system procedure allows you to request XPLAIN style processing of runtime statistics.
- SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE system procedure
  The SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE system procedure unfreezes a database after backup.
- SYSCS_UTIL.SYSCS_UPDATE_STATISTICS system procedure
  The SYSCS_UTIL.SYSCS_UPDATE_STATISTICS system procedure updates the cardinality statistics, or creates the statistics if they do not exist, for the index that you specify or for all of the indexes on a table.
- System procedures for storing jar files in a database
  SQLJ.INSTALL_JAR, SQLJ.REMOVE_JAR, and SQLJ.REPLACE_JAR are a set of procedures in the SQLJ schema that allow you to store jar files in a database.

Parent topic: SQL language reference
Related concepts
SQL identifiers
Statements
Built-in system functions
Data types
Related reference
Capitalization and special characters
SQL clauses
SQL expressions
JOIN operations
SQL queries
Built-in functions
SYSCS_DIAG diagnostic tables and functions