SUSE11SP2 LINUX 系统安装Informix过程.docx
- 文档编号:1912886
- 上传时间:2023-05-02
- 格式:DOCX
- 页数:24
- 大小:1.06MB
SUSE11SP2 LINUX 系统安装Informix过程.docx
《SUSE11SP2 LINUX 系统安装Informix过程.docx》由会员分享,可在线阅读,更多相关《SUSE11SP2 LINUX 系统安装Informix过程.docx(24页珍藏版)》请在冰点文库上搜索。
SUSE11SP2LINUX系统安装Informix过程
SUSE11下安装INFORMIX数据库过程记录
说明
之前偶尔用一下informix,没有真正接触,最近装了几台PCServer,准备把INFORMIX安装起来,后续可以把其他小型机的数据库移到linux上来,把小型机尽量作为应用主机。
一、准备
软件:
ids11.50fc5linuxX86.tar---从服务器上下载240M多
环境:
/INFORMIX---归属informix用户和用户组
informix用户组
informix用户
二、安装过程
解压安装包
配置环境变量
环境变量配置了字符集,如果使用客户端工具DbVisualizer进行连接,中文查询会出现乱码,驱动属性必须配置一个参数NEWCODESET,参数值:
GBK,8859-1,819
如图
安装数据库,用于也是图像界面安装,需要Xmanager等工具协助。
必须root用户安装
这步可能报错,如下:
解决方法:
目录要和informix的home目录一致
默认安装
安装过程可能错误要求安装libncurses.so.5
则必须下载ncurses-libs-5.7-3.20090208.el6.i686.rpm安装,重新安装
由于是测试库,为了管理方便,按照默认,不分开了
默认
使用默认配置,需要再修改
安装完成,提示设置信息
三、配置
新建etc/onconfig.tramsserver文件,根据$INFORMIXDIR/etc/onconfig.std模板进行,内
容如下:
$cd
$cdetc
$cponconfig.stdonconfig.tramsserver
$vionconfig.tramsserver
#Root数据库空间配置
ROOTNAME rootdbs #Root数据库空间名
ROOTPATH /opt/informix/data/rootdbs #Root数据库空间路径
ROOTOFFSET 100 # 偏移量(Kbytes)
ROOTSIZE 1000000 # 空间大小(Kbytes)
#DiskMirroringConfigurationParameters
MIRROR 0 #Mirroringflag(Yes=1,No=0)
MIRRORPATH #Pathfordevicecontainingmirroredroot
MIRROROFFSET 0 #Offsetintomirroreddevice(Kbytes)
#PhysicalLogConfiguration
PHYSDBS rootdbs #Location(dbspace)ofphysicallog
PHYSFILE 2000 #Physicallogfilesize(Kbytes)
#LogicalLogConfiguration
LOGFILES 6 #Numberoflogicallogfiles
LOGSIZE 2000 #Logicallogsize(Kbytes)
LOG_BACKUP_MODEMANUAL#Logicallogbackupmode(MANUAL,CONT)
#TablespaceTablespaceConfigurationinRootDbspace
TBLTBLFIRST 0 #Firstextentsize(Kbytes)(0=default)
TBLTBLNEXT 0 #Nextextentsize(Kbytes)(0=default)
#Security
#DBCREATE_PERMISSION:
#Bydefaultanyusercancreateadatabase.UncommentDBCREATE_PERMISSONto
#limitdatabasecreationtoaspecificuser.AddanewDBCREATE_PERMISSION
#lineforeachpermitteduser.
#DBCREATE_PERMISSION informix
#DB_LIBRARY_PATH:
#Whenloadinga(CorC++)sharedobject(foraUDRorUDT),IDSchecksthat
#theuser-specifiedpathstartswithoneofthedirectoryprefixeslistedin
#thecomma-separatedlistofprefixesinDB_LIBRARY_PATH.Thestring
#"$INFORMIXDIR/extend"mustbeincludedinDB_LIBRARY_PATHinorderfor
#extensibilityandIBMsuppliedbladestoworkcorrectly.
#DB_LIBRARY_PATH$INFORMIXDIR/extend
#IFX_EXTEND_ROLE:
#0(oroff)=>DisableuseofEXTENDroletocontrolwhocanregister
# externalroutines.
#1(oron)=>EnableuseofEXTENDroletocontrolwhocanregister
# externalroutines.Thisisthedefaultbehaviour.
#
IFX_EXTEND_ROLE1#TocontroltheusageofEXTENDrole.
#Diagnostics
MSGPATH /opt/informix/log/online.log #系统日志文件路径
CONSOLE /dev/console #Systemconsolemessagepath
#Toautomaticallybackuplogicallogs,editalarmprogram.shandset
#BACKUPLOGS=Y
ALARMPROGRAM /opt/informix/etc/alarmprogram.sh #警告程序路径
ALRM_ALL_EVENTS0 #TriggersALARMPROGRAMforanyeventoccur
TBLSPACE_STATS1 #Maintaintblspacestatistics
#SystemArchiveTapeDevice
TAPEDEV /dev/null #Tapedevicepath
TAPEBLK 32 #Tapeblocksize(Kbytes)
TAPESIZE 10240 #Maximumamountofdatatoputontape(Kbytes)
#LogArchiveTapeDevice
LTAPEDEV /dev/null #Logtapedevicepath
LTAPEBLK 32 #Logtapeblocksize(Kbytes)
LTAPESIZE 10240#Maxamountofdatatoputonlogtape(Kbytes)
#Optical
STAGEBLOB #InformixDynamicServerstagingarea
#SystemConfiguration
SERVERNUM 0 #UniqueidcorrespondingtoaOnLineinstance
DBSERVERNAME cmsserver #默认的数据库名称databasename
DBSERVERALIASES #Listofalternatedbservernames
#NETTYPE #Configurepollthread(s)fornettype
DEADLOCK_TIMEOUT 60 #Maxtimetowaitoflockindistributedenv.
RESIDENT 0 #Forcedresidencyflag(Yes=1,No=0)
MULTIPROCESSOR0 #0forsingle-processor,1formulti-processor
NUMCPUVPS 1 #Numberofuser(cpu)vps
SINGLE_CPU_VP 0 #Ifnon-zero,limitnumberofcpuvpstoone
NOAGE 0 #Processaging
AFF_SPROC 0 #Affinitystartprocessor
AFF_NPROCS 0 #Affinitynumberofprocessors
#SharedMemoryParameters
LOCKS 200000 # 最大锁数量
NUMAIOVPS #NumberofIOvps
PHYSBUFF 32 #Physicallogbuffersize(Kbytes)
LOGBUFF 32 #Logicallogbuffersize(Kbytes)
CLEANERS 1 #Numberofbuffercleanerprocesses
SHMBASE 0x44000000 #Sharedmemorybaseaddress
SHMVIRTSIZE 8192 #initialvirtualsharedmemorysegmentsize
SHMADD 8192#Sizeofnewsharedmemorysegments(Kbytes)
EXTSHMADD 8192#Sizeofnewextensionsharedmemorysegments(
Kbytes)
SHMTOTAL 0 #Totalsharedmemory(Kbytes).0=>unlimited
CKPTINTVL 300 #Checkpointinterval(insec)
TXTIMEOUT 0x12c #Transactiontimeout(insec)
STACKSIZE 32 #Stacksize(Kbytes)
#DynamicLogging
#DYNAMIC_LOGS:
# 2:
serverautomaticallyaddanewlogicallogwhennecessary.(ON)
# 1:
notifyDBAtoaddnewlogicallogswhennecessary.(ON)
# 0:
cannotaddlogicallogonthefly.(OFF)
#Whendynamicloggingison,wecanhavehighervaluesforLTXHWM/LTXEHWM,
#becausetheservercanaddnewlogicallogsduringlongtransactionrollback.
#However,tolimitthenumberofnewlogicallogsbeingadded,LTXHWM/LTXEHWM
#canbesettosmallervalues.
#
#Ifdynamicloggingisoff,LTXHWM/LTXEHWMneedtobesettosmallervalues
#toavoidlongtransactionrollbackhangingtheserverduetolackoflogical
#logspace,i.e.50/60orlower.
#
#IncaseofsystemconfiguredwithCDR,thedifferencebetweenLTXHWMand
#LTXEHWMshouldbeatleast30%sothatwecouldminimizelogoverrunissue.
DYNAMIC_LOGS 2
LTXHWM 70
LTXEHWM 80
#SystemPageSize
#BUFFSIZE-OnLinenolongersupportsthisconfigurationparameter.
# TodeterminethepagesizeusedbyOnLineonyourplatform
# seethelastlineofoutputfromthecommand,'onstat-b'.
#RecoveryVariables
#OFF_RECVRY_THREADS:
#Numberofparallelworkerthreadsduringfastrecoveryoranofflinerestore.
#ON_RECVRY_THREADS:
#Numberofparallelworkerthreadsduringanonlinerestore.
OFF_RECVRY_THREADS 10#Defaultnumberofofflineworkerthreads
ON_RECVRY_THREADS 1 #Defaultnumberofonlineworkerthreads
#DataReplicationVariables
#DRAUTO:
0manual,1retaintype,2reversetype
DRAUTO 0 #DRautomaticswitchover
DRINTERVAL 30 #DRmaxtimebetweenDRbufferflushes(insec)
DRTIMEOUT 30 #DRnetworktimeout(insec)
DRLOSTFOUND /opt/informix/etc/dr.lostfound #DRlost+foundfilepath
DRIDXAUTO 0 #DRautomaticindexrepair.0=off,1=on
#CDRVariables
CDR_EVALTHREADS1,2 #evaluatorthreads(per-cpu-vp,additional)
CDR_DSLOCKWAIT5 #DSlockwaittimeout(seconds)
CDR_QUEUEMEM 4096 #MaximumamountofmemoryforanyCDRqueue(Kbytes)
CDR_NIFCOMPRESS0#Linklevelcompression(-1never,0none,9max)
CDR_SERIAL 0,0 #SerialColumnSequence
CDR_DBSPACE #dbspaceforsyscdrdatabase
CDR_QHDR_DBSPACE #CDRqueuedbspace(defaultsameascatalog)
CDR_QDATA_SBSPACE #ListofCDRqueuesmartblobspaces
#CDR_MAX_DYNAMIC_LOGS
#-1=>unlimited
#0=>disabledynamiclogaddition
#>0=>limittheno.ofdynamiclogadditionswiththespecifiedvalue.
#MaxdynamiclogrequeststhatCDRcanmakewithinoneserversession.
CDR_MAX_DYNAMIC_LOGS 0#Dynamiclogadditiondisabledbydefault
#Backup/Restorevariables
BAR_ACT_LOG /opt/informix/bar_act.log #ON-BarLogfile-notin/tmpplease
BAR_DEBUG_LOG/opt/informix/bar_dbug.log #ON-BarDebugLog-notin/tmpplease
BAR_MAX_BACKUP0
BAR_RETRY 1
BAR_NB_XPORT_COUNT20
BAR_XFER_BUF_SIZE31
RESTARTABLE_RESTORE ON
BAR_PROGRESS_FREQ 0
#InformixStorageManagervariables
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs
#ReadAheadVariables
RA_PAGES #Numberofpagestoattempttoreadahead
RA_THRESHOLD #Numberofpagesleftbeforenextgroup
#DBSPACETEMP:
#OnLineequivalentofDBTEMPforSE.Thisisthelistofdbspaces
#thattheOnLineSQLEnginewillusetocreatetemptablesetc.
#Ifspecifieditmustbeacolonseparatedlistofdbspacesthatexist
#whentheOnLinesystemisbroughtonline.Ifnotspecified,orif
#alldbspacesspecifiedareinvalid,variousadhocquerieswillcreate
#temporaryfilesin/tmpinstead.
DBSPACETEMP tmpdbs #Defaulttempdbspaces
#DUMP*:
#Thefollowingparameterscontrolthetypeofdiagnosticsinformationwhich
#ispreservedwhenanunanticipatederrorcondition(assertionfailure)occurs
#duringOnLineoperations.
#ForDUMPSHMEM,DUMPGCOREandDUMPCORE1meansYes,0meansNo.
DUMPDIR /opt/informix/tmp #Preservediagnosticsinthisdirectory
DUMPSHMEM 1 #Dumpacopyofsharedmemory
DUMPGCORE 0 #Dumpacoreimageusing'gcore'
DUMPCORE 0 #Dumpacoreimage(Warning:
thisabortsOnLine)
DUMPCNT 1 #Numberofsharedmemoryorgcoredumpsfor
#asingleuser'ssession
FILLFACTOR 90 #Fillfactorforbuildingindexes
#methodfor
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SUSE11SP2 LINUX 系统安装Informix过程 系统 安装 Informix 过程