[SUNDB] Install SUNDB (SUNDB 설치)

1. Setup Kernel Parameters related with Shared Memory (Shared Memory 관련 커널 파라미터 수정)

SUNDB architecture is not multi-thread but multi-process based on shared memory.
Therefore, you must kernel parameters related with shared memory.
(SUNDB는 multi-thread 구조가 아닌 shared memory 기반의 Multi-process 구조로 되어 있다. 그러므로 shared memory 관련된 커널 파라미터를 수정해줘야한다.)

1.1. Check Parameters

#> ipcs -l

1.2. Change parameters permanently and apply it (파라미터 변경 및 적용)

#> vi /etc/sysctl.conf

# shared memory
kernel.shmmax = 34359738368
kernel.shmall = 8388608
kernel.shmmni = 4096
# semaphore
kernel.sem = 250 32000 100 128

#> sysctl -p

2. Install DBMS

2.1. Uncompressed install file (설치파일 압축해제)

#> cd [INSTALL_DIRECTORY]
#> tar xvf [INSTALL_FILE]

2.2. Setup environment variables (환경변수 설정)

#> vi ~/.bashrc

# for SUNDB
export SUNDB_HOME=[INSTALLED_HOME_DIRECTROY]
export SUNDB_DATA=[INSTALLED_DATA_DIRECTROY]
export PATH=$SUNDB_HOME/bin:$PATH
export LD_LIBRARY=$SUNDB_HOME/lib:$LD_LIBRARY_PATH

#>. ~/.bashrc

3. Create Database (DB 생성)

3.1. create DB (DB 생성)

#> gcreatedb --help
#> gcreatedb --db_name="[DB_NAME]" --db_comment="[DB_COMMENT]" --timezone="[{+/-}{TZH:TZM}]" --character_set="[SQL_ASCII | UTF8 | UHC | GB18030] --char_length_units="[OCTETS | CHARACTERS]"

3.2. Open DB for creating dictionary schema (Dictionary Schema 생성을 위한 DB open)

#> gsql --as sysdba

gSQL> \startup open

3.3. Create dictionary schema (Dictionary Schema 생성)

#> gsql --as sysdba --import $SUNDB_HOME/admin/DictionarySchema.sql
#> gsql --as sysdba --import $SUNDB_HOME/admin/InformationSchema.sql
#> gsql --as sysdba --import $SUNDB_HOME/admin/PerformanceViewSchema.sql

4. Startup DB (DB 구동)

4.1. Startup DB (DB 구동)

#> gsql --as sysdb

gSQL> \startup nomount
gSQL> \alter system mount database;
gSQL> \alter system open database;

4.2. Startup listener (리스너 구동)

#> glsnr --start