Skip to end of metadata
Go to start of metadata

Contents


Up to version 5.3.3 or earlier, the DB must be manually created.

The following types of tasks can be performed by executing the server command, and the DB can be created with the server create command.

Usage: server { start | stop | kill | status | create db_charset national_charset | restart }

$server create MS949 UTF8

When the first DB is created, the DB NAME is set to mydb, and DB_NAME can be changed in altibase.properties.

#=================================================================

# Fixed Properties # should not be modified after createdb

#=================================================================

DB_NAME       =  mydb <-- change the DB name

MEM_DB_DIR    =  ?/dbs

MEM_DB_DIR    =  ?/dbs

DEFAULT_DISK_DB_DIR = ?/dbs

When performing server craete after changing DB_NAME, the following error occurs.

$server create MS949 UTF8

Connecting to the DB server... Connected.
TRANSITION TO PHASE : PROCESS
Command executed successfully.
FAILURE of createdb.
Invalid Database Name. Check the properties and retry.
[ERR-91015 : Communication failure.]

Solution


This occurs because the DB name is mydb in the $ALTIBASE_HOME/bin/server script file.

'create')
if [ $# = 3 ]; then
    rm -f live-altibase.txt;
    ${ISQL}  << EOF > /dev/null
spool  live-altibase.txt;
EOF
    if [ -f live-altibase.txt ]; then
        echo " server is running !!!! \n "
        echo " you must shutdown first before server create "
        rm -f live-altibase.txt;
    else
            ${ADMIN} << EOF
startup process;
create database mydb INITSIZE=10M noarchivelog character set $2 national character set $3;
quit
EOF

Create the DB after making the same change as DB_NAME changed in altibase.properties.

 

  • No labels