INIX ONLINE 7.23数据库在SCO UNIX上的安装.doc

INFORMIX ONLINE 7.23数据库在SCO UNIX上的安装在sco unix 安装过程中已在前面的贴子中详细描述过，同时安装informix数据库需注意的问题：系统进入初始化系统特性定制屏幕的选择Standard Enterprise System Configuration： YesLightweight character terminal configuration： NOIf you run large database products, choose the followingDatabase services: YesAccept above choices.建议使用系统默认设置。如果您使用的时高亮度字符终端，则将第二个设置项的NO改为YES。如果您将使用一个独立的UNIX分区作为数据库空间，请将Database services选项置为YES。这样可以利用系统对数据库的管理功能，加快对数据库的操作。自然，您也可以不设置对数据库服务的支持。INFORMIX ONLINE 7.23数据库安装一. 建立informix 用户1. 以root用户注册, 执行命令:# sysadmsh 回车, 进入系统维护界面.依次进入 account user create , 进入用户创建界面.屏幕提示:用户名: user name informix;注释 comment 可以为空;修改缺省项 modify default yes no: 选择”YES”;进入用户详细项目设置:login group 选择: specify 输入: informix;group 回车确定;login shell 选择缺省设置: sh;Home directory 选择缺省设置: /usr/informix;User ID number 选择缺省设置;Type of user 选择缺省设置;输入完毕 , 系统提示选择: examine yes no选择:yes 确定创建用户;系统提示给用户指定口令选择:now later remove 选择:later; 以后指定口令;用户创建完毕, 退出sysadmsh;在”#”号提示符下,执行命令:# passwd informix 回车, 输入指定的口令.二. 修改informix 用户的 profile 文件 以informix 用户注册, 用 vi 打开 .profile 文件, 增加下列环境变量: INFORMIXDIR=/usr/informix PATH=$PATH:$INFORMIXDIR:$INFORMIXDIR/bin:. INFORMIXSERVER=pthk DBDATE=Y4MD/ LANG=english_us.8859 DBNLS=2 ONCONFIG=onconfig.pthk WORKDIR=/usr/informix HOMEDIR=/usr/informix Export INFORMIXDIR PATH INFORMIXSERVER DBDATE LANG DBNLS ONCONFIG WORKDIR HOMEDIR三. esql 和 online的安装以 root 用户注册, 进入 informix 用户目录:# cd /usr/informix执行命令:# . ./.profile使informix 环境变量生效;将esql 的安装文件拷贝到当前目录下:用 tar 或 cpio 命令(根据安装文件类型而定); #tar cf (文件名) #cpio icuvdmB I (文件名.cpi)执行esql 的安装程序:# ./installesql 根据屏幕提示输入正确的序列号 (serial number) 和活动码 (active number);完成esql 的安装;将 online 的安装文件拷贝到当前目录下:用 tar 或cpio 命令(根据安装文件类型而定);将安装文件展开;执行 online 的安装程序:# ./installonline根据屏幕提示输入正确的序列号 (serial number) 和活动码 (active number);完成 online 的文件安装;四. online 的配置1. 修改 unix 核心参数以 root 注册;参考文件：/usr/informix/release/ONLINE_7.1 修改文件：/etc/conf/cf.d/mtune ;使mtune文件中与 ONLINE_7.1文件提示对应项参数值一致。执行命令:# sysadmsh 进入系统维护界面, 依次进入 system config kernel 选择 1: kernel paraments; 进入 unix 核心参数维护选项; 参考 /usr/informix/release/ONLINE_7.1 文件提供的参数值修改对应选项的对应值;修改完毕后, 保存参数值, 退出 kernel paraments;选择 2: rebuild kernel: 重链核心; 用 vi 编辑器修改文件: /etc/services, 在文件最后加上:pthk 2345/tcp核心链接完毕, 退出 sysadmsh , 重新启动计算机; 2. 配置 online 以 informix 用户注册; 1).用vi 编辑器修改文件: /usr/informix/etc/sqlhosts, 在文件最后两行头处加 “#” 屏蔽掉, 另外加上一行: pthk onipcshm scosysv pthk2).创建 informix 数据库文件 执行命令: $ mkdir dbs $ /usr/informix/dbs/rootchunk $ chmod 660 /usr/informix/dbs/rootchunk3). 配置 online 参数 运行配置程序: onmonitor $ onmonitor 依次进入 parameters initialize 参考下列提供的配置参数进行配置:INITIALIZATION: make desired changes and press ESC to record changes.Press interrupt to abort changes. Press F2 or CTRL+ for field-level help.Page size 2K kbytes Mirror nTape dev. /dev/null Block Size 16KbytesTotal Tape Size 10240KbytesLog Tape dev. /dev/null Block Size 16KbytesTotal Tape Size 10240Kbytes Primary path /usr/informix/dbs/rootchunk mirror path mirror offset 0 kbytes phy.log size 10000 kbytes log.log size 5000 kbytes number of logical logs 6 SHARED MEMORY:Make desired changes and press ESC To record changes.Press Interrupt to abort changes.press F2 or CTRL-F for Field-level help.SHARED MEMORY PARAMETERS Server Number 0Server Name pthk Server Aliases Dbspace Temp Deadlock Timeout 60 secsNumber of page Cleaners 4Forced Residency NStack size (kbytes) 32Non Res.Segsize (kbytes)16000Physical Log Buffer Size 32 kbytesLogical Log Buffer Size 32 kbytesMax # of Logical Logs 12Transaction Timeout 300Max # of Transaction 20Long TX HWM 50Max # of Userthreads 20Long TX HWM Exc lusive60Max # of locks 10000Index page Fill Factor 90Max # of Buffers 2000Add SegSize (Kbytes) 8192Max # of Chunks 8Total Memory (Kbytes) 0Max # of Open Tb Lspaces200Max # of Dbspaces 12Resident Shared Memory Size 1192 Kbytes Page Size2KbytesPERFORMANCE:Make desired changes and press ESC to Record changesPress Interrupt to abort changes.Press F2 or CTRL-F for Field-level help. PERFORMANCE TUNING PARAMETERMultiprocessor Machine NLRU Max Dirty 60Num procs to Affinity 0LRU Min Dirty 50Proc num to start with 0Checkpoint Interval 1200Num of Read Ahead Pages 16CPU VPS 1Read Ahead Threshold 8AIO Vps 3Single CPU VP yNETTYPE settings Use OS Time NDisable Priority Aging NOff-Line Recovery Threads20On-line Recovery Threads 1Num of LRUS queues 6 NETTYPE settingProtorcol Threads Users VP-classipcshm 1 20 cpu DATA REPLICATION:Make desired changes and press ESC to record changes.Press Interrupt to ablrt changes.press F2 or CTRL-F for Field-level help.DATA REPLICATION:Make desired changes and press ESC to record changes.Press Interrupt to abort changes. Press F2 or CTRL-F forField-level help.DATA REPLICATION PARAMETERSInterval 30Timeout 30Auto 0Lost & Found/usr/informix/etc/dr.lostfound DIAGNOSTIOS:Make desred changes and press ESC to Record changes.Press Interrupt to abort changes.press F2 or CTRL-F forField-level help.DIAGNOSTICP ARAMETERSMessage Log /usr/informix/online.log Console Msgs./dev/tty12 Alarm program Dump Shared Memory YDump core NDump core NDump Count 1Dump Directory /tmp PDQ:Make desired changes and press ESC to record Changes.Press Interrupt to abort changes. press F2 or CTRL-F forField-level help.PARALLEL DATABASE QUERIES PARAMETERSPDQ Priority 0Max PDQ Priority 100Decision Support Queries Decision Support Memory (kbtyes) Maximum Decision Support Scans 1048576Dataskip off Optimizer Hint 0参数配置完毕,按ESC退出后根据屏幕提示，键入Y初始化数据库.数据库初始化完毕, 用 ”root” 用户注册, 执行命令:# cd /dev;# chown informix rdata rlog1;# chgrp informix rdata rlog1;# chmod 777 rdata rlog1;修改存放数据的数据库设备和存放日志的日志库设 备的访问属性和执行权限. 4) 配置存放数据的数据库.运行数据库应用程序: onmonitor $ onmonitor 依次进入dbspaces create CREATE DBSPACEDbspace Name datadbs MirrorNTempNPRIMARY CHUNK INFORMATION:Full pathname /dev/rdata Offset 0 kbytes Size 500000kbytesMIRROR CHUNK INFORMATION:Full Pathname Offset 0 kbytes 5) 配置日志库,使日志存放于日志库中 运行数据库应用程序: onmonitor $ onmonitor 依次进入dbspaces create CREATE DBSPACE Dbspace Name logdbs MirrorN TempNPRIMARY CHUNK INFORMATION: Full pathname /dev/rlog1 Offset 0 kbytes Size 500000kbytesMIRROR CHUNK INFORMATION:Full Pathname Offset 0 kbytes创建完日志库, 返回 onmonitor 主菜单, 依次进入: parameters physical log;在 dbspace name 栏中键入 “logdbs”;按 “ESC” 键改变 physical_log;退出 onmonitor ;执行命令;$ onmode s;进入单用户维护模式, 执行命令:$ onparams a d logdbs; 在日志库中增加一个逻辑日志, 用户可根据需要自行增减;减少日志可执行命令: $ onparams d d rootdbs日志增加完毕, 执行命令:$ ontape s ; 使增加的日志处于可用状态, 随后可进入多用户模式, 执行命令:$ onmode m ;完成 online 配置. 下面给出数据库配置文件 onconfig.pthk 的推荐配置参数, 用户如有不明之处, 可用 vi 编辑器打开 /usr/informix/etc/onconfig.pthk 文件, 按下面的参数手工修改( 注: 一定要在数据库和日志库创建完毕方可进行 !).# INFORMIX SOFTWARE,INC. # Title: onconfig.std # Description: # INFORMIX-Online Configuration Parameters # Root Dbspace Configuration ROOTNAME rootdbs# Root dbspace nameROOTPATH /usr/informix/dbs/rootchunk# Path for device containing root dbspaceROOTOFFSET 0 # Offset of root dbspace into device (kbytes)ROOTSIZE 600000 # Size of root dbspace (kbytes)# Disk Mirroring Confinguration Parameters MIRROR 0 # Mirroring flag(Yes=1,NO=0)MIRRORPATH # Path for device containing mirrored rootMIRROROFFSET 0 # Offset into mirrored device (kbytes)# physical Log ConfigurationPHYSDBS logdbs # Location (dbspace) of physical logPHYSFILE 20000 # physical log file size (kbytes)# Logical Log Configuration LOGFILES 9 # Number of logical log filesLOGSIZE 2500 # Logical log size (kbytes)# DiagnosticsMSGPATH /usr/informix/online.log# System message log file pathCONSLOE /dev/tty12 # System console message pathALARMPROGRAM # Alarm program path# System Archive Tape Device TAPEDEV /dev/null # Tape device pathTAPEBLK 16 # Tape block size (kbytes)TAPESIZE 10240 # Maxinum amount of data to put on tape (kbytes)LTAPEDEV /dev/null # Log tape device pathLTAPEBLK 16 # Log tape block size (kbytes)LTAPESIZE 10240 # Maxinum amount of data to put on log tape (kbytes)#OpticalSTAGEBLOB # INFORMIX-Online/Optical staging area# System configurationSERVERNUM 0# Unique id corresponding to a Online instanceDBSERVERNAME pthk# Name of default database serverDBSERVERALIASES# list of alternate dbservernamesNETTYPE ipcshm,1,20,cpu# Override sqlhosts nettype parametersDEADLOCKTIMEOUT 60# Max time to wait of lock in distributed env.RESIDENT 0# Forced residency flag(yes=1,No=0)MULTIPROCESSOR 0# 0 for single-processor,1 for multi-processorNUMCPUVPS 1# Number of user (cpu) vpsSINGLE_CPU_VP 1# If non-zero,Limit number of cpu vps to one NOAGE 0# Process agingAFF_SPROC 0# Affinity start processorAFF_NPROCS 0# Affinity number of processors# shared Memory of parameters USERTHREADS 20# Maximum number of concurrent threadsTRANSACTIONS 20# Maximum number of concurrent transactionsLOCKS 10000# Maximum number of locksBUFFERS 2000# Maximum number of shared buffersTBLSPACES 200# Maximum number of open tblspacesCHUNKS 8# Maximum number of chunksNUMAIOVPS 6# Maximum of IO vpsDBSPACES 12# Maximum number of dbspacesPHYSBUFF 32# physical log buffer size(kbytes)LOGBUFF 32# Logical Log buffer size(kbyter)LOGSMAX 12# Maxinum number of logical log filesCLEANERS 4# Number of buffer cleaner processesSHMBASE 0X0# Shared memory base addressSHMVIRTSIZE 16000# initial virtual shared memory segment sizeSHMADD 8192# Size of new shared memory segment (kbytes)SHMTOTAL 0# Total Shared memory (kbytes).0=unlimitedCKPTINTVL 1200# Check point interval(in sec)LRUS 6# Number of LRU queuesLRU_MAX_DIRTY 60# LRU Percent dirty begin cleaning limitLRU_MIN_DIRTY 50# LRU Percent dirty end cleaning limitLTXHWM 50# Long transaction high water mark percentageLTXEHWM 60# Long transaction high water mark (exclusive)TXTIMEOUT 0x12c# Transaction timeout (in sec)STACKSIZE 32# Stack size (kbytes)# 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 20 # Default number of offline worker threadsON_RECVRY_THREADS 1 # Default number of Online worker threads# Data Replication Variables# DRAUTO:0 manual,1 retain type,2 reverse typeDRAUTO 0# dr automatic switchoverDRINTERVAL 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# Read Ahead VariablesRA_PAGES 32# Number of pages to attempt to read aheadRA_THRESHOLD 32# Number of pages left before next group# DBSPACETEMP:# Online equivalent of BDTEMP 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 sypcified of if # all dbspaces specified are invalid various ad hoc queries will create# temporary files in/tmp instead.DBSPACETEMP# 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 end DUMPCORE 1 means Yes,0 means NO.DUMPDIR /tmp# preserve diagnostics in this directoryDUMPSHMEM 1# Dump a copy of shared memoryDUMPGCORE 0# Dump a core image using “gcore”DUMPCORE 0# Dump a core image (Warning:this aborts online)DUMPCNT 1# Number of shared memory of gcore dumps for# a single users session# ADT*# The following parameters control the t