Skip to content

How to change the database's db name#

How to change the database's db name#

This section describes how to change the db name of the Altibase database.

Version#

This method is applied to Altibase version 5.3.3 or later.

Notes/Considerations#

Info

To change the DB NAME, the DB must be recreated. When the DB is recreated, the existing data disappears, so when the existing data is restored, the DB data must be exported and backed up.

Change procedure#

(1) DB stop

Stop DB with DB stop command.

$ server stop
-----------------------------------------------------------------  
     Altibase Client Query utility.  
     Release Version 6.5.1.1.1  
     Copyright 2000, ALTIBASE Corporation or its subsidiaries.
     All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = UNIX, SERVER = localhost
Ok..Shutdown Proceeding....


TRANSITION TO PHASE : Shutdown Altibase
  [RP] Finalization : PASS
shutdown immediate success.

(2) Change the DB name of altibase.properties

Change the DB_NAME in the $ALTIBASE_HOME/conf/altibase.properties file to the DB name you want to change.

/* altibase.properties */  
#=================================================================  
## Fixed Properties  
## must not be modified after the DB is created  
#=================================================================  
DB_NAME       =  sdb <--- Replace with the name of the DB you want to change (default: mydb)

(3) Modify server script

Change the default DB name of the db create-part in $ALTIBASE_HOME/bin/server script to the DB name you want to change.

/* $ALTIBASE_HOME/bin/server   script */

......................

'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 sdb INITSIZE=10M noarchivelog character set $2 national character set $3;       <---- Change the default DB name mydb to the DB name you want to change.  
quit  
EOF

(4) Delete existing database

To create a new database, the existing DB must be deleted. To delete the existing DB, delete the $ALTIBASE_HOME/dbs/* and $ALTIBASE_HOME/logs/* files.

shell>  cd $ALTIBASE_HOME

shell> rm dbs/*

shell> rm logs/*

(5) Create a new DB with a new DB name

Create a new DB with the server create command.

$ server create MS949 UTF8
-----------------------------------------------------------------  
     Altibase Client Query utility.  
     Release Version 6.5.1.1.1  
     Copyright 2000, ALTIBASE Corporation or its subsidiaries.  
     All Rights Reserved.  
-----------------------------------------------------------------  
ISQL_CONNECTION = UNIX, SERVER = localhost  
[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)

Creating MMDB FILES     [SUCCESS]

Creating Catalog Tables [SUCCESS]

Creating DRDB FILES     [SUCCESS]

[SM] Rebuilding Indices [Total Count:0]  [SUCCESS]

DB Writing Completed. All Done.

Create success.

(6) Start the DB

Start the DB with the server start command.

$ server start  
-----------------------------------------------------------------  
     Altibase Client Query utility.  
     Release Version 6.5.1.1.1  
     Copyright 2000, ALTIBASE Corporation or its subsidiaries.  
     All Rights Reserved.  
-----------------------------------------------------------------  
ISQL_CONNECTION = UNIX, SERVER = localhost  
[ERR-910FB : Connected to idle instance]  
Connecting to the DB server.... Connected.

TRANSITION TO PHASE : PROCESS

TRANSITION TO PHASE : CONTROL  
........  중량 .....................................

[CM] Listener started : IPC  
  [RP] Initialization : [PASS]

--- STARTUP Process SUCCESS ---

(7) Check the changed database name

After starting the DB, the changed DB name can be checked with the following query.

$ is
-----------------------------------------------------------------  
     Altibase Client Query utility.  
     Release Version 6.5.1.1.1  
     Copyright 2000, ALTIBASE Corporation or its subsidiaries.  
     All Rights Reserved.  
-----------------------------------------------------------------  
ISQL_CONNECTION = TCP, SERVER = localhost, PORT_NO = 20416

iSQL> select db_name from v$database;
DB_NAME                                                                                                                             
------------------------------------------------------------------------------------------------------------------------------------  
sdb                                                                                                                              
1 row selected.  
iSQL>