install altibase4 on hp-unix B11.31

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10867315/viewspace-521190/