Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


This section describes how to create a database of versions supported according to Altibase's End of Service (EOS) policy. As for this document, the latest Altibase version is 'Altibase ver. 7' and 'Altibase ver 6 or below' are for EOS. Altibase cannot be operated until the database is created, so the database must be created as follows before starting the Altibase.


  • Check DB_NAME in


  • In the case of DB_NAME, it is determined when the database is created.
  • In order to change, the database must be recreated, so migration must be performed.
  • Therefore, be cautious when creating a database for the first time.


How to drop a database


The user can drop the database by deleting all Altiabse configuration files.

Check the files to be dropped


  • To check whether the database is dropped normally, check before dropping the data files and log files to be deleted.
Code Block
iSQL> select name, checkpoint_path from v$tablespaces a, v$mem_tablespace_checkpoint_paths b where = b.space_id; 
iSQL> select, from v$tablespaces a, v$datafiles b where = b.spaceid;
$ cat $ALTIBASE_HOME/conf/ | grep ^LOG | grep DIR

Dropping a database


  • After Altibase is shut down, the database is dropped in the process stage.
Code Block
$ isql -u sys -p manager -sysdba...
iSQL(sysdba)> startup process;
Connecting to the DB server.... Connected.
Command executed successfully.
iSQL(sysdba)> drop database mydb;
Checking Log Anchor files
[Ok] /home/altibase/altibase_home/logs/loganchor0 Exist.
[Ok] /home/altibase/altibase_home/logs/loganchor1 Exist.
[Ok] /home/altibase/altibase_home/logs/loganchor2 Exist.
Removing DB files
Removing Log files
Removing Log Anchor files
Drop success.
iSQL(sysdba)> exit