. Solaris 2 Informix
---------------------------------------------------------------
Email: visor@olma.co.ru mailto:visor@olma.co.ru
---------------------------------------------------------------
Informix.
1 Solaris 2.x / Informix 7.10 *
1.1 Informix-OnLine c Windows 3.11, Windows 95 *
1.1.1 INFORMIX - OnLine *
1.1.2 *
1.1.3 *
1.2 Windows 95. *
1.2.1 16 - "" *
1.2.2 32 - "" *
1.3 (). *
1.3.1 . *
1.3.2 Informix OnLine v 7.x *
1.4 , . *
1.4.1 oninit onmode *
1.4.2 onmonitor *
1.5 . *
1.5.1 *
1.5.2 *
1.5.3 onstat *
1.5.4 onmonitor *
1.5.5 oncheck *
1.5.6 sysmaster *
1.6 *
1.6.1 chunk . *
1.6.2 chunk . *
1.6.3 chunk . *
1.6.4 . *
1.6.5 . *
1.6.6 . *
1.6.7 *
1.6.8 *
1.7 . *
1.8 *
1.8.1 *
1.8.2 *
1 Solaris 2.x / Informix 7.10
1.1 Informix-OnLine c Windows 3.11, Windows 95
1.1.1 INFORMIX - OnLine
INFORMIX - OnLine , TCP/IP. INFORMIX - NET for Windows INFORMIX - OnLine , . 1. INFORMIX - NET for Windows INFORMIX - STAR UNIX 5.0 . ( INFORMIX - OnLine 5.0 INFORMIX - STAR , .) :
1.INFORMIX-NET for Windows INFORMIX-STAR.
2.INFORMIX-STAR INFORMIX-OnLine v 5.0 INFORMIX-STAR. ( , 7.x INFORMIX-STAR .)
3. INFORMIX-OnLine ( ). INFORMIX-STAR .
1.1.2
- INFORMIX-NET for Windows - , , , INFORMIX-OnLine , UNIX , NT, NOVELL NetWare. INFORMIX-NET for Windows , , . INFORMIX-NET for Windows SQL , .
- INFORMIX-STAR - , UNIX .
- INFORMIX-OnLine - .
1.1.3
( ) :
|
16- . |
32- . |
|
386 |
486 |
MS-DOS |
5. 6.. |
- |
MS Windows |
Windows 3.1 . |
Windows 95/NT |
|
Novell IPX/SPX , TCP/IP Windows Sockets 1.1 |
Novell IPX/SPX , TCP/IP Windows Sockets 1.1 |
RAM |
4 RAM, 8 |
8 RAM, 12 |
|
1.5 |
5 |
MS Windows 3.11 , . INFORMIX-NET for Windows :
- Microsoft HIMEM.SYS 3.1
- Qualitas 386 MAX 6.0
- Quarterdeck Office Systems QEMM-386 6.01
1.2 Windows 95.
1.2.1 16 - ""
:
- TCP/IP.
- INFORMIX NET.
- .
. :
- Windows 95
- INFORMIX NET ( NEW ERA v 2.0 )
- (. Delphi)
: Windows 95 .
1.2.1.1 TCP/IP.
- Control Panel (: Start -> Settings -> ControlPanel) Network.
- "Add".
- "Protocol".
- "Add".
- Microsoft , TCP/IP.
- "Ok".
- - "TCP/IP". , , .
- "Propetis".
- "IP Addres" . .
- "Subnet mask" 255 .
- "Ok".
- "Ok".
, Notepad F4 Norton Comander
(IP ) ( )
- Disk:\WINDOWS\services . :
( ) ( "" Informix / tcp)
:
onserv 1540/tcp
1.2.1.2 INFORMIX NET.
INFORMIX NET NEW ERA , SetNet , INFORMIX.
- HostName UNIX- ( sunserv).
- UserName , .
- ServiceName ( onserv)
- ProtocolName tcp-ip.
- .
1.2.1.3 .
, . INFORMIX Delphi. Delphi Database Desktop. :
- Database Desktop.
- File -> Aliases.
- New.
- Database aliases alias.
- Driver Type INFORMIX ( , Delphi , ).
- SERVERNAME UNIX , INFORMIX OnLine ( sunserv).
- DATABASE , . : <߁>@<ߑ> ( informix_com@onlinenet).
- USER NAME , ( ).
- Keep New.
- PASSWORD ( ).
- Connect.
- Ok.
1.2.2 32 - ""
:
- TCP/IP.
- INFORMIX NET.
- .
. :
- Windows 95
- INFORMIX NET ( ESQL/C v 7.20 )
- (. Delphi)
: Windows 95 .
1.2.2.1 TCP/IP.
- Control Panel (: Start -> Settings -> ControlPanel) Network.
- "Add".
- "Protocol".
- "Add".
- Microsoft , TCP/IP.
- "Ok".
- - "TCP/IP". , , .
- "Propetis".
- "IP Addres" . .
- "Subnet mask" 255 .
- "Ok".
- "Ok".
, Notepad F4 Norton Comander
(IP ) ( )
- Disk:\WINDOWS\services . :
( ) ( "" Informix / tcp)
:
onserv 1540/tcp
1.2.2.2 INFORMIX NET.
Informix Net for Windows, ESQL/C v 7.20. autoexec.bat . , .
INFORMIX NET ESQL/C v 7.20, Informix SetNet32 , INFORMIX.
Server information
- Informix Server - ( onlinenet).
- HostName UNIX- ( sunserv).
- ProtocolName onsoctcp.
- ServiceName ( onserv)
Host information
- Current Host UNIX- ( sunserv).
- UserName , .
- PasswordOptions , No Password.
.
1.2.2.3 .
, . INFORMIX Delphi. Delphi Database Desktop. :
- Database Desktop.
- Tools -> Aliases manager.
- New.
- Database aliases alias.
- Driver Type INFORMIX ( , Delphi , ).
- SERVERNAME ( onlinenet).
- DATABASE , . : <߁>@<ߑ> ( infcom@onlinenet).
- USER NAME , ( ).
- Keep New.
- PASSWORD ( ).
- Connect.
- Ok.
1.3 ().
1.3.1 .
Informix OnLine Dynamic Server 7.10 , OC Sun Solaris 2.51 for PC , .
Pentium 100 , 32 ( 64 ) , 1 ( 2),
CD-ROM , PCI , SCSI . Sun Solaris 2.51 for PC , . Sun Solaris 2.51 for PC .
Informix OnLine Dynamic Server 7.10 , OC Sun Solaris 2.51 for PC.
Aser.
|
Acer Altos 7000V |
CPU |
P-133 |
CACH |
256 |
Memory |
64 |
motherboard |
: |
|
|
Bas Arch. |
EISA , PCI |
SCSI Host Adapter |
Adaptec AIC-7870p |
|
|
Hard Discs |
SCSI QUANTUM FirerBall 1 |
Graphics Card |
S3 Trio64V+ |
Network Adapter |
D-Link DE-530CT |
CD-Rom |
SCSI Matsushita |
Monitor |
AcerViev 56L |
Mouse |
Acer PC/2 |
UPS 450 /. APC SmartUPC 450
SCSI. SCSI ARTECH HP SureStore T4i.
PCI.
CPU |
P-166 MMX |
CACH |
512 |
Memory |
64 (2 SIMM 72 pin Acorp x 32 Mb) |
motherboard |
Iwill P55XB2 |
|
|
Bas Arch. |
ISA , PCI |
|
|
Hard Discs |
EIDE Western Didgital Caviar 22500
2,5 |
Graphics Card |
S3 Trio64V+ |
Network Adapter |
3Com EtherLink III ISA (3Com509) |
CD-Rom |
Sumsung 8X |
UPS 450 /. APC SmartUPC 450
1.3.2 Informix OnLine v 7.x
- root.
- informix.
- admintool. , ( informix 100):
- groupadd -g 150 informix
- informix .
- admintool. , ( informix informix):
- useradd -d /opt/informix -g informix -m -u 151 informix
- informix ( /opt/informix).
- :
- cd /opt/informix
- tar xvf < (*.tar)>
- INFORMIXDIR.
- :
- INFORMIXDIR=/opt/informix
- export INFORMIXDIR
- installonline informix. , , .
- cd $INFORMIXDIR
- ./installonline
- informix ( .profile) :
- INFORMIXDIR=/opt/informix
- export INFORMIXDIR
- PATH=$PATH:$INFORMIXDIR/bin
- export PATH
- INFORMIXSERVER=<, , onlinenet>
- export INFORMIXSERVER
- ONCONFIG=<, , onconfig.net>
- export ONCONFIG
- . - sysmaster, . , . :
- touch < , root_chunk>
- chown informix root_chunk
- chgrp informix root_chunk
- chmod 660 root_chunk
- /etc/services "" informix.
- :
- onserv 1540/tcp
- , $INFORMIXDIR/realise/ONLINE_7.10 Informix . , . ( Informix OnLine Dynamic Server v 7.10 Solaris for x86 /etc/system, .) .
- informix.
- $INFORMIXDIR/etc/sqlhosts :
|
|
|
|
|
|
|
|
: |
|
|
|
|
|
|
|
onlinenet |
ontlitcp |
sunserv |
onserv |
informix .
.
- ( Informix OnLine, on)
- :
- Ipc ,
- Tli tcp/ip ipx/spx
- Soc .
- :
- Shm
- Tcp tcp/ip
- Spx spx/ipx.
- onmonitor, parameters initialize. , . , . .
- Disk Parameters :
- MIRROR - N
- Tape Dev. - /dev/null
- Log. Tape Dev. - /dev/null
- Root Size - DbSpace
- Primary Path - , 8
-
- Esc.
- Shared Memory Parameters :
- Server Number - 10
- Server Name - , 12
-
- Esc. Esc.
- , Y. .
- Parameters
- Quiscent, .
- EXIT.
- MODE.
- On-Line.
- On-Line , Sysmaster.
1.4 , .
Informix OnLine v 7.X :
OffLine - .
Quiescent - , .
OnLine - - .
.
OnLine. .
OffLine.
oninit, onmode, onmonitor. , , , onmonitor oninit onmode .
1.4.1 oninit onmode
( Off Line On Line)
oninit
( On Line Off Line)
onmode -k
( Off Line Quiescent)
oninit -s
( On Line Quiescent)
onmode -s ( , )
onmode -u ( - . )
"-y". onmode -ky , "" .
1.4.2 onmonitor
Onmonitor :
- Onmonitor On line Off Line, . Quiescent .
- , .
nmonitor .
( Off Line On Line)
- onmonitor
- Mode->Startup
- Quiescent On-Line.
( On Line Off Line)
- onmonitor
- Mode-> Immediate-Shutdown
- "Y"
- , ESC "Y"
- Shutdown Take-Offline.
- - "Y"
( Off Line Quiescent)
( On Line Quiescent)
,
- onmonitor
- Mode-> Graceful-Shutdown
- "Y"
- , ESC "Y"
. .
- onmonitor
- Mode-> Immediate-Shutdown
- "Y"
- , ESC "Y"
1.5 .
:
-
- , ( $INFORMIXDIR/online.log)
- onstat
- onmonitor
- oncheck
- Sysmaster.
1.5.1
( , , ..). Informix.
1.5.2
, Informix , Informix. , INFORMIXDIR online.log. Informix , , , , - check point .. . ( , ..) . .
cat $INFORMIXDIR/online.log | more
( Enter)
cat /dev/null > $INFORMIXDIR/online.log
1.5.3 onstat
onstat . . Onstat . Shared memory , On-Line Quiescent onstat. Off-Line, onstat :
shared memory not initialized for INFORMIXSERVER
. .
onstat
onstat -- | more
. . Ctrl - C.
onstat -i
.
nstat -r < .> < >
nstat -s
:
INFORMIX-OnLine Version 7.10.UD2 -- On-Line -- Up 00:01:01 -- 8976 Kbytes
INFORMIX-OnLine Version 7.10.UD2 |
-- On-Line -- |
Up 00:01:01 |
8976 Kbytes |
|
|
|
|
nstat -p
nstat -d
nstat -l
nstat -k
nstat -p -g glo
nstat -p -g ath
nstat -u
nstat -g ses
1.5.4 onmonitor
onmonitor . , , onstat .
onmonitor, Status .
Ctrl-B. :
Press ESC to return to the Status Menu.
Use arrow keys to move the cursor.
Press F3 or CTRL-B for chunk information on the highlighted DBspace/BLOBspace
- onmonitor
- Status->profile
- onmonitor
- Status->Userthreads
- ESC
onmonitor
Status-> Spaces
Ctrl-B .
ESC
onmonitor
Status->Databases
ESC
onmonitor
Status->Logs
ESC
1.5.5