[Sybase IQ] 데모 설치하기

SYBASE IQ 설치

• Sybase IQ를 설치하고 활용하다보니 너무 가이드도 없고, 커뮤니티도 적어서 누군가에게 도움이 되길 바라며 기록을 한다.

0. 환경

• OS (Linux)

  [root@hd8 ~]# uname -a Linux hd8 3.10.0-1160.11.1.el7.x86_64 #1 SMP Fri Dec 18 16:34:56 UTC 2020 x86_64 x86_64 86_64 GNU/Linux`

• Binary
• SAP 홈페이지(https://www.sap.com/korea/products/sybase-iq-big-data-management.html)
• Request a demo (Software Free Trials) 클릭 후 신청양식 제출을 통해 demo binary 다운
• 본 가이드에서는 "sybase_bin64.tar" 파일 사용
• tar 풀기

1. 설치하기

[root@g1 ~\]# cd /data/sybase/SYBASE\_HOME/

[root@g1 SYBASE\_HOME\]# ls -al


합계 24  
drwxr-xr-x 17 root root 4096 2월 16 14:10 .  
drwxrwxr-x 4 sybase root 91 2월 16 14:02 ..  
drwxrwxr-x 14 root root 170 2월 16 14:11 COCKPIT-4  
drwxrwxr-x 17 root root 262 2월 16 14:11 IQ-16\_1  
lrwxrwxrwx 1 root root 21 2월 16 14:05 IQ.csh -> ./IQ-16\_1/IQ-16\_1.csh  
lrwxrwxrwx 1 root root 20 2월 16 14:05 IQ.sh -> ./IQ-16\_1/IQ-16\_1.sh  
drwxrwxr-x 15 root root 197 2월 16 14:06 OCS-16\_0  
\-rwxr-xr-x 1 root root 1172 2월 16 14:10 SYBASE.csh  
\-rw-r--r-- 1 root root 764 2월 16 14:10 SYBASE.env  
\-rwxr-xr-x 1 root root 1010 2월 16 14:10 SYBASE.sh  
drwxrwxr-x 6 root root 59 2월 16 14:09 SYSAM-2\_0  
drwxr-xr-x 2 root root 24 2월 16 14:04 Sybase\_Install\_Registry  
drwxrwxr-x 59 root root 4096 2월 16 14:05 charsets  
drwxrwxr-x 3 root root 21 2월 16 14:05 collate  
drwxrwxr-x 2 root root 65 2월 16 14:06 config  
drwxrwxr-x 9 root root 162 2월 16 14:09 jConnect-16\_0  
drwxr-xr-x 4 27940 sybase 146 8월 12 2015 jre  
drwxrwxr-x 3 root root 18 2월 16 14:09 jutils-3\_0  
drwxrwxr-x 4 root root 55 2월 16 14:06 locales  
drwxr-xr-x 2 root root 4096 2월 16 14:14 log  
drwxrwxr-x 4 root root 62 2월 16 14:04 shared  
drwxr-xr-x 4 root root 33 2월 16 14:04 sybuninstall

\[root@g1 SYBASE\_HOME\]# cd ./IQ-16\_1/  
\[root@g1 IQ-16\_1\]# ls -al  
합계 36  
drwxrwxr-x 17 root root 262 2월 16 14:11 .  
drwxr-xr-x 17 root root 4096 2월 16 14:10 ..  
drwxrwxr-x 3 root root 26 2월 16 14:08 DBACOCKPIT  
\-rwxr-xr-x 1 root root 1617 2월 16 14:05 IQ-16\_1.csh  
\-rwxr-xr-x 1 root root 1649 2월 16 14:05 IQ-16\_1.sh  
drwxrwxr-x 2 root root 28 2월 16 14:04 Sysam  
drwxrwxr-x 4 root root 4096 2월 17 17:29 bin64  
drwxrwxr-x 4 root root 135 2월 16 14:08 demo  
drwxr-xr-x 2 root root 34 2월 16 14:11 install  
drwxrwxr-x 2 root root 4096 2월 16 14:08 java  
drwxrwxr-x 2 root root 4096 2월 16 14:08 lib64  
drwxrwxrwx 2 root root 4096 2월 21 14:50 logfiles  
drwxrwxr-x 2 root root 156 2월 16 14:08 lsunload  
drwxrwxr-x 2 root root 4096 2월 16 14:08 res  
drwxrwxr-x 5 root root 56 2월 16 14:08 samples  
drwxrwxr-x 2 root root 115 2월 16 14:08 scripts  
drwxrwxr-x 11 root root 122 2월 16 14:08 sdk  
lrwxrwxrwx 1 root root 9 2월 16 14:08 shared -> ../shared  
drwxrwxr-x 2 root root 25 2월 16 14:08 tix  
drwxrwxr-x 2 root root 4096 2월 16 14:08 unload

SYBASE 경로 변수 export

[root@g1 bin64\]# export IQDIR16='/data/sybase/SYBASE\_HOME/IQ-16\_1/'  
[root@g1 bin64\]# export SYBASE='/data/sybase/SYBASE\_HOME/'

# DEMO 구축 shell 파일 - dbisqlc, stop\_iq, start\_iq, dbstop 경로 지정
[root@g1 bin64\]# vi ./mkiqdemo.sh

# IQ DEMO 구축
# mkiqdemo.sh 쉘파일 실행 -dba 계정(User ID) -pwd 비밀번호(6글자 이상)
[root@g1 bin64\]# sh ./mkiqdemo.sh -dba DBA -pwd sybase

Warning: You are running this script as 'root'.  
Sybase strongly recommend that servers not be run with root privileges.

This script will create the iqdemo database in the current  
directory. An existing iqdemo database in this directory  
will need to be shutdown and over-written.

# Y로 진행 (대문자 Y로 답할 것!)
Continue <Y/N>? Y

Checking system ...
The following 1 server(s) are owned by 'root'

## Owner PID Started CPU Time Additional Information

---

1: root 31692 14:58 00:00:02 SVR:bld\_demo\_9000 DB:none PORT:9000  
/data/sybase/SYBASE\_HOME/IQ-16\_1/bin64/iqsrv16 @bld\_demo\_9000.cfg -gc 20 -gl all -ti 4400 -gn 25 -o /data/sybase/SYBASE\_HOME/IQ-16\_1/logfiles/bld\_dem  
\--

Please note that 'stop_iq' will shut down a server completely
without regard for users, connections, or load process status.
For more control, use the 'dbstop' utility, which has options
that control stopping servers based on active connections.

Do you want to stop the server displayed above <Y/N>? Y

Shutting down server (31692) ...  
Checkpointing server (31692) ...  
Server shutdown.

\-rw-r--r-- 1 root root 546 2월 21 14:59 iqdemo.cfg  
\-r--r--r-- 1 root root 4505600 2월 21 14:59 iqdemo.db  
\-rw-r--r-- 1 root root 104857600 2월 21 14:59 iqdemo.iq  
\-rw-r--r-- 1 root root 41542 2월 21 14:59 iqdemo.iqmsg  
\-rw-r--r-- 1 root root 26214400 2월 21 14:59 iqdemo.iqtmp  
\-rw-r--r-- 1 root root 469 2월 21 14:59 iqdemo.lmp  
\-r-------- 1 root root 327680 2월 21 14:59 iqdemo.log  
\-rw-r--r-- 1 root root 104857600 2월 21 14:59 iqdemo\_main.iq

The iqdemo database already exists. Overwrite <Y/N>? Y

Removing current iqdemo database ...  
Removed.

Starting Server ... bld\_demo\_9332

Starting server bld\_demo\_9332 on g1 at port 9332 (02/21 15:01:01)

Run Directory : /data/sybase/SYBASE\_HOME/IQ-16\_1/bin64  
Server Executable : /data/sybase/SYBASE\_HOME/IQ-16\_1/bin64/iqsrv16  
Server Output Log : /data/sybase/SYBASE\_HOME/IQ-16\_1/logfiles/bld\_demo\_9332.0001.srvlog  
Server Version : 16.1.030.1031/sp03  
Open Client Version : N/A  
User Parameters : '@bld\_demo\_9332.cfg'  
Default Parameters : -gc 20 -gl all -ti 4400 -gn 25

I. 02/21 15:01:02.757645 SAP IQ  
I. 02/21 15:01:02.757719 Version 16.1  
I. 02/21 15:01:02.757744 (64bit mode)  
I. 02/21 15:01:02.757776 Copyright 1992-2017 by SAP AG or an SAP affiliate company. All rights reserved  
I. 02/21 15:01:02.757795 Copyright (c) 2018 SAP SE or an SAP affiliate company.  
I. 02/21 15:01:02.757811 All rights reserved.  
I. 02/21 15:01:02.757833 Use of this software is governed by the SAP Software Use Rights Agreement.  
I. 02/21 15:01:02.757854 Refer to [http://www.sap.com/about/agreements.html](http://www.sap.com/about/agreements.html).  
I. 02/21 15:01:02.757869  
I. 02/21 15:01:02.757899 Processors detected: 8 logical processor(s) on 4 core(s) on 1 physical processor(s)  
I. 02/21 15:01:02.757941 This server is licensed to use: all logical processors in the system  
I. 02/21 15:01:02.757964 Processors in use by server: 8 logical processor(s) on 4 core(s) on 1 physical processor(s)  
I. 02/21 15:01:02.757999 Running Linux 3.10.0-1160.11.1.el7.x86\_64 #1 SMP Fri Dec 18 16:34:56 UTC 2020 on X86\_64  
I. 02/21 15:01:02.758040 Server built for X86\_64 processor architecture  
I. 02/21 15:01:02.761191 49720K of memory used for caching  
I. 02/21 15:01:02.761237 Minimum cache size: 49728K, maximum cache size: 262144K  
I. 02/21 15:01:02.761276 Using a maximum page size of 4096 bytes  
I. 02/21 15:01:02.763989 Multiprogramming level: 25  
I. 02/21 15:01:02.764016 Automatic tuning of multiprogramming level is disabled

\=============================================================  
IQ server starting with:  
10 connections ( -gm )  
26 cmd resources ( -iqgovern )  
460 threads ( -iqmt )  
512 Kb thread stack size ( -iqtss )  
235520 Kb thread memory size ( -iqmt \* -iqtss )  
8 IQ number of cpus ( -iqnumbercpus )  
0 MB maximum size of IQMSG file ( -iqmsgsz )  
0 copies of IQMSG file archives ( -iqmsgnum )  
64 MB maximum size of main buffer cache ( -iqmc )  
64 MB maximum size of temp buffer cache ( -iqtc )  
2048 MB maximum size of large memory pool ( -iqlm )  
0 MB maximum size of heap memory ( -iqmem )  
2048 MB maximum size of RLV memory ( -iqrlvmem )  
\=============================================================

I. 02/21 15:01:02.785503 Database server started at Mon Feb 21 2022 15:01  
I. 02/21 15:01:02.786100 Trying to start SharedMemory link ...  
I. 02/21 15:01:02.786343 SharedMemory link started successfully  
I. 02/21 15:01:02.786392 Trying to start TCPIP link ...  
I. 02/21 15:01:02.787082 Starting on port 9332  
I. 02/21 15:01:07.787128 TCPIP link started successfully  
I. 02/21 15:01:07.787546 Now accepting requests  
New process id is 526

Server started successfully

Started.  
Connecting to server via TCPIP ...  
Using: uid=DBA;pwd=sql123;eng=bld\_demo\_9332;dbn=utility\_db;links=tcpip{host=g1;port=9332}

Creating database ...  
Demo database created.

Shutting down server ...  
SQL Anywhere Stop Server Utility Version 17.0.9.1031

\-rw-r--r-- 1 root root 546 2월 21 15:01 iqdemo.cfg  
\-r--r--r-- 1 root root 4505600 2월 21 15:01 iqdemo.db  
\-rw-r--r-- 1 root root 104857600 2월 21 15:01 iqdemo.iq  
\-rw-r--r-- 1 root root 41538 2월 21 15:01 iqdemo.iqmsg  
\-rw-r--r-- 1 root root 26214400 2월 21 15:01 iqdemo.iqtmp  
\-rw-r--r-- 1 root root 469 2월 21 15:01 iqdemo.lmp  
\-r-------- 1 root root 327680 2월 21 15:01 iqdemo.log  
\-rw-r--r-- 1 root root 104857600 2월 21 15:01 iqdemo\_main.iq

# DB 생성 성공!!
Demo database created successfully

# iqdemo.cfg 파일을 통해서 서버 생성
\[root@g1 bin64\]# ./start\_iq @iqdemo.cfg iqdemo.db

Starting server g1\_iqdemo on g1 at port 2638 (02/25 22:23:06)

Run Directory : /home/sybase/SAP/IQ-16\_1/bin64  
Server Executable : /home/sybase/SAP/IQ-16\_1/bin64/iqsrv16  
Server Output Log : /home/sybase/SAP/IQ-16\_1/logfiles/g1\_iqdemo.0001.srvlog  
Server Version : 16.1.030.1031/sp03  
Open Client Version : N/A  
User Parameters : '@iqdemo.cfg' 'iqdemo.db'  
Default Parameters : -ti 4400 -gn 25

I. 02/25 22:23:08.440692 SAP IQ  
I. 02/25 22:23:08.440752 Version 16.1  
I. 02/25 22:23:08.440777 (64bit mode)  
I. 02/25 22:23:08.440806 Copyright 1992-2017 by SAP AG or an SAP affiliate company. All rights reserved  
I. 02/25 22:23:08.440836 Copyright (c) 2018 SAP SE or an SAP affiliate company.  
I. 02/25 22:23:08.440857 All rights reserved.  
I. 02/25 22:23:08.440880 Use of this software is governed by the SAP Software Use Rights Agreement.  
I. 02/25 22:23:08.440904 Refer to [http://www.sap.com/about/agreements.html](http://www.sap.com/about/agreements.html).  
I. 02/25 22:23:08.440925  
I. 02/25 22:23:08.443179 Processors detected: 8 logical processor(s) on 4 core(s) on 1 physical processor(s)  
I. 02/25 22:23:08.443661 This server is licensed to use: all logical processors in the system  
I. 02/25 22:23:08.443693 Processors in use by server: 8 logical processor(s) on 4 core(s) on 1 physical processor(s)  
I. 02/25 22:23:08.444032 Running Linux 3.10.0-1160.11.1.el7.x86\_64 #1 SMP Fri Dec 18 16:34:56 UTC 2020 on X86\_64  
I. 02/25 22:23:08.444070 Server built for X86\_64 processor architecture  
I. 02/25 22:23:08.539513 49720K of memory used for caching  
I. 02/25 22:23:08.539553 Minimum cache size: 49728K, maximum cache size: 262144K  
I. 02/25 22:23:08.539575 Using a maximum page size of 4096 bytes  
I. 02/25 22:23:08.542228 Multiprogramming level: 25  
I. 02/25 22:23:08.542263 Automatic tuning of multiprogramming level is disabled

\=============================================================  
IQ server starting with:  
10 connections ( -gm )  
26 cmd resources ( -iqgovern )  
460 threads ( -iqmt )  
512 Kb thread stack size ( -iqtss )  
235520 Kb thread memory size ( -iqmt \* -iqtss )  
8 IQ number of cpus ( -iqnumbercpus )  
0 MB maximum size of IQMSG file ( -iqmsgsz )  
0 copies of IQMSG file archives ( -iqmsgnum )  
64 MB maximum size of main buffer cache ( -iqmc )  
64 MB maximum size of temp buffer cache ( -iqtc )  
2048 MB maximum size of large memory pool ( -iqlm )  
0 MB maximum size of heap memory ( -iqmem )  
2048 MB maximum size of RLV memory ( -iqrlvmem )  
\=============================================================

I. 02/25 22:23:08.816707 Starting database "iqdemo" (/home/sybase/SAP/IQ-16\_1/bin64/iqdemo.db) at Fri Feb 25 2022 22:23  
I. 02/25 22:23:08.828570 Database recovery in progress  
I. 02/25 22:23:08.828598 Last checkpoint at Tue Feb 22 2022 11:35  
I. 02/25 22:23:08.828643 Checkpoint log...  
I. 02/25 22:23:09.223211 Transaction log: iqdemo.log...  
I. 02/25 22:23:09.299830 Rollback log...  
I. 02/25 22:23:09.327415 Checkpointing...  
I. 02/25 22:23:09.327483 Starting checkpoint of "iqdemo" (iqdemo.db) at Fri Feb 25 2022 22:23  
I. 02/25 22:23:09.482760 Finished checkpoint of "iqdemo" (iqdemo.db) at Fri Feb 25 2022 22:23  
I. 02/25 22:23:09.482800 Recovery complete  
I. 02/25 22:23:09.706122 Update previous log GUID to: 8d62f71a-9372-11ec-8000-ff2b62b1fccc  
Update current log GUID to :f3142ad8-96d4-11ec-8000-c69e869a5e19  
I. 02/25 22:23:09.807556 Database "iqdemo" (iqdemo.db) started at Fri Feb 25 2022 22:23  
I. 02/25 22:23:09.846863 IQ Server g1\_iqdemo.  
I. 02/25 22:23:09.847295 Starting checkpoint of "iqdemo" (iqdemo.db) at Fri Feb 25 2022 22:23  
I. 02/25 22:23:10.024374 Finished checkpoint of "iqdemo" (iqdemo.db) at Fri Feb 25 2022 22:23  
I. 02/25 22:23:10.032852 Database server started at Fri Feb 25 2022 22:23  
I. 02/25 22:23:10.032967 Trying to start SharedMemory link ...  
I. 02/25 22:23:10.033315 SharedMemory link started successfully  
I. 02/25 22:23:10.033364 Trying to start TCPIP link ...  
I. 02/25 22:23:10.033992 Starting on port 2638  
I. 02/25 22:23:15.034120 TCPIP link started successfully  
I. 02/25 22:23:15.056954 Now accepting requests  
New process id is 19425

Server started successfully