Versions Compared

Key

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

...

  • Check DB_NAME in altibase.properties

 

Code Block
themeEmacsDJango
$ 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
themeEmacsDJango
$ 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
themeDJango
$ 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
themeDJango
$ 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
themeDJango
$ 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

...