SCO UNIX 5.06 Informix Online 7.31 Installation and Configuration Document (1)
Guoshou Zhejiang Branch Information Technology Department
First, install SCO 5.06
1, HP Server TC3100 configuration
Processor Processor Type Intel Pentium III 1.26GHz Bus Speed / Chipset 133MHz Front End Bus L2 Cache Capacity 512KB Built-in L2 Cache Supported Maximum Processor 256MB Standard Error and Correction (ECC) SDRAM Solver Current memory / maximum Memory capacity 1.0GB / 4 × 1.0GB network card network model Intel (r) Pro / 100B / PRO / 100 PCI Adapter hard disk hard disk type SCSI 36GBSCSI card SCSI card model integrated dual channel ULTRA3 SCSI controller
2, installation process
a, start the machine:
Whether starting from the CD or from the floppy disk, the machine will appear the following installation prompt: SCO UNIX OpenServer (TM) 5.0.x boot: * Can you enter this? Query the bootable address or use it.
b, install drive:
Since the machine has a SCSI card, you need to enter the address of the drive package. Defbootstr link = "Amird" SDSK = Amird (0,0,0,0) SROM = WD (0, 0, 0) where link = "amird" points to the name of the driver that needs to be coupled during installation (BTLDS, Bootime loadable driver, SDSK = Amird (0, 0, 0) indicates the location of the system root disk, and several numbers are SCSI adapter numbers, bus number, SCSI ID, logical unit. Number (LUN), SROM = (0, 0, 0, 0) indicates the position of the EIDE (IDE) CDROM. In this case, (n, n, n, n) represents (IDE Controller, Master / Slave, LUN, BUS), the legal value of 0 and 1. In the above example, IDE Controller: 0 = primary, master / slave: 0 = Master, Lun from: 0 (Lun for an eide / ide device is always 0), Bus for an eide / IDE Device IS Always 0).
Note: Amird Drive Download Page: http://h20004.www2.hp.com/keeper_rnotes/bsdmatrix/matrix51915en_us.html file name: pkg_sco5_nr_2144.exe
c and start installing:
(1). The system is detected hardware, waiting for the following tips: (2). Press
The bright strip moves to the top, the carriage return appears: 1. Preservation2. UNIX ONLY3. Customize4. Interactive selection 41. Display patition Table2. Use Entire Disk for UNIX (Over the hard drive to UNIX) 3. Use REST OF DISK for UNIX (putting the remaining space to UNIX) 4. CREATE UNIX PATITION 5. Active (Activate the rigid zone) 6. Delete 7. CREATE (Created) 3 or 4, don't forget to activate the Unix partition ⑽ after the creation. Select Basic Configuration: NetWork Card: * Select NetWork Address: * Press Space to Select Video and Graphics: VGA Mouse: High Resolution Keyboard Mouse * Select Email System: MMDF * Press Space to select other Accept Above Choices. Set the root user password. Scan the bad wavy of the hard drive. Establish a file system. Install the process. Restart the machine D, configure the network card:
(1), login machine:
1. Restart the machine. 2. The system appears: SCO OpenServer TM Release 5 Boot: * Enter 3. System appears: init: Single User Mode Type Control-D To Proceed With Normal Startup, (or Give Root Password for System Maintenance): Enter the root password or press Control-D4. Press Control-D system: SCO OpenServer (TM) Release 5 login: root password: 5. Log in machine, system prompt: #
(2) Configuring a network card
# NetConfig Enter Management Window Hardware> Add New Lan Adapter Select Intel (R) Pro / 100B / Pro / 100 PCI Adapter Compatible - PCI Bus # 0, Device # 0, Function # 0 Protocol> Add ProtoCl Select SCO TCP / IP and then Set Local Host Name IP Address Netmask Broadcast AddRESS
(3) Add Gateway
# cd /etc/rc2.d# vi s96gateway Add to Route Add Default Gateway Address 1 ---------- SCO UNIX 5.06 installation is complete ----------- 2, SCO Install Informix Online 7.31 under UNIX 5.06
Directory: l Create a user, install the software L Set the environment variable 1 Configure SQLHOSTS file L Configure the core parameter L Prepared database space DBSPACEL database initializes l New Tempdbs, DataDBs and Add Chunk
1. Establish Informix Group and Informix users, and use the user directory to copy the installation folder (such as a folder name online), including: esql.cpi sql7.20.cpi 4GL7 .20.cpi ids.cpi lszhcn.tar lincese.txt # Cat Lincese.txt
IDS 7.31.uc5-1 S / N: AAC # j900749 Key: cyjpjxesql / c 7.23.uc13 s / N: AAC # j698416 Key: Qsukkq4gl 7.20.ud7 s / N: aac # j900751 key: hrtpjysql 7.20.ud7 s / n : AAC # j900752 key: AOMXJQ./Installzhc S / N: AAC # j314937 Key: JCXQJV
Load Line: cpio -icdumvb #
Perform cpio -icdumvb
2, informix user login, set the environment variable $ vi /usr/Informix/.profileINFORMIXDIR=/usr/informixINFORMIXSERVER=cld3300b_tcpINFORMIXSERVERALIAS=cld3300b_shmONCONFIG=onconfig.cld3300bexport ONCONFIG INFORMIXDIR INFORMIXSERVER INFORMIXSERVERALIAS
LD_LIBRARY_PATH = $ INFORMIXDIR / lib: $ INFORMIXDIR / lib / esqlCLIENT_LOCALE = zh_cn.gbDB_LOCALE = zh_cn.gb # SERVER_LOCALE = zh_cn.gbDBDATE = y4md / TERMCAP = $ INFORMIXDIR / etc / Termcapexport LD_LIBRARY_PATH CLIENT_LOCALE DB_LOCALE SERVER_LOCALE DBDATE TERMCAP
Term = VT100PATH = $ PATH: $ HOME / BIN: $ informixdir / bin # set command search pathmail = / usr / spool / mail / `logname` # mailbox locationLang = English_us.8859Export Term Path Mail LAN
Note: 1. OnConfig = OnConfig.CLD3300B, the default onconfig = onconfig.std $ CD / USR / INFORMIX / ETC $ c onconfig.std onConfig.CLD3300B2, LANG Sitting: / etc / default, this file contains some characters set name reference: # envCLIENT_LOCALE = zh_cn.gbDBDATE = y4md / DB_LOCALE = zh_cn.gbHOME = / usr / informixHUSHLOGIN = FALSEHZ = 100INFORMIXDIR = / usr / informixINFORMIXSERVER = cld3300b_tcpINFORMIXSERVERALIAS = cld3300b_shmLANG = english_us.8859LD_LIBRARY_PATH = / usr / informix / lib: / usr /informix/lib/esqllogname=informixmail=/usr/spool/mail/informixonfig=onfig.CLD3300BPATH =/bin :/etc:/usr/bin :/tcb/binps1=#shell=/bin/shterm=vt100Termcap=/USR / Informix / etc / termcaptz = EST5EDT
3. Configure SQLHOSTS file $ INFORMIXDIR / ETC / SQLHOSTS The first field of this file contains the value of the DBServerName of the configuration parameter, which can only be one. For the meaning of the DBServerName Nettype Hostname Service, * Nettype's value in the DBServerName onconfig file * Nettype should be set to OnipCSHM for the TLI TCP / IP connection to ONSOCTCP for the Scokets TCP / IP connection * Hostname machine hostname * Servicename file / etc / service service name, useless my settings connected to shared memory, as follows: # dbservername nettype hostname serviceName
CLD3300B_TCP ONTLITCP SURROGAT IFX_SERVICECLD3300B_SHM ONIPCSHM SURROGAT SQLEXEC
# vi / etc / services last added an IFX_Service 23451 / TCP
4, configure core parameters
(1), shared memory configuration
# vi /etc/conf/cf.d/mtune (Unix Default Core Parameters) # vi /etc/conf.d/stune Modify the value, you can replace the default value set in MTUNE
Parameter settings Reference The following documentation: # more /usr/informix/release/en_us/0333/IDS_7.3
The value that needs to be modified is as follows (depending on the case):
Informix-Online Shared Memory Parameters: ======================================= ============ shmmax: 409600000Shmmin: 1shmall: 512SHMMMNI: 100Shmseg: 6
Kernel parameters recommented for informipix online: =========================================== =======
Maxumem: 524287semmni: 8192semmns: 8192semmap: 8192semmnu: 100Semmsl: 25
My configuration is as follows:
NODE "surrogat" NSPTTYS 64EVQUEUES72EVDEVS80NUMSP256NSTREAM 4352NHINODE 1024GPGSLO2000GPGSHI6000PLOWBUFS1024NSTRPAGES6000NAIOPROC20NAIOREQ 400NAIOBUF 400NAIOHBUF 100NAIOREQPP 400NAIOLOCKTBL 50MAX_PROC 10000MAXUMEM 524287NCALL 256NCLIST 512NSTREVENT 14848NUMTIM 1888NUMTRW 1888SDSKOUT 64SEMMAP 8192SEMMNI 8192SEMMNS 8192SEMMSL 150SEMMNU 100SHMMAX 409600000TTHOG 4096SECLUID 0SECSTOPIO 1SECCLEARID 1SHMMIN 1
Note: #vi mtune {This file format is as follows: ... * Shared Memory Parametersshmmax 1048576 131072 80530637SHMMIN 1 1 1 Where: The first list is the unix system parameter name, the second list is the current value of the parameter, the third list is the minimum parameter. Value, the fourth list is the maximum parameter. } Then check each parameter according to the data recorded above, if: I, a. The system parameter name recorded; b. The recorded system parameter value is recorded between the minimum and the maximum value. The parameter value replaces the current value of this parameter. II. If the value of the recorded parameters is greater than the maximum, modify the current value of this parameter is the maximum. III. This parameter value is not modified if the recorded parameter value is less than the minimum.
(2), reconnect the core, make the new core parameters to take into effect: #CD /etc/conf/cf.d#./link_unix system Tips: Do you want this kernel to boot by default? (Y / n) input : YDO you wants? (Y / n) Enter: y # reboot5, prepare database space DBSPACE
(1), the usual way is Raw Device, also known as "naked device", is to create a Non FS partition in the disk partition in the disk partition when installing the UNIX disk, and the size of this partition is pre-estimated. The ONLINE system is much higher than the management efficiency of the "naked device" than the UNIX file system.
When preparing disk space for the system, you must first establish the correct permissions, and it is recommended to establish a connection to the original device, and each CHUNK must not be greater than 2G.
# Divvy -m / dev / rhd02
My configuration is as follows: ---------------- ---------- -------- - - ------------- ---------- | Name | TYPE | New FS | # | First Block | Last Block | ---- -------------- ------------ -------- - -------- ----- ---------- | dbspace00 | EAFS | NO | 0 | 0 | 1999999 || DBSPACE01 | NON FS | NO | 1 | 2000000 | 3999999 | DBSPACE02 | Non FS | NO | 2 | 4000000 | 5999999 || DBSPACE03 | NON FS | NO | 3 | 6000000 | 7999999 || DBSPACE04 | NON FS | NO | 4 | 8000000 | 9999999 | | DBSPACE05 | NON FS | NO | 5 | 10000000 | 11999999 || | NON FS | NO | 6 | 12000000 | 12002696 || HD02 | WHOL DISK | NO | 7 | 0 | 12002696 | ------------------- ------------ -------- - ------------- -------- -
# Divvy -m / dev / rhd03
My configuration is as follows: ---------------- ---------- -------- - - ------------- ---------- | Name | TYPE | New FS | # | First Block | Last Block | ---- -------------- ------------ -------- - -------- ----- ------------ | DBSPACE10 | NON FS | NO | 0 | 0 | 1999999 || DBSPACE11 | NON FS | NO | 1 | 2000000 | 3999999 | | DBSPACE12 | Non fs | no | 2 | 4000000 | 5999999 | | DBSPACE13 | NON FS | NO | 3 | 6000000 | 7999999 | | DBSPACE14 | NON FS | NO | 4 | 8000000 | 9746099 | | DBSPACE15 | NON FS | NO | 5 | 10000000 | 11695000 || | NOT USED | NO | 6 | - | - || D1037 AlL | Whole Disk | No | 7 | 0 | 11695823 | ------------------- ---------- ------ - ------------ --------- --- In / dev directory, 12 districts of RDBSpace00 - Rdbspace05 and RDBSpace 10 - Rdbspace15 are automatically generated. # Chown Informix: Informix Rdbspace * # chmod 660 RDBSPACE *
(2) Establish a connection
# MKDIR / DBSPACES # cd dbspaces $ ln -s chunk00 / dev / rdbspace00, etc.
My connection is as follows: lrwxrwrwx 1 root sys 15 nov 14 09:44 chunk00 -> / dev / rdbspace00LRWXRWXRWX 1 root sys 15 NOV 14 09:45 chunk01 -> / dev / rdbspace01lrwxrwxrwx 1 root sys 15 nov 14 09:45 chunk02 -> / dev / rdbspace02lrwxrwxrwx 1 root sys 15 Nov 14 09:45 chunk03 -> / dev / rdbspace03lrwxrwxrwx 1 root sys 15 Nov 14 09:45 chunk04 -> / dev / rdbspace04lrwxrwxrwx 1 root sys 15 Nov 14 09:45 chunk10 -> / dev / rdbspace10lrwxrwxrwx 1 root sys 15 Nov 14 09:46 chunk11 -> / dev / rdbspace11lrwxrwxrwx 1 root sys 15 Nov 14 09:46 chunk12 -> / dev / rdbspace12lrwxrwxrwx 1 root sys 15 Nov 14 09:46 chunk13 -> / dev / rdbspace13lrwxrwxrwx 1 root sys 15 NOV 14 09:46 Chunk14-> / dev / rdbspace14LRWXRWXRWX 1 root sys 15 NOV 14 09:43 rootdbs -> / dev / rdbspace05lrwxrwxrwx 1 root sys 15 NOV 14 09:43 Tempdbs -> / dev / rdbspace156, database Initialization database initialization mainly includes initializing disk space and initialization sharing Registration area.
The first step is the initialization of disk space: * Run OnMonitor --- Parameter --- Initialize
[First Screen] Initialization: Make desired changes and press ESC to record this change. Press the interrupt button to abort the change. Press F2 or CTRL-F to get the help of the display field level. Disk parameterspage size [2] kbytes mirror [n]
Tape dev. [/ Dev / null] block size [16] kbytes total tape size [10240] kbyteslog tape dev. [/ Dev / null] block size [16] kbytes total tape size [10240] kbytesstage blob []
Root name [rootdbs] root size [2000000] kbytesprimary path [/ dbspaces / rootdbs] root offset [0] kbytesmirror path [] mirror offset [0] kbytesphy. Log size [100000] kbytes log. Log size [20000] kbytes Number of Logical logs [20] Do you wish Dynamic Server to Handle Mirroring? (Y / N)
annotation:
* Messages and Tape Parameters Settings: # 系统 归档 器 设备 Device: Tape Dev.temp [/ dev / Null] Tape Device Path Block Size [16] KBYTES Tape Block Size Total Tape Size [10240] KBytes Tape Max Capacity # Log Arrangement Tape Device : Log tape dev. [/ Dev / null] log tape device path Block size [16] KBYTES log tape device size Total Tape Size [10240] KBytes Output to Tape STAGE BLOB [] Informix Shock Shock * Root Initialization parameter setting: #root dbspace configuration: root name [rootdbs] root dbspace's name Root size root dbspace size primary path [/ dbspaces / rootdbs] root dbspace device path Root Offset [0] KBYTES ROOT DBSPACE device offset Mirror Mirror Configuration Parameters: Mirror [N] Mirror Sign (YES = 1, NO = 0) Mirror Path [] Mirror Root Dbspace Device Path Mirror Offset [0] KBYTES Mirror Root Dbspace Device Offset # Physical Log Configuration : Phy. Log size [100000] KBYTES Physical Log File Size # logical log configuration: log. Log size [20000] KBYTES logic log size Numr of logical logs [20] logical log file Quantities Messages and Tape Parameter Settings Archive Tape Device: Tape dev.temp, log tape dev should be set according to the configuration of the specific tape drive, where this field is set to [/ dev / null]; the primary path field is set to [/ dbspaces / rootdbs] in the root initialization parameter setting. That is, the path to the root database space. Generally, when installing UNIX, a separate partition is reserved for it (set up a partitioned rootdbs). Root size is assigned to the space size of the Informix stored data, in kbyte. Its size is calculated as follows: a. Log in with root, use the command: #divvyb. Record Name of First Block and Last Block Examples for DBSpace Partition: The first block value of a DBSpace space is: 750001last block value: 1253436c. Calculate the value of root size <= Last Block - First Block 1, with the above data as an example, root size <= 1253436-750001 1 = 503436 Note: The value of root size should be divided by 2. The following principles have the following principles for physical logs and logical logs and sizes: * phy. Log size (physical log file size) = root size / 20 * log. Log size (single logical log size) = PHY. Log size / 2 * Number of Logical Logs [20] (Number of logical log files) After the modification is complete, press the ESC key to confirm that if the parameter configuration is unreasonable, the cursor will stay at the corresponding field. If the settings will be made correctly;
Initialization of shared memory:
[Second Screen] Shared Memory: Make desired changes and press ESC to record this change. Press the interrupt button to abort the change. Press F2 or CTRL-F to get the help of the display field level. SHARED MEMORY PARAMETERS Server Number [8] Server Name [cld3300b_tcp] Server Aliases [cld3300b_shm] Dbspace Temp [tempdbs] Deadlock Timeout [60] Secs Number of Page Cleaners [1] Forced Residency [N] Stack Size (K) [32] Non Res. Segsize (k) [32768] Optical Cache Size (k) [0] dbspace Down option [1] preserve log for log backup [n] heterogeneous commit [n] transaction timeout [300] Physical log buffer size [2048] k Long tx hwm [50] log bots [2048] k long tx hwm exclusive [60] Max # of logical logs [20] 有d 正品 【200】 Max # of locks [200000] Add segsize (k) [8192] Max # of buffers [200000] Total Memory (K) [0]
Resident Shared Memory Size [440686] KBYTES Page Size [2] KBYTES
Enter a unique value to be associated with this version of informix-online.
annotation:
* System parameter configuration: server number [8] Unique value for each server Server Name [CLD3300B_TCP] Database server primary name Server aliases [CLD3300B_TCP] Database server alias dbspace Temp [CLD3300B_TCP] Temporary Database Space Deadlock Timeout [60] In distribution The longest time for waiting lock Forced Residency [n] Forced resident flag Stack Size (k) [32] Stack size non res. Segsize (k) [32768] Non-resident size Transaction Timeout [300] transaction timeout Physical log Buffer Size [2048] K Physical log buffer size Logical log buffer size [2048] K logical log buffer size Max # of logical logs [20] logical log Max # of locks [200000] lock Maximum max Max # of buffers [200000] Buffer Maximum INDEX Page Fill Factor [90] Index Filler Resident Shared Memory Size [440686] KB Shared Save Resignation Size Page Size [2] KB Page Size * The same, type ESC to confirm the correct, Go to the next step:
[Third screen]
Performance: Do what you need is then knocked on the ESC to record the change. Press the interrupt button to abort the change. Press F2 or CTRL-F to get the help of the display field level. Performance Tuning Parameters
Multiprocessor Machine [N] Lru Max Dirty [20] Num Procs To Affinity [0] Lru Min Dirty [10] Proc Num To Start With [0] Checkpoint Interval [300] Num of Read Ahead Pages [] CPU VPS [1] Read AHEAD THRESHOLD [] Aio VPS [12] Single CPU VP [N] Nettype Settings: Use OS Time [N] Protocol Threads Users VP-Class Disable Priority Aging [Y] [TLITCP] [1] [20] [Net] OFF- Line Recovery Threads [10] [ipcshm] [1] [20] [CPU] on-line recovery threads [1] [] [] [] [] Num of lrus queues [8] [] [] [] []
Are you running on a Multiprocessor Machine?
annotation:
* System parameter configuration: Multiprocessor Machine [N] 0 single processor, 1 multiprocessor CPU VPS [1] User CPU VPS Number Nettype Settings: Configuring polling clues for NETTYPE PROTOCOL Threads Users VP-class [ipcshm] [1] [ 20] [CPU] Description: The parameters here only need to modify the PROTOCOL Threads Users VP-Class, the settings of the three parameters of the protocol threads vp-class, and the value under USR should be set to you. The number of users purchased the database. * Type the ESC to confirm the correct, go to the next step:
* Next a few screens are default, then initialize. 7, new TEMPDBS, DATADBS and ADD CHUNK
* New Tempdbs: # onMonitor Dbspaces> Create
[Screen output]
Press the ESC button to create a new DBSPACE. Press the interrupt button to cancel this option and return to the DBSpaces menu Press F2 or Ctrl-F to get help from the display field level.
Create dbspace
Dbspace name [tempdbs] mirror [n] temp [y]
PRIMARY Chunk Information:
Full Pathname [/ dbspaces / tempdbs]
Offset [0] KBYTES SIZE [2,000,000] KBYTES
Mirror Chunk Information: MiRROR CHUNK INFORMATION:
Full Pathname []
Offset [0] KBYTES
* New DATADBS: # onMonitor Dbspaces> Create
[Screen output]
Press the ESC button to create a new DBSPACE. Press the interrupt button to cancel this option and return to the DBSpaces menu Press F2 or Ctrl-F to get help from the display field level.
Create dbspace
Dbspace name [datadbs] mirror [n] temp [n]
PRIMARY Chunk Information:
Full Pathname [/ dbspaces / chunk00]
Offset [0] KBYTES SIZE [2,000,000] KBYTES
Mirror Chunk Information: MiRROR CHUNK INFORMATION:
Full Pathname []
Offset [0] KBYTES
* DataDBS plus Chunk: # onMonitor dbspaces> Add_chunk
[Screen output]
Press the ESC key to add a new large block. Press the interrupt button to cancel this option and return to the DBSPaces menu to press F2 or Ctrl-F to get the help of the display field level.
Add Chunk to dbspace
Dbspace name [datadbs] mirror [n] temp [n]
PRIMARY Chunk Information:
Full Pathname [/ dbspaces / chunk01 (add what you want)] Offset [0] KBYTES SIZE [2000000] KBYTES
Mirror Chunk Information:
Full Pathname []
Offset [0] KBYTES
Then perform onitit -iy to this, the database installation, configuration, and initialization are basically completed.
--------------- Informix Online 7.31 installation complete -------------
