SUSE11SP2 LINUX 系统安装Informix过程Word格式文档下载.docx

SUSE11SP2 LINUX 系统安装Informix过程Word格式文档下载.docx

《SUSE11SP2 LINUX 系统安装Informix过程Word格式文档下载.docx》由会员分享，可在线阅读，更多相关《SUSE11SP2 LINUX 系统安装Informix过程Word格式文档下载.docx（24页珍藏版）》请在冰点文库上搜索。

$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 

#Offsetintomirroreddevice（Kbytes）

#PhysicalLogConfiguration

PHYSDBS 

#Location（dbspace）ofphysicallog

PHYSFILE 

2000 

#Physicallogfilesize（Kbytes）

#LogicalLogConfiguration

LOGFILES 

6 

#Numberoflogicallogfiles

LOGSIZE 

#Logicallogsize（Kbytes）

LOG_BACKUP_MODEMANUAL#Logicallogbackupmode（MANUAL,CONT）

#TablespaceTablespaceConfigurationinRootDbspace

TBLTBLFIRST 

#Firstextentsize（Kbytes）（0=default）

TBLTBLNEXT 

#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 

#Logtapedevicepath

LTAPEBLK 

#Logtapeblocksize（Kbytes）

LTAPESIZE 

10240#Maxamountofdatatoputonlogtape（Kbytes）

#Optical

STAGEBLOB 

#InformixDynamicServerstagingarea

#SystemConfiguration

SERVERNUM 

#UniqueidcorrespondingtoaOnLineinstance

DBSERVERNAME 

cmsserver 

#默认的数据库名称databasename

DBSERVERALIASES 

#Listofalternatedbservernames

#NETTYPE 

#Configurepollthread（s）fornettype

DEADLOCK_TIMEOUT 

60 

#Maxtimetowaitoflockindistributedenv.

RESIDENT 

#Forcedresidencyflag（Yes=1,No=0）

MULTIPROCESSOR0 

#0forsingle-processor,1formulti-processor

NUMCPUVPS 

1 

#Numberofuser（cpu）vps

SINGLE_CPU_VP 

#Ifnon-zero,limitnumberofcpuvpstoone

NOAGE 

#Processaging

AFF_SPROC 

#Affinitystartprocessor

AFF_NPROCS 

#Affinitynumberofprocessors

#SharedMemoryParameters

LOCKS 

200000 

最大锁数量

NUMAIOVPS 

#NumberofIOvps

PHYSBUFF 

#Physicallogbuffersize（Kbytes）

LOGBUFF 

#Logicallogbuffersize（Kbytes）

CLEANERS 

#Numberofbuffercleanerprocesses

SHMBASE 

0x44000000 

#Sharedmemorybaseaddress

SHMVIRTSIZE 

8192 

#initialvirtualsharedmemorysegmentsize

SHMADD 

8192#Sizeofnewsharedmemorysegments（Kbytes）

EXTSHMADD 

8192#Sizeofnewextensionsharedmemorysegments（

Kbytes）

SHMTOTAL 

#Totalsharedmemory（Kbytes）.0=>

unlimited

CKPTINTVL 

300 

#Checkpointinterval（insec）

TXTIMEOUT 

0x12c 

#Transactiontimeout（insec）

STACKSIZE 

#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 

#Defaultnumberofonlineworkerthreads

#DataReplicationVariables

#DRAUTO:

0manual,1retaintype,2reversetype

DRAUTO 

#DRautomaticswitchover

DRINTERVAL 

30 

#DRmaxtimebetweenDRbufferflushes（insec）

DRTIMEOUT 

#DRnetworktimeout（insec）

DRLOSTFOUND 

/opt/informix/etc/dr.lostfound 

#DRlost+foundfilepath

DRIDXAUTO 

#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 

#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 

#Dumpacopyofsharedmemory

DUMPGCORE 

#Dumpacoreimageusing'

gcore'

DUMPCORE 

#Dumpacoreimage（Warning:

thisabortsOnLine）

DUMPCNT 

#Numberofsharedmemoryorgcoredumpsfor

#asingleuser'

ssession

FILLFACTOR 

90 

#Fillfactorforbuildingindexes

#methodfor