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 altibase.properties
- 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.
iSQL> select name, checkpoint_path from v$tablespaces a, v$mem_tablespace_checkpoint_paths b where a.id = b.space_id; iSQL> select a.name, b.name from v$tablespaces a, v$datafiles b where a.id = b.spaceid; $ cat $ALTIBASE_HOME/conf/altibase.properties | grep ^LOG | grep DIR
Dropping a database
- After Altibase is shut down, the database is dropped in the process stage.
$ isql -u sys -p manager -sysdba... iSQL(sysdba)> startup process; Connecting to the DB server.... Connected. TRANSITION TO PHASE : PROCESS 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