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
  
• SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE system procedure
  
• SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT system procedure
  
• 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
  
• SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure
  
• 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
  
• 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
  
• 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
  
• SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure
  
• 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
  
• 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
  
• 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_RELOAD_SECURITY_POLICY system procedure
  
• 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
  
• SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS system procedure
  
• SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING system procedure
  
• SYSCS_UTIL.SYSCS_SET_USER_ACCESS system procedure
  
• SYSCS_UTIL.SYSCS_SET_XPLAIN_MODE system procedure
  
• SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA system procedure
  
• SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE system procedure
  
• 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