ITPub博客

首页 > Linux操作系统 > Linux操作系统 > install altibase4 on hp-unix B11.31

install altibase4 on hp-unix B11.31

原创 Linux操作系统 作者:BTxigua 时间:2008-12-25 10:31:07 0 删除 编辑

install altibase4 on hp-unix B11.31

------------------------------------------------------------------
STEP 1.Checking and Modify the Hardware(and Software) Requirements
------------------------------------------------------------------
1. Hp 11.31 patch list:
# uname -a
HP-UX rx8640 B.11.31 U ia64 1642983245 unlimited-user license
# swlist -l patch | grep pthread
# PHCO_38050                            1.0            pthread library

cumulative patch
要求PHCO_38050>PHCO_37xxx

2. 检查CPU和屋里内存
# machinfo
CPU info:
 16 Intel(R) Itanium 2 9000 series processors (1.6 GHz, 18 MB)
          533 MT/s bus, CPU version C2
          32 logical processors (2 per socket)

Memory: 163578 MB (159.74 GB)

Firmware info:
   Firmware revision:  9.022
   FP SWA driver revision: 1.18
   IPMI is supported on this system.
   BMC firmware revision: 3.01

Platform. info:
   Model:                  "ia64 hp server rx8640"
   Machine ID number:      61edef4d-00a3-11dd-ae53-47fad261e3ba
   Machine serial number:  SGH48086TJ

OS info:
   Nodename:  rx8640
   Release:   HP-UX B.11.31
   Version:   U (unlimited-user license)
   Machine:   ia64
   ID Number: 1642983245
   vmunix _release_version:              
@(#) $Revision: vmunix:    B.11.31_LR FLAVOR=perf

3.Kernal
sam
 ->Kernel Configuration
  ->t - Tunables
修改下列参数:  
shmmax = physical memory size
shmmni 500 or more.
shmseg 200 or more
semmap semmni + 1
semmni 1000
semmns 4096
semmnu = semmni
semume = semmni
max_thread_proc 600 or more.
maxusers 64 or more
maxdxiz 1G ; For 32bit application, it will be applied
maxdsiz_64bit > Maximum DB size ; 可设置为物理内存大小
修改完成后重启主机。


4. Filesystem
/home/alibase 5G
/altibase_dbs0 160G
/altibase_dbs1 160G
/altibase_log  100G

注意:
/altibase_dbs0 和 /altibase_dbs1 目录要以 direct I/O 方式 mount:
#mount -o mincache=direct,convosync=direct /dev/altibase_dbs0/altibase_dbs0

/altibase_dbs0
/altibase_log 目录不能以direct I/O方式 mount。
------------------------------------------------------------------
STEP 2.Creating Required Operating System Groups and Users
------------------------------------------------------------------
1)Create user.
mkdir /home/altibase
useradd -g users -d /home/altibase altibase
chown -R altibase:users /home/altibase/

2)Create profile
su - altibase
vi .profile
export ALTIBASE_HOME=$HOME/altibase_home

export

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}/usr/local/lib:/usr/lib:$ALTIBASE_HOME/lib
export LD_LIBRARY_PATH_64=${LD_LIBRARY_PATH}:/usr/local/lib:${HOME}/odbc/lib

export

PATH=/usr/local/bin:~/bin:${PATH}:/usr/sbin:/usr/ccs/bin:${HOME}/odbc/bin
export PATH=${PATH}:$ALTIBASE_HOME/bin:$JAVA_HOME/bin:$ATC_HOME/bin

export TERM=xterm

set -o vi

export PTHREAD_SHARED_MUTEX_OLDSPIN=1
export PTHREAD_DISABLE_HANDOFF=ON
export PTHREAD_FORCE_SCOPE_SYSTEM=1
export PERF_ENABLE=1
export _M_ARENA_OPTS=1:8


------------------------------------------------------------------
STEP 3.下载安装软件包
------------------------------------------------------------------
1)上传软件包altibase-IA64_HP_HPUX_11.31-64bit-4.3.9.127-release-aCC.tgz
cd /home/altibase
mkdir pkg
cd pkg
ftp

2)解压
$cd /home/altibase
$mkdir altibase_4.3.9.127
$ln -s altibase_4.3.9.127 altibase_home
$cd altibase_home
$cp ../pkg/*.tgz ./
$gzip -cd *.tgz | tar -xvf -

3)修改altibase.properties
vi $ALTIBASE_HOME/conf/altibase.properties
MEM_DB_DIR    =  /altibase_dbs0
MEM_DB_DIR    =  /altibase_dbs1
LOGANCHOR_DIR =  /altibase_logs
LOGANCHOR_DIR =  /altibase_logs
LOGANCHOR_DIR =  /altibase_logs
MEM_MAX_DB_SIZE  =  120G
AUTO_COMMIT = 0
QUERY_TIMEOUT  = 600
FETCH_TIMEOUT  = 60
UTRANS_TIMEOUT = 3600
IDLE_TIMEOUT   = 0

4)获取license
vi $ALTIBASE_HOME/conf/license
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
license根据hostid和有效期由altibase提供。

------------------------------------------------------------------
STEP 4.建库
------------------------------------------------------------------
$server create
详细的过程可以见$ALTIBASE_HOME/bin/server脚本


手工创建的过程如下:
isql -u sys -p manager -sysdba
iSQL(sysdba)>startup process
iSQL(sysdba)>create database mydb initsize=50M noarchivelog ;
 

启动
server start


 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10867315/viewspace-521190/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-31

  • 博文量
    101
  • 访问量
    282738