...
- Check DB_NAME in altibase.properties
| Code Block | ||
|---|---|---|
| ||
$ cat $ALTIBASE_HOME/conf/altibase.properties | grep DB_NAME DB_NAME = mydb |
- If DB_NAME is not mydb (default), the server file must be changed.
(Change mydb in create database mydb command to DB_NAME)
| Code Block | ||
|---|---|---|
| ||
$ vi $ALTIBASE_HOME/bin/server ... startup process; create database mydb INITSIZE=10M noarchivelog character set $2 national character set $3; quit EOF ... |
- Create a database.
(server create 'database charset' 'national charset')
| Code Block | ||
|---|---|---|
| ||
$ server create MS949 UTF16 ----------------------------------------------------------------- Altibase Client Query utility. Release Version 6.1.1.3.1 Copyright 2000, ALTIBASE Corporation or its subsidiaries. All Rights Reserved. ----------------------------------------------------------------- ISQL_CONNECTION = UNIX, SERVER = localhost, PORT_NO = 20300 [ERR-910FB : Connected to idle instance] Connecting to the DB server.... Connected. TRANSITION TO PHASE : PROCESS Command executed successfully. DB Info (Page Size = 32768) (Page Count = 257) (Total DB Size = 8421376) (DB File Size = 1073741824) ... |
- Or, the user can create a database as follows.
| Code Block | ||
|---|---|---|
| ||
$ isql -u sys -p manager -sysdba... iSQL(sysdba)> startup process ... iSQL(sysdba)> create database mydb INITSIZE=10M noarchivelog character set MS949 national character set UTF16; ... iSQL(sysdba)> exit |
...
- The archive log mode can be set at the control stage.
- Therefore, in order to change from No Archive log mode to Archive log mode, the user must shut down Altibase and enter the control stage during the startup process.
- In the archive log mode, the archive log file requires user management because Altibase only replicates the log file to the designated archive log file directory and does not delete it arbitrarily.
- It is necessary to secure the archive log file directory space in consideration of the backup cycle and the number of log files created within that cycle.
| Code Block | ||
|---|---|---|
| ||
$ server stop $ isql -u sys -p manager -sysdba ... iSQL(sysdba)> startup control; ... iSQL(sysdba)> alter database archivelog; Alter success. iSQL(sysdba)> startup service; ... Command executed successfully. iSQL(sysdba)> exit |
...