Transcript Informix User's Guide (3rd Edition)

INFORMIX USER’S GUIDE
IBM Informix Dynamic Server
Linux 설치 안내서 v.10
Ⅰ.
Ⅱ.
Ⅲ.
Ⅳ.
Ⅴ.
Ⅵ.
Ⅵ.
IBM Informix 제품 정보
참고 자료 및 SITE
OS별 INFORMIX Dynamic Server 지원 정보
IDS 설치 사전 준비
IDS 설치 ( GUI 모드 )
IDS 설치 ( Text 모드 )
Informix 데이타베이스 초기화
Ⅶ. Informix 데이타베이스 초기화
Ⅷ. Install & Initialize Error
Ⅸ. 첨부
made by
mjo
INFORMIX FOR LINUX
INFORMIX FOR LINUX
Ⅰ. IBM Informix 제품 정보
1. 본 안내서에서는 Informix Dynamic Server(이하 ‘IDS’) Version10 UC6 (32bit)
정식 제품을 설치 할 것이다.
설치 파일 정식명 :
Informix Dynamic Server V10.00.UC6 Red Hat Enterprise Linux AS, WS, and ES SUSE 10 English.tar
2. 제품 구하기
Trial version :
1) http://www-07.ibm.com/software/kr/data/informix/ 접속
2) 우측 메뉴 : 트라이얼 및 베타 (영문)
3) Trials and demos : View by product 클릭
4) “ I ” 클릭
5) “ Informix Dynamic Server “ 클릭
6) SIGN ON (필요시 회원가입)
7) OS 별 , IDS VERSION 별 DOWNLOAD
정식 제품 요청:
1) http://www-07.ibm.com/software/kr/data/informix/ 접속 > 전화신청
2) 한국 IBM INFORMIX 영업문의 : 02-3781-5600
3. INFORMIX 관련 Site
1) INFOMRIX 사용자 게시판 :
http://www-903.ibm.com/kr/bbs/board_list.jsp?bbs=8
2) Informix Certified Professional Program :
http://www.ibm.com/kr/informix/education/icpp/certify/certify.html
3) International User Group : http://www.iiug.org/
4) Informix Online Manual : http://www-3.ibm.com/software/data/informix/pubs/library/
5) IDS v10 온라인 도움말 : http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp
Ⅱ. 참고 자료 및 SITE
1. Linux OS
1) Redhat
- 홈페이지 : http://www.redhat.com
- 다운로드 : 홈페이지 혹은 ftp://ftp.redhat.com/pub/redhat/linux/
2) Fedora Core
- 홈페이지 : http://fedoraproject.org/
- 다운로드 : 홈페이지 혹은 http://mirrors.fedoraproject.org/publiclist/Fedora/
3) CentOS
- 홈페이지 : http://www.centos.org
- 다운로드 : 홈페이지 혹은 http://www.centos.org/modules/tinycontent/index.php?id=15
4) Suse
- 홈페이지 : http://www.suse.com/
- 다운로드 : 홈페이지 혹은 http://ftp.opensuse.org/
5) Asianux
- 홈페이지& 다운로드 : http://www.asianux.co.kr/
6) Mandriva(mandrake)
- 홈페이지& 다운로드 : http://wwwnew.mandriva.com
7) Ubunto
- 홈페이지& 다운로드 : http://www.ubuntu.com
8) Debian
- 홈페이지& 다운로드 : http://www.debian.org
2. Kernel 관련
- 홈페이지 : http://www.kernel.org
- 다운로드 : ftp://ftp.kernel.org/pub/
3. JAVA 관련
- 홈페이지 : http://java.sun.com
- 다운로드 : http://developers.sun.com/downloads/
Ⅲ. OS별 INFORMIX Dynamic Server 지원 정보

아래의 IBM 홈페이지에서 설치하려는 IDS 제품이 OS별로 설치 가능한지 체크 한다.
1) 아래의 URL을 웹브라우저를 통해 접근한다.
http://www-306.ibm.com/software/data/informix/pubs/roadmaps.html
2) 우측 상단의 “ Download the spreadsheet now “ 을 클릭하여 Exel file을 다운로드 한다.
3) 다운로드한 EXEL FILE을 열어 IDS 버젼 별 설치 가능한 OS 종류, 버젼 정보를 확인한다.
예)
Project
IDS 10.00.UC6
IDS 10.00.UC6
IDS 10.00.UC6
IDS 10.00.UC6
IDS 10.00.UC6
IDS 10.00.UC6
IDS 10.00.UC6
IDS 10.00.UC6
IDS 10.00.UC6
:
Maker
AMD
Intel
Intel
Intel
Intel
Intel
Intel
Intel
Intel
:
Architecture
AMD64
EM64T
x86
x86
x86
EM64T
EM64T
x86
EM64T
:
OS
OS Version
RHEL
5
Asianux
2
Mandriva Corporate Server3
RFAS
4.1
RHEL
3
RHEL
3
RHEL
4
RHEL
4
RHEL
5
:
:
GA
2007-01-25
1/25/2007
1/25/2007
1/25/2007
1/25/2007
1/25/2007
1/25/2007
1/25/2007
1/25/2007
;
Ⅲ. OS별 INFORMIX Dynamic Server 지원 정보
 IDS10UC6 LINUX 별 설치 가능 유무
Linux
IDS 10UC6
Version
TEXT MODE
INSTALL
GUI MODE
INSTALL
3
Available
Available
4
Available
Available
5
Available
Available
4*
Available
Available
5*
Available
Available
7*
Available
Available
2
Available
Available
3*
Available
Available
9
Available
Available
10.2*
Available
Available
3
Available
Available
4*
Available
Available
Ubuntu*
7.10
-
-
Debian*
4.0r1
-
-
Redhat ES
CentOS
Feodora
Asianux
SUSE
Mandriva CS
※ ‘*’ 표시는 공식적으로 지원 하지 않는 OS , Version 임
IDS10UC6 machine notes 내용
OS Information : Built on Red Hat Enterprise Linux ES release 3.0 (Taroon Update 4).
Certified on SUSE SLES 9, RHEL 4, RFAS 4.1, Asianux 2.0 and
Mandriva Corporate Server 3.0. And also certified on Red Hat
Enterprise Linux ES release 3.0, SUSE SLES 9, RHEL 4 and
Asianux 2.0 for x86_64 (EM64T/AMD64).
Ⅳ. IDS 설치 사전 준비
※ 본 안내서는 RedHAT ES 5 상에 IDS10UC6를 설치하는 것을 기준으로 작성 되었다 ※
1. informix user, group 생성 & /informix 생성
본 안내서에서는 /informix 디렉토리에 IDS를 설치 할것이다.
ID는 informix , PASSWORD도 informix , SHELL은 ksh을 사용하는것으로 하여 생성한다.
## 1. Ksh를 없으면 설치해야 함
# groupadd -g 200 informix
# useradd -g 200 -u 200 -d /informix -s /bin/ksh informix -m
# passwd informix
Changing password for user informix.
New UNIX password:
Retype new UNIX password:
2. 환경변수를 적용한다.
제품을 설치할 /informix 디렉토리를 INFORMIXDIR 환경변수로 등록하고 , 기타 환경변수를 등록한다.
# su – informix
$ vi .profile
export INFORMIXDIR=/informix
export PS1='[`hostname`]$LOGNAME:$PWD > '
$ . ./.profile
[RedHatES5]informix:/informix > id
uid=200(informix) gid=200(informix) groups=200(informix) context=user_u:system_r:unconfined_t
[RedHatES5]informix:/informix >
Ⅳ. IDS 설치 사전 준비
3. $INFOMRIXDIR 에 IDS 제품 복사, 압축해제
- 반드시 informix user로 login후 압축 해제
4. Java version 확인
반드시 V 1.5 이상 설치 확인 ( cf> OS bundle : java 1.4.2.xx )
Ⅴ. IDS 설치 (GUI 모드)
1. root login , $INFORMIXDIR 환경변수 설정
- 반드시 root user로 로그인 하여, $INFORMIXDIR 환경변수를 아래와 같이 설정한다.
- $INFORMIXDIR에 설치 스크립트 ids_install이 존재하는지 확인한다.
2. GUI 모드로 IDS제품 설치를 시작한다.
주의 > GUI 설치시 아래와 같은 error message가 출력되면 ,
“ Ⅷ. Install & Initialize Error - GUI 설치 실패 “ 를 참고 한다.
The installer is unable to run in graphical mode. ~~
Ⅴ. IDS 설치 (GUI 모드) - 계속
3. IDS V10 GUI 모드 설치 초기 화면
4. Release Notes & Install Guide 관련 문서 안내
‘ Next ‘ 를 클릭 한다.
Ⅴ. IDS 설치 (GUI 모드) - 계속
5. IDS V10 설치 환영
‘ Next ‘ 를 클릭 한다
6. 제품 라이센스 안내
제품 설치를 위해선 “Accept ” 를 하고 ‘ Next ‘ 를 클릭 한다
Ⅴ. IDS 설치 (GUI 모드) - 계속
7. IDS V10 설치 디렉토리 설정
$INFORMIXIDR 환경변수 값과 비교하여 필요시 수정 , 이상 없으면 ‘ Next ‘ 를 선택 한다
8. 이미 설치 된 IDS 제품 정보 찾기
이미 설치된 IDS 제품군 정보를 갱신한다. 수분이 소요 되므로 대기 한다.
Ⅴ. IDS 설치 (GUI 모드) - 계속
9. 설치 할 IDS 제품 선택
Default 설정( IDS, CSDK, JDBC 설치 ) 을 사용하기 위해 ‘ Next ‘ 를 클릭 한다
10. 역활 분리 (Role speration) 유무 선택
Default 설정( 역활분리 않함 ) 을 ‘ No’ 선택 하고 ‘ Next ‘ 를 클릭 한다.
역활분리에 대한 내용은 온라인 도움말 및 IBM Informix: Administrator’s Guide 메뉴얼을 참조 한다.
Ⅴ. IDS 설치 (GUI 모드) - 계속
11. 데모(Demo) 데이타베이스 생성 유무 선택
Default 설정( 생성 하지 않음 ) 을 선택하고 ‘ Next ‘ 를 클릭 한다.
12. IDS 제품 설치 최종 확인
제품 설치 내역을 확인하고 , 이상 없으면 ‘ Next ‘ 를 클릭 한다
Ⅴ. IDS 설치 (GUI 모드) - 계속
13. IDS 제품 설치 진행
IDS , CSDK , JDBC 등의 설치 진행 과정을 볼 수 있다.
14. 제품 설치 후 수행 할 작업 사항 안내
상세한 사항은 IBM Informix Dynamic Server Getting Started Guide 를 참조 한다.
‘ Next ‘ 를 클릭 한다
Ⅴ. IDS 설치 (GUI 모드) - 계속
15. IDS V10 제품 설치 성공 메세지
‘ Next ‘ 를 선택 한다
16. IDS V10 제품 설치 프로그램 종료
IDS 제품 설치 프로그램을 종료하기 위해 ‘ Finish ‘ 를 클릭한다
Ⅵ. IDS 설치 ( Text 모드 )
1. “ Ⅳ. IDS 설치 사전 준비 ” 의 1 ~ 4 단계를 수행한다.
2. Text 모드로 IDS 제품 설치를 실행 시킨다.
[RedHatES5]root:/informix > ls
bundle.ini DBLD
ids10uc6.tar images lost+found SERVER
SVR_ADM
CSDK
ICONNECT ids_install JDBC README.html suite.jar
[RedHatES5]root:/informix > ./ids_install
Initializing InstallShield Wizard........
Launching InstallShield Wizard........
“ ids_install “ 명령어 실행
3. 제품 설치 시작 선택
1. Release Notes
2. Quick Beginnings Guide
3. Begin Installation
Please select one of these options [3] < enter >
Beginning installation...
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]
< enter >
4. IDS V10 설치 환영
Welcome to the InstallShield Wizard for IBM Informix Dynamic Server Bundle
The InstallShield Wizard will install IBM Informix Dynamic Server Bundle on
your computer.
To continue, choose Next.
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
< enter >
Ⅵ. IDS 설치 ( Text 모드 ) - 계속
5. 제품 라이센스 안내
Software Licensing Agreement
Press Enter to display the license agreement on your screen. Please
read the agreement carefully before installing the Program. After
reading the agreement, you will be given the opportunity to accept it
or decline it. If you choose to decline the agreement, installation
will not be completed and you will not be able to use the Program.
International Program License Agreement
Part 1 - General Terms
BY DOWNLOADING, INSTALLING, COPYING, ACCESSING, OR USING
THE PROGRAM YOU AGREE TO THE TERMS OF THIS AGREEMENT. IF YOU
ARE ACCEPTING THESE TERMS ON BEHALF OF ANOTHER PERSON OR A
COMPANY OR OTHER LEGAL ENTITY, YOU REPRESENT AND WARRANT
THAT YOU HAVE FULL AUTHORITY TO BIND THAT PERSON, COMPANY,
OR LEGAL ENTITY TO THESE TERMS. IF YOU DO NOT AGREE TO
THESE TERMS,
- DO NOT DOWNLOAD, INSTALL, COPY, ACCESS, OR USE THE
PROGRAM; AND
Press Enter to continue viewing the license agreement, or, Enter 1 to
accept the agreement, 2 to decline it or 99 to go back to the previous
screen.
1
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]
< enter >
동의 (Accept) 하면 <enter>
6. IDS V10 설치 디렉토리 설정
IBM Informix Dynamic Server Bundle Install Location
Please specify a directory or press Enter to accept the default directory.
Directory Name: [/informix]
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]
< enter >
$INFORMIXIDR 환경변수 값과 비교하여 필요시 수정 , 이상 없으면 <enter>
Ⅵ. IDS 설치 ( Text 모드 ) - 계속
7. 이미 설치 된 IDS 제품 정보 찾기 & 설치 할 IDS 제품 선택
Searching for products available for install: this may take a few minutes.
Select the products you would like to install:
To select/deselect a product or to change its setup type, type its number:
Product
Setup Type
-------------------------------------------------------------------1. [ ] IBM Informix IConnect
2. [x] IBM Informix Client-SDK
Typical
3. [x] IBM Informix Dynamic Server
Typical
4. [x] IBM Informix JDBC Driver
Other options:
0. Continue installing
Enter command [0] < enter >
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
< enter >
Default 설정( IDS, CSDK, JDBC 설치 ) 을 사용하기 위해 <enter> 를 입력한다.
8. 역활 분리 (Role speration) 유무 선택
Do you want to enable role separation?
[ ] 1 - Yes
[X] 2 - No
To select an item enter its number, or 0 when you are finished: [0] < enter >
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
< enter >
Default 설정( 역활분리 않함 ) 을 ‘ No’ 선택 하고 <enter> 를 입력한다.
역활분리에 대한 내용은 온라인 도움말 및 IBM Informix: Administrator's Guide 메뉴얼을 참조한다
Ⅵ. IDS 설치 ( Text 모드 ) - 계속
9. 데모(Demo) 데이타베이스 생성 유무 선택
Would you like to create an IDS demo instance?
[ ] 1 - Create Demo
[X] 2 - Do Not Create Demo
To select an item enter its number, or 0 when you are finished: [0]
< enter >
The primary purpose of the demo instance is to ensure that the product is
properly installed and the hardware is configured to work with IDS.
This demo instance can be used as an actual production instance if properly
configured.
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
< enter >
Default 설정( 생성 하지 않음 ) 을 선택하고 <enter> 입력
10. IDS 제품 설치 최종 확인
IBM Informix Dynamic Server Bundle will be installed in the following location:
/informix
with the following features:
IBM Informix Client-SDK
IBM Informix Dynamic Server
IBM Informix JDBC Driver
for a total size:
365.2 MB
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] < enter >
이상 없으면 <enter> 입력
Ⅵ. IDS 설치 ( Text 모드 ) - 계속
11. IDS 제품 설치 진행
Installing IBM Informix Dynamic Server Bundle. Please wait...
0 % complete
100 % complete
Creating uninstaller...
Creating uninstaller...
Installing IBM Informix JDBC Driver. Please wait...
Creating uninstaller...
Installing Message Files by RPM
Installing GLS Files by RPM
Installing IDS Files by RPM
Installing SDK Message Files by RPM
Installing SDK GLS Files by RPM
Installing SDK Files by RPM
Branding
Installing
Installing
Installing
Installing
Installing
Installing
Installing
Installing
:
:
Files ...
directory
directory
directory
directory
directory
directory
directory
directory
.
etc
bin
lib
lib/client
lib/client/csm
lib/esql
lib/dmi
Ⅵ. IDS 설치 ( Text 모드 ) - 계속
12. 제품 설치 후 수행 할 작업 사항 안내
Please read the information below.
Set required environment variables
Set $INFORMIXDIR to the directory where the IDS server is installed.
Set $PATH to include $INFORMIXDIR/bin
Set $INFORMIXSERVER to the name of the database server
Set $ONCONFIG to the name of the active onconfig configuration file.
If using a sqlhosts file other than $INFORMIXDIR/etc/sqlhosts
Set $INFORMIXSQLHOSTS
If using a locale/language other than the default
Set $CLIENT_LOCALE
Set $DB_LOCALE
Set $SERVER_LOCALE
Set $DBLANG
Prepare connectivity files
sqlhosts
/etc/hosts
/etc/services
Prepare configuration file
Set DBSERVERNAME
Set SERVERNUM
Set ROOTNAME
Press ENTER to read the text [Type q to quit]
Set ROOTPATH
Set ROOTSIZE
Initialize database server
As informix or root, run oninit
If initializing a new server for the FIRST time, run oninit -i
This will overwrite any existing data, so use caution on an exis
ting setup
For more information please refer to the IBM Informix Dynamic Server Getting
Started Guide
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]
< enter >
확인 후 <enter>
상세한 사항은 IBM Informix Dynamic Server Getting Started Guide 를 참조 한다.
Ⅵ. IDS 설치 ( Text 모드 ) - 계속
13. IDS V10 제품 설치 프로그램 종료
The InstallShield Wizard has successfully installed IBM Informix Dynamic Server
Bundle. Choose Next to continue the wizard.
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
1. Release Notes
2. Installation Guide
3. Finish Installation
Please select one of these options [3]
Finishing Installation...
Press 3 to Finish or 4 to Redisplay [3]
< enter >
IDS 제품 설치 프로그램을 종료하기 위해 <enter> 입력
Ⅶ. Informix 데이타베이스 초기화
1. 데이타베이스 구성 내역
- INSTANCE NAME : ids10uc6
- root chunk : /infomrix/DBS/rootdbs.chk
[ 300 MB . cooked device ]
- Buffers
[ 100 MB ]
: 50000
- ONCONFIG : onconfig.ids10uc6
- INFORMIXSQLHOSTS : sqlhosts.ids10uc6
- TCP/IP 서비스 포트
: 9088 ( sqlexec )
2. 데이타베이스 초기화 준비 작업
: 반드시 root user로 login 하여 아래와 같은 작업을 수행 한다.
- Kernel parameter 수정
/informix/release/en_us/0333/ ids_machine_notes_10.00.txt 의 Kernel parameter
권장 값을 확인하고 이를 /etc/sysctl.conf 에 아래와 같이 적용하고 반드시 REBOOT 후
Kernel parameter 변경을 확인한다.
[root@RedHatES5 informix/release/en_us/0333 > vi ids_machine_notes_10.00.txt
System Configuration
====================
1. Kernel Parameters
The values of the kernel parameters that were used for testing this
product are given below. These values might need to be tuned depending
on the application and availability of system resources. They
can either be dynamically changed in the /proc file system or are defined
in the kernel sources and can be changed by rebuilding the kernel.
SHMMAX:
33554432
SHMMNI:
128
SHMALL:
4194304
SEMMNI:
128
SEMMSL:
250
SEMMNS:
32000
SEMOPM:
32
Kernel parameter 권장 값
Ⅶ. Informix 데이타베이스 초기화 - 계속
[root@RedHatES5 etc]# vi sysctl.conf
:
## 여기서 부터 없으면 추가해야 함
# Controls the maximum shared segment size, in bytes
kernel.shmmax = 4294967295
# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 268435456
## INFORMIX IDS10UC6 ##
#kernel.shmmax = 33554432
kernel.shmmin = 1
kernel.shmmni = 128
kernel.shmseg = 128
kernel parameter 적용
#kernel.shmall = 4194304
kernel.semmni = 128
kernel.semmsl = 250
kernel.semmns = 32000
kernel.semopm = 32
:wq!
[root@RedHatES5 etc]# reboot
[root@RedHatES5 ~]# sysctl -a |grep shm
vm.hugetlb_shm_group = 0
kernel.shmmni = 128
kernel parameter 적용 확인
kernel.shmall = 268435456
kernel.shmmax = 4294967295
[root@RedHatES5 ~]# sysctl -a |grep sem
kernel.sem = 250
32000
32
128
※ 본 안내서에서는 shmall 과 shmmax 값은 OS Default 값이 더 크므로 이를 사용한다.
kernel parameter 값을 변경하기 전에 “sysctl –a |grep shm “ ,”sysctl –a |grep sem”
command 등으로 기존 값과 비교하여 적용한다.
“ipcs –lms “ command로도 kernel parameter 변경을 확인 할 수 있다.
Ⅶ. Informix 데이타베이스 초기화 - 계속
- TCP/IP 서비스 포트 등록
/etc/services file에 다음을 확인하고 없으면 이를 등록 후 , reboot 한다.
외부에서 접속시 아래의 port 번호로 access 하게 된다.
[root@RedHatES5 ~]# vi /etc/services
sqlexec
sqlexec
9088/tcp
9088/udp
:
# IBM Informix SQL Interface
# IBM Informix SQL Interface
:
- rootdbs chunk 생성
/informix/DBS/rootdbs.chk 를 생성 하고 소유권 및 권한을 아래와 같이 반드시 변경한다.
[root@RedHatES5 ~]# cd /informix
[root@RedHatES5 informix]# mkdir DBS
[root@RedHatES5 informix]# chown informix:informix DBS
[root@RedHatES5 informix]# cd DBS
[root@RedHatES5 DBS]# touch rootdbs.chk
[root@RedHatES5 DBS]# chown informix:informix rootdbs.chk
[root@RedHatES5 DBS]# chmod 660 rootdbs.chk
[root@RedHatES5 DBS]# pwd
/informix/DBS
[root@RedHatES5 DBS]# ls -al
total 8
drwxr-xr-x
2 informix informix 4096 Oct 29 14:58 .
drwxr-xr-x 34 informix informix 4096 Oct 29 14:58 ..
-rw-rw----
1 informix informix
0 Oct 29 14:58 rootdbs.chk
3. informix user 환경파일 수정
ksh을 사용할 경우 다음와 같이 /informix/.profile을 수정 & 적용한다.
•
PATH : /informix/bin 을 받드시 포함시킨다.
•
LD_LIBRARY_PATH : linux의 이경우 이 이름으로 라이브러리 디렉토리 경로를 포함시킨다.
•
INFORMXISERVER : 생성할 INSTANCE 이름을 지정 / 등록한다.
•
ONCONFIG
•
INFORMIXSQLHOSTS : $INFORMXDIR/etc 아래의 IDS SQLHOSTS file 이름을 지정한다.
: $INFORMXDIR/etc 아래의 IDS Config file의 이름을 지정한다.
Ⅶ. Informix 데이타베이스 초기화 - 계속
[root@RedHatES5 ~]# su – informix
## 3.login 하였으나 계속 root로 남아있다.
[RedHatES5]informix:/informix > vi .profile
export INFORMIXDIR=/informix
export PS1='[`hostname`]$LOGNAME:$PWD > '
export PATH=$PATH:$INFORMIXDIR/bin/:.
export LD_LIBRARY_PATH=/usr/lib:$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:.
export INFORMIXSERVER=ids10uc6
export ONCONFIG=onconfig.ids10uc6
export INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts.ids10uc6
export TERMCAP=/informix/etc/termcap
# informix terminal
[RedHatES5]informix:/informix > . ./.profile
[RedHatES5]informix:/informix > env |grep INFO
INFORMIXSERVER=ids10uc6
확인
INFORMIXDIR=/informix
INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts.ids10uc6
“ 1. 데이타베이스 구성 내역” 참조
4. $ONCONFIG FILE 수정
- /informix/etc/onconfig.std 표준 파일을 $ONCONFIG 즉, onconfig.ids10uc6로 copy 한다.
- onconfig에 대한 사항은 online 도움말이나 IBM Library내의 Administrator’s Guide를 참조한다.
- 여기에서는 초기화를 위한 최소한의 내용만을 다룬다.
- onmonitor라는 tool로 수정가능하나, 본 가이드에서는 vi로 직접 편집 한다.
•
ROOTPATH : root dbspace의 chunk 위치를 지정한다.
•
ROOTSIZE : root dbshpace chunk의 size (KB) , 본 가이드에서는 300MB로 지정한다.
•
MSGPATH : informix log file의 위치를 지정한다.
•
ALARMPROGRAM : 자동 logical log backup을 위한 alaram programe 위치를 지정한다.
•
TAPDEV/LTAPDEV : backup device 위치를 지정한다 ,
본 가이드에서는 편의상 /dev/null 로 지정하여 fake backup을 사용한다.
•
SERVERNUM : INSTANCE NUMBER , 머신상에서 유일한 숫자를 부여한다.
•
DBSERVERNAME : INSTANCE 이름 , 머신상에서 유일한 이름을 부여한다.
•
DBSERVERALIASES : INSTNACE 의 별칭을 부여한다.
•
NETTYPE : 데이타베이스 연결시 사용되는 network 연결 type을 정의한다.
•
DUMPDIR : IDS dump file 생성 위치를 지정한다.
•
BUFFERPOOL: buffer size를 지정한다. 본가이드에서는 100MB를 할당하기로 했으므로
•
buffers=50000 로 지정한다. (Linux blocksize=2KB)
Ⅶ. Informix 데이타베이스 초기화 - 계속
•
SHMBASE : shared memory 할당 start address 위치.
/informix/release/en_us/0333/ ids_machine_notes_10.00.txt 의 권고사항을 반드시
확인하도록 한다
※ Red Hat Enterprise Linux 3 이상은 반드시 SHMBASE를 0xb7600000을 사용하도록 하고 있다.
이를 지키지 않으면 INSTANCE가 초기화시 다음과 같은 error message를 출력하고 실패하게
된다. “ Ⅷ. Install & Initialize Error - OS couldn't allocate first resident segment 편 “을 참고
한다.
couldn't allocate first resident segment at SHMBASE (0x52564801)
[RedHatES5]informix:/informix/etc > cp onconfig.std $ONCONFIG
[RedHatES5]informix:/informix/etc > vi $ONCONFIG
#**************************************************************************
#
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# (c) Copyright IBM Corporation 1996, 2006 All rights reserved.
#
# Title:
onconfig.std
# Description: IBM Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME
rootdbs
ROOTPATH
/informix/DBS/rootdbs.chk # Path for device containing root dbspace
#ROOTPATH
ROOTOFFSET
#ROOTSIZE
ROOTSIZE
# Root dbspace name
/dev/online_root # Path for device containing root dbspace
0
# Offset of root dbspace into device (Kbytes)
30000
# Size of root dbspace (Kbytes)
300000
# Size of root dbspace (Kbytes)
:
:
Ⅸ. 첨부 “ onconfig.ids10uc6 “ 참조
Ⅶ. Informix 데이타베이스 초기화 - 계속
5. $INFORMIXSQLHOSTS 수정
- /informix/etc/sqlhosts 표준 파일을 $INFORMIXSQLHOSTS 즉, sqlhosts.ids10uc6로
copy 한다.
- sqlhosts에 대한 사항은 online 도움말이나 IBM Library내의 Administrator’s Guide를 참조한다.
- 여기에서는 초기화를 위한 최소한의 내용만을 다룬다.
- onmonitor라는 tool로 수정 가능하나, 본 가이드에서는 vi로 직접 편집 한다.
첫번째 칼럼 : $ONCONFIG내의 DBSERVERNAME 혹은 DBSERVERALIAS를 연결 이름으로
지정한다.
•
두번째 칼럼 : NETTYPE을 지정한다.
•
세번째 칼럼 : hostname. 연결하려는 Database가 존재하는 머신 이름 혹은 ip address를
•
지정한다. 머신이름을 사용하기 위해서는 /etc/hosts file에 등록되어 있어야
한다.ex) 본 가이드에서는 hostname으로 “RedHatES5”를 사용한다.
네번째 칼럼 : service name, tcp/ip 연결의 경우 /etc/serivices file에 등록했던 포트이름을
지정하거나, 직접 포트번호를 기입한다.
•
다섯번째 칼럼 : Option , 필요한 연결 옵션을 지정한다.
[RedHatES5]informix:/informix/etc > cp sqlhosts $INFORMIXSQLHOSTS
## sqlhosts 가 없으면 sqlhosts.demo로 해야함
[RedHatES5]informix:/informix/etc > vi $INFORMIXSQLHOSTS
#demo_on
onipcshm
on_hostname
on_servername
#demo_se
seipcpip
se_hostname
sqlexec
ids10uc6
onsoctcp
RedHatES5
sqlexec
ids10uc6_shm
onipcshm
RedHatES5
ids10uc6_shm
6. INSTANCE 초기화
- “oninit –ivy “ command 를 사용하여 초기화 하는 방법과 onmonitor tool의
Parameters >
Initialize 를 통해 초기화 하는 방법이 있다, 본 가이드는 command를 사용하기로 한다.
[RedHatES5]informix:/informix/etc > oninit -ivy
Ⅶ. Informix 데이타베이스 초기화 - 계속
Checking group membership to determine server run mode...succeeded
Reading configuration file '/informix/etc/onconfig.ids10uc6'...succeeded
Creating /INFORMIXTMP/.infxdirs... succeeded
Creating infos file "/informix/etc/.infos.ids10uc6"...succeeded
Linking conf file "/informix/etc/.conf.ids10uc6"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 6918 kbytes...succeeded
Allocating 100016 kbytes for buffer pool of 2K page size...succeeded
Initializing rhead structure...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Forking 1 'ipcshm' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
Initializing log/checkpoint information...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Initializing dbspaces...succeeded
Validating chunks...succeeded
Creating database partition...succeeded
Initialize Async Log Flusher...succeeded
Forking btree cleaner...succeeded
Initializing DBSPACETEMP list...succeeded
Checking database partition index...succeeded
Checking location of physical log...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Forking onmode_mon thread...succeeded
Verbose output complete: mode = 5
초기화 성공
[RedHatES5]informix:/informix/etc > onstat -
IBM Informix Dynamic Server Version 10.00.UC6 -- On-Line -- Up 00:03:24 -- 299308 Kbytes
Ⅷ. Install & Initialize Error

onstat: error while loading shared libraries: libstdc++.so.5
: 이 error 는 libstdc++.so.5 library가 OS 설치시 설치 되지 않았을 경우에 제품 설치 과정이나
onstat command 실행 시 아래와 같이 발생한다.
(1) 제품 설치 과정시 error
:
Branding Installed Files ...
Installation of IBM Informix Internet Foundation failed.
etc/brand: error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No
such file or directory
The InstallShield Wizard has successfully installed IBM Informix Dynamic Server
Bundle. Choose Next to continue the wizard.
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
:
(2) Onstat command 실행시 error
[RedHatES5]informix:/informix/etc > onstat –
onstat: error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No
such file or directory
Sol] OS 에 따라 “ compat-libstdc++-33-3.2.3-61.i386.rpm “이나
libstdc++5-3.3.6-2mdk.i586.rpm “을 OS 설치 CD나 Download site에서
download 하여 설치하고 , Informix Dynamic Server(IDS) 제품만 재설치 한다.
재설치 않 할 경우 다음과 같이 error message를 출력 한다.
(3) libstdc++ library installl 후 IDS 재설치 않 할 경우 error
[RedHatES5]informix:/informix/etc > onstat Invalid serial number. Please consult the Installation Instructions.
Sol] IDS를 재설치 하면 된다.
Ⅷ. Install & Initialize Error

OS couldn't allocate first resident segment at SHMBASE (0x52574801) - 계속
(2) SHMBASE = 0x44000000 일때 error
[RedHatES5]informix:/informix/etc > oninit -vy
Checking group membership to determine server run mode...succeeded
Reading configuration file '/informix/etc/onconfig.ids10fc6'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/informix/etc/.infos.ids10fc6"...succeeded
Linking conf file "/informix/etc/.conf.ids10fc6"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
[RedHatES5]informix:/informix/etc >
<= Initialize 실패
[RedHatES5]informix:/informix/etc > onstat -m
shared memory not initialized for INFORMIXSERVER 'ids10fc6'
01:07:41 IBM Informix Dynamic Server Started.
01:07:41 Contiguous shared memory segment allocation failed at 0x44000000.
Allocation successful at 0xe1e000.
Check SHMBASE is consistent with the value in $INFORMIXDIR/etc/onconfig.std.
If you are using the correct SHMBASE value in your ONCONFIG file, then
consider this message informational only.
01:07:41 OS couldn't allocate first resident segment at SHMBASE (0x52574801).
Sol] 특정 OS 사용시 $ONCONFIG의 SHMBASE 변경 필요
RedhatT ES5 , CENTOS 5 의 경우 반드시 SHMBASE를 아래의 값을 사용해야
한다.
SHMBASE
0xb7600000
# Shared memory base address
참고 ) $INFORMIXDIR//release/en_us/0333/ids_machine_notes_10.00.txt
2. Location of Shared Memory
The ONCONFIG variable SHMBASE is set to the following:
SHMBASE 0x44000000L
- On Red Hat Enterprise Linux 3 the start address for shared libraries
is 0xb7600000 and memory address space is utilized downwards.
Ⅷ. Install & Initialize Error

OS couldn't allocate first resident segment at SHMBASE (0x52574801)
: 이 error 는 $ONCONFIG 상의 BUFFERS 값만큼의 shared memory를 할당하지 못할 경우
발생하는것으로 “oninit –ivy” 혹은 “ oninit –vy” command로 instance 초기화 혹은 구동시
다음과 같은 증상을 보인다.
(1) SHMBASE = 0xb7600000 일때 error
[RedHatES5]informix:/informix/etc > oninit -vy
Checking group membership to determine server run mode...succeeded
Reading configuration file '/informix/etc/onconfig.ids10fc6'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/informix/etc/.infos.ids10fc6"...succeeded
Linking conf file "/informix/etc/.conf.ids10fc6"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
[RedHatES5]informix:/informix/etc >
<= Initialize 실패
[RedHatES5]informix:/informix/etc > onstat -m
shared memory not initialized for INFORMIXSERVER 'ids10fc6'
00:58:29 IBM Informix Dynamic Server Started.
00:58:29 Contiguous shared memory segment allocation failed at 0xb7600000.
Allocation successful at 0xaaf20000.
Check SHMBASE is consistent with the value in $INFORMIXDIR/etc/onconfig.std.
If you are using the correct SHMBASE value in your ONCONFIG file, then
consider this message informational only.
00:58:31 OS couldn't allocate first resident segment at SHMBASE (0x52574801).
Sol] 1) VMware를 사용한 경우 : 일부 VMware version에서 bug로 보임
반드시 $ONCONFIG 상의 BUFFERS, SHMVIRTSIZE, SHMADD 값을 default 값 혹은
권장값 이내로 설정해야 한다.
BUFFERS= 50000 , SHMVIRTSIZE= 8192(default) , SHMADD=8192(default)
2) 1)의 경우 아니고 실제 Physical memory가 부족한 경우 :
memory 추가 혹은 $ONCONFIG의 BUFFERS 값 축소 변경
Ⅷ. Install & Initialize Error

GUI 설치 실패
: 아래와 같은 error message 시 출력시 다음과 같이 조치한다.
- 이전 X11 라이브러리를 설치 한다.:
yum install xorg-x11-deprecated-libs
- java 버전을 v 1.5 이상으로 재설치 한다.

VNC , Xmanager 등을 통한 remote 설치 시
- Xmanager 사용시
DISPLAY 환경 변수를 자신의 환경에 맞게 아래와 같이 수정한다.
export DISPLAY= ipaddress: console number
ex ) export DISPLAY= 192.168.0.1:1.0
- VNC 사용시
~HOME/.VNC/xstartup 화일 등을 점검 한다.
Ⅸ. 첨부
 onconfig.ids10uc6
#**************************************************************************
#
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# (c) Copyright IBM Corporation 1996, 2006 All rights reserved.
#
# Title:
onconfig.std
# Description: IBM Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME
rootdbs
# Root dbspace name
ROOTPATH
/informix/DBS/rootdbs.chk # Path for device containing root dbspace
#ROOTPATH
/dev/online_root # Path for device containing root dbspace
ROOTOFFSET
0
# Offset of root dbspace into device (Kbytes)
#ROOTSIZE
30000
# Size of root dbspace (Kbytes)
ROOTSIZE
300000
# Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR
0
MIRRORPATH
MIRROROFFSET
0
# Mirroring flag (Yes = 1, No = 0)
# Path for device containing mirrored root
# Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS
PHYSFILE
rootdbs
2000
# Location (dbspace) of physical log
# Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES
LOGSIZE
6
2000
# Number of logical log files
# Logical log size (Kbytes)
# Tablespace Tablespace Configuration in Root Dbspace
TBLTBLFIRST
TBLTBLNEXT
#
#
#
#
#
0
0
# First extent size (Kbytes) (0 = default)
# Next extent size (Kbytes) (0 = default)
Security
DBCREATE_PERMISSION:
By default any user can create a database. Uncomment DBCREATE_PERMISSON to
limit database creation to a specific user. Add a new DBCREATE_PERMISSION
line for each permitted user.
#DBCREATE_PERMISSION
informix
Ⅸ. 첨부
#
#
#
#
#
#
DB_LIBRARY_PATH:
When loading a (C or C++) shared object (for a UDR or UDT), IDS checks that
the user-specified path starts with one of the directory prefixes listed in
the comma-separated list of prefixes in DB_LIBRARY_PATH. The string
"$INFORMIXDIR/extend" must be included in DB_LIBRARY_PATH in order for
extensibility and IBM supplied blades to work correctly.
# DB_LIBRARY_PATH $INFORMIXDIR/extend
# IFX_EXTEND_ROLE:
# 0 (or off) => Disable use of EXTEND role to control who can register
#
external routines.
# 1 (or on) => Enable use of EXTEND role to control who can register
#
external routines. This is the default behaviour.
#
IFX_EXTEND_ROLE 1
# To control the usage of EXTEND role.
# Diagnostics
MSGPATH
#MSGPATH
CONSOLE
/informix/online.log # System message log file path
/usr/informix/online.log # System message log file path
/dev/console
# System console message path
# To automatically backup logical logs, edit alarmprogram.sh and set
# BACKUPLOGS=Y
ALARMPROGRAM
/informix/etc/alarmprogram.sh # Alarm program path
#ALARMPROGRAM
/usr/informix/etc/alarmprogram.sh # Alarm program path
ALRM_ALL_EVENTS 0
# Triggers ALARMPROGRAM for any event occur
TBLSPACE_STATS 1
# Maintain tblspace statistics
# System Archive Tape Device
TAPEDEV
#TAPEDEV
TAPEBLK
TAPESIZE
/dev/null
# Tape device path
/dev/tapedev
# Tape device path
32
# Tape block size (Kbytes)
10240
# Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV
#LTAPEDEV
LTAPEBLK
LTAPESIZE
/dev/null
/dev/tapedev
32
10240
#
#
#
#
Log
Log
Log
Max
tape device path
tape device path
tape block size (Kbytes)
amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB
# Informix Dynamic Server staging area
Ⅸ. 첨부
# System Configuration
SERVERNUM
0
DBSERVERNAME
ids10uc6
DBSERVERALIASES ids10uc6_shm
NETTYPE
soctcp,1,,CPU
NETTYPE
ipcshm,1,,NET
DEADLOCK_TIMEOUT
60
RESIDENT
0
# Unique id corresponding to a OnLine instance
# Name of default database server
# List of alternate dbservernames
# Configure poll thread(s) for nettype
# Configure poll thread(s) for nettype
# Max time to wait of lock in distributed env.
# Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 0
NUMCPUVPS
1
SINGLE_CPU_VP 0
# 0 for single-processor, 1 for multi-processor
# Number of user (cpu) vps
# If non-zero, limit number of cpu vps to one
NOAGE
AFF_SPROC
AFF_NPROCS
# Process aging
# Affinity start processor
# Affinity number of processors
0
0
0
# Shared Memory Parameters
LOCKS
2000
NUMAIOVPS
PHYSBUFF
32
LOGBUFF
32
CLEANERS
1
SHMBASE
0x44000000L
#SHMBASE
0xb7600000
SHMVIRTSIZE
8192
SHMADD
8192
EXTSHMADD
8192
SHMTOTAL
0
SHMVIRT_ALLOCSEG 0
CKPTINTVL
TXTIMEOUT
STACKSIZE
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
300
300
32
# Maximum number of locks
# Number of IO vps
# Physical log buffer size (Kbytes)
# Logical log buffer size (Kbytes)
# Number of buffer cleaner processes
# Shared memory base address
# Shared memory base address , REDHAT ES5 , CENTOS5
# initial virtual shared memory segment size
# Size of new shared memory segments (Kbytes)
# Size of new extension shared memory segments (Kbytes)
# Total shared memory (Kbytes). 0=>unlimited
# Values between 0 and .99 are %, values > 1 are
# KB - when this much virtual memory is used we
# try to get a new segment. 0 means "off". 2nd
# parameter is alarm level
# Check point interval (in sec)
# Transaction timeout (in sec)
# Stack size (Kbytes)
Dynamic Logging
DYNAMIC_LOGS:
2 : server automatically add a new logical log when necessary. (ON)
1 : notify DBA to add new logical logs when necessary. (ON)
0 : cannot add logical log on the fly. (OFF)
When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM,
because the server can add new logical logs during long transaction rollback.
However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM
can be set to smaller values.
If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values
to avoid long transaction rollback hanging the server due to lack of logical
log space, i.e. 50/60 or lower.
In case of system configured with CDR, the difference between LTXHWM and
LTXEHWM should be atleast 30% so that we could minimize log overrun issue.
Ⅸ. 첨부
DYNAMIC_LOGS
LTXHWM
LTXEHWM
2
70
80
# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
#
To determine the page size used by OnLine on your platform
#
see the last line of output from the command, 'onstat -b'.
#
#
#
#
#
Recovery Variables
OFF_RECVRY_THREADS:
Number of parallel worker threads during fast recovery or an offline restore.
ON_RECVRY_THREADS:
Number of parallel worker threads during an online restore.
OFF_RECVRY_THREADS
ON_RECVRY_THREADS
10
1
# Default number of offline worker threads
# Default number of online worker threads
# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO
0
# DR automatic switchover
DRINTERVAL
30
# DR max time between DR buffer flushes (in sec)
DRTIMEOUT
30
# DR network timeout (in sec)
DRLOSTFOUND
/usr/informix/etc/dr.lostfound # DR lost+found file path
DRIDXAUTO
0
# DR automatic index repair. 0=off, 1=on
# CDR Variables
CDR_EVALTHREADS 1,2
# evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5
# DS lockwait timeout (seconds)
CDR_QUEUEMEM
4096
# Maximum amount of memory for any CDR queue (Kbytes)
CDR_NIFCOMPRESS 0
# Link level compression (-1 never, 0 none, 9 max)
CDR_SERIAL
0
# Serial Column Sequence
CDR_DBSPACE
# dbspace for syscdr database
CDR_QHDR_DBSPACE
# CDR queue dbspace (default same as catalog)
CDR_QDATA_SBSPACE # List of CDR queue smart blob spaces
#
#
#
#
#
CDR_MAX_DYNAMIC_LOGS
-1 => unlimited
0 => disable dynamic log addition
>0 => limit the no. of dynamic log additions with the specified value.
Max dynamic log requests that CDR can make within one server session.
CDR_MAX_DYNAMIC_LOGS
0 # Dynamic log addition disabled by default
# Backup/Restore variables
BAR_ACT_LOG /usr/informix/bar_act.log # ON-Bar Log file - not in /tmp please
BAR_DEBUG_LOG /usr/informix/bar_dbug.log # ON-Bar Debug Log - not in /tmp please
BAR_MAX_BACKUP 0
BAR_RETRY
1
BAR_NB_XPORT_COUNT 20
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE
ON
BAR_PROGRESS_FREQ
0
Ⅸ. 첨부
# Informix Storage Manager variables
ISM_DATA_POOL ISMData
ISM_LOG_POOL
ISMLogs
# Read Ahead Variables
RA_PAGES
RA_THRESHOLD
#
#
#
#
#
#
#
DBSPACETEMP:
OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
that the OnLine SQL Engine will use to create temp tables etc.
If specified it must be a colon separated list of dbspaces that exist
when the OnLine system is brought online. If not specified, or if
all dbspaces specified are invalid, various ad hoc queries will create
temporary files in /tmp instead.
DBSPACETEMP
#
#
#
#
#
# Number of pages to attempt to read ahead
# Number of pages left before next group
# Default temp dbspaces
DUMP*:
The following parameters control the type of diagnostics information which
is preserved when an unanticipated error condition (assertion failure) occurs
during OnLine operations.
For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR
DUMPSHMEM
DUMPGCORE
DUMPCORE
DUMPCNT
/informix/tmp
1
0
0
1
#
#
#
#
#
#
Preserve diagnostics in this directory
Dump a copy of shared memory
Dump a core image using 'gcore'
Dump a core image (Warning:this aborts OnLine)
Number of shared memory or gcore dumps for
a single user's session
FILLFACTOR
90
# Fill factor for building indexes
# method for OnLine to use when determining current time
USEOSTIME
0
# 0: use internal time(fast), 1: get time from OS(slow)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100
# Maximum allowed pdqpriority
DS_MAX_QUERIES
# Maximum number of decision support queries
DS_TOTAL_MEMORY
# Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DS_NONPDQ_QUERY_MEM 128
# Non PDQ query memory (Kbytes)
DATASKIP
# List of dbspaces to skip
#
#
#
#
#
#
#
#
#
#
OPTCOMPIND
0 => Nested loop joins will be preferred (where
possible) over sortmerge joins and hash joins.
1 => If the transaction isolation mode is not
"repeatable read", optimizer behaves as in (2)
below. Otherwise it behaves as in (0) above.
2 => Use costs regardless of the transaction isolation
mode. Nested loop joins are not necessarily
preferred. Optimizer bases its decision purely
on costs.
Ⅸ. 첨부
OPTCOMPIND
2
DIRECTIVES
1
ONDBSPACEDOWN
OPCACHEMAX
2
0
# To hint the optimizer
# Optimizer DIRECTIVES ON (1/Default) or OFF (0)
# Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
# Maximum optical cache size (Kbytes)
# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0
SBSPACENAME
#
#
#
#
#
#
#
SYSSBSPACENAME
Default smartblob space name - this is where blobs
go if no sbspace is specified when the smartblob is
created. It is also used by some datablades as
the location to put their smartblobs.
Default smartblob space for use by the Informix
Server. This is used primarily for Informix Server
system statistics collection.
BLOCKTIMEOUT
3600 # Default timeout for system block
SYSALARMPROGRAM
/usr/informix/etc/evidence.sh
# System Alarm program path
# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL
-1
ALLOW_NEWLINE
0
# embedded newlines(Yes = 1, No = 0 or anything but 1)
#Create Index Online Shared Memory usage limitation
ONLIDX_MAXMEM
5120
# Per pool per index (Kbytes)
#Timeout for client connection request
LISTEN_TIMEOUT
10
# Timeout (in Seconds)
#Following are the deprecated configuration parameters, instead of these
#use BUFFERPOOL configuration parameter
#BUFFERS, LRUS, LRU_MIN_DIRTY, LRU_MAX_DIRTY
IFX_FOLDVIEW
0
# fold multiple tables or union all view with ansi joins
#
# The following are default settings for enabling Java in the database.
# Replace all occurrences of /usr/informix with the value of $INFORMIXDIR.
#VPCLASS
jvp,num=1
JVPJAVAHOME
JVPHOME
/usr/informix/extend/krakatoa/jre
# JRE installation root directory
/usr/informix/extend/krakatoa # Krakatoa installation directory
JVPPROPFILE
JVPLOGFILE
/usr/informix/extend/krakatoa/.jvpprops # JVP property file
/usr/informix/jvp.log # JVP log file.
JDKVERSION
1.3
# Number of JVPs to start with
# JDK version supported by this server
Ⅸ. 첨부
# The path to the JRE libraries relative to JVPJAVAHOME
JVPJAVALIB
/bin
# The JRE libraries to use for the Java VM
JVPJAVAVM
jsig:hpi:jvm:java:net:zip:jpeg
# use JVPARGS to change Java VM configuration
#To display jni call
#JVPARGS
-verbose:jni
# Classpath to use upon Java VM start-up (use _g version for debugging)
#JVPCLASSPATH
/usr/informix/extend/krakatoa/krakatoa_g.jar:/usr/informix/extend/krakatoa/jdbc_g.jar
JVPCLASSPATH /usr/informix/extend/krakatoa/krakatoa.jar:/usr/informix/extend/krakatoa/jdbc.jar
# The following parameters are related to the buffer pool
#BUFFERPOOL
default,buffers=1000,lrus=8,lru_min_dirty=50,lru_max_dirty=60
BUFFERPOOL
size=2k,buffers=50000,lrus=8,lru_min_dirty=50,lru_max_dirty=60
END
감사합니다
ありがとう(ございます)
謝謝
Thank you
Danke
Gracias
Merci
Спасибо
Dhanyavaad
Dankon