CUBRID Manager Database Components Job

Backup Automation

When you login to the database, you can view Backup plan under Job automation in the navigation tree. The Add Backup Plan and Auto Backup Logs menus will appear when you right-click Backup plan.

If you want to execute a backup periodically with the CUBRID Manager, configure the values of Add Backup Plan. The DBA can configure the backup automation while the Manager server is running. It is not affected by whether the database is running or not. That is, backup automation is executed only when the Manager server is running.

• Backup ID : Enter the name of the backup job. The backup ID must be unique in the database because multiple backup plans may exist in the same database.
• Backup level : You can choose from 0, 1, and 2. Level0 is a full backup. Level1 is the first incremental backup that backs up changes made only after Level0 backup. Level2 is the second incremental backup that backs up changes made only after the Level1 backup.
• Backup path : Specifies the directory of the backup volume.
• Period type : You can select a backup period from options of Monthly, Weekly, Daily and A specific day.
• Period detail : You can set details for the period type you selected.
• Backup hour : Enter the time when the automated backup is to be executed. You must enter the time in hour and minute.
• Options : You can specify an option for backup. For more information, see "Database Backup" in the CUBRID online manual.
• • Store old backup file : This option saves the current original backup volume file of the database in database_directory/backupold directory.
  • Delete archive volumes : An option that deletes archive log volumes after backup. When this option is selected while the database is set to master server in the replication environment, volumes do not affect the replication will be deleted automatically.
  • Update statistics information : Updates statistics information after backup.
  • Checking database consistency : Checks database consistency during backup.
  • Use compress : Uses compression during backup.
  • Number thread : Specifies the number of threads to be used concurrently during backup. It is recommended to configure the maximum number of threads to be the same as the number of CPUs. The default value is 0. If it is set to the default value, the number of threads is determined automatically by the system.
• Online backup : Automated backup is executed only when the database is running. If the database stopped, only error logs are recorded without backing up the database.
• Offline backup : Automated backup is executed only when the database stopped running. Forces the database to shut down if it is currently running, performs an automated backup, and then restarts the database.

Auto Backup Log

Provides the error logs created during backup automation.

Query Automation

When you login to the database, you can view Query plan under Job automation in the navigation tree. The Add Query Plan and Auto Query Logs menus will appear when you right-click Query plan.

If you want to execute a backup periodically with the CUBRID Manager, configure the values of Add Query Plan. The DBA can configure the backup automation while the Manager server is running. It is not affected by whether the database is running or not. That is, backup automation is executed only when the Manager server is running.

• Query Plan ID : Enter the name of the query job. The query plan ID must be unique in the database because multiple query plans may exist in the same database.
• User name/password : Enter the user name, which will execute the registered query automatically,  and its password. If you enter wrong information, the query is not automatically executed. Therefore, you must change the user information in the Edit Query Plan in case of password change.
• Period type : You can select a query automation period from options of Monthly, Weekly, Daily and A specific day.
• Period detail : You can set details for the period type you selected.
• Query hour : Enter the time when the query is to be executed automatically. You must enter the time in hour and minute.
• Query Statement : Enter the query statement to be executed automatically. Note that the registered query is executed automatically at the specified time, but the execution results are not recorded.
• Check Query : Check query errors before registering the auto-executed query statement. It determines whether it is an error or not by creating query plan it does not actually execute the query. It is working like executing optimization level 514 in the CSQL Interpreter.

Auto Query Log

You can view a log about queries that are automatically executed in the Auto Query Logs. Information such as a database, user ID, query ID, query hour, and error code (success : 0, failure : -1) is recorded.