TimesTen 설정

TimesTen 다운로드

http://www.oracle.com/technology/software/products/timesten/index.html

 

DATABASE 생성

 

설치한 TimesTen 폴더에 있는 odbc.ini 파일을 home에 복사한다.

cp /home/timesten/TimesTen/tt1121/info/sys.odbc.ini ../../../.odbc.ini

 

.odbc.ini 파일을 연다.

해당 위치를 찾아서 아래의 형식으로 필요한 정보들을 추가한다.

#####################################################################
#
# New data source definitions can be added below.
#
#####################################################################

 

[mydb] -- DATABASE 이름
Driver=/home/timesten/TimesTen/tt1121/lib/libtten.so
DataStore=/tmp/mydb -- DATABASE DATA(LOG) 가 저장될 디스크 위치
PermSize=1024 -- MEMORY DATABASE SIZE (MB)
TempSize=512 -- MEMORY TEMP SIZE (MB)

PLSQL=1

DatabaseCharacterSet=AL32UTF8

 

TimesTen 서버 실행

[timesten@ljh8324-skku ~]$ ttdaemonadmin -start
TimesTen Daemon startup OK.

 

isql 실행

[timesten@ljh8324-skku ~]$ ttisql

Copyright (c) 1996-2009, Oracle.  All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.

Command>

 

Target DATABASE 실행

Command> connect mydb;
Connection successful: DSN=mydb;UID=timesten;DataStore=/tmp/mydb;DatabaseCharacterSet=AL32UTF8;

ConnectionCharacterSet=US7ASCII;DRIVER=/home/timesten/TimesTen/tt1121/lib/libtten.so;

PermSize=1024;TempSize=512;TypeMode=0;
(Default setting AutoCommit=1)
Command>