:


---------------------------------------------------------------
 Email: 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    








 
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    :





 
1.2         Windows 95.


 
1.2.1   16 -   ""

 
     :



    

      


    1.    TCP/IP. 
      2. 

    2.  INFORMIX NET. 
      3. 

    3.    . 
    




 
      .           :




 
         : Windows 95    .




 
1.2.1.1    TCP/IP.







 
 ,    Notepad  F4   Norton Comander      




 
(IP  )  ( )




 
( ) (    "" Informix / tcp)

 
:

 
onserv  1540/tcp







 
1.2.1.2  INFORMIX NET.




 
   INFORMIX NET     NEW ERA ,    SetNet ,     INFORMIX.





 
1.2.1.3    .




 
         ,            .       INFORMIX   Delphi.     Delphi   Database Desktop.   :






 
1.2.2   32 -   ""



 
     :



    

      


    1.    TCP/IP. 
      2. 

    2.  INFORMIX NET. 
      3. 

    3.    . 
    




 
      .           :




 
         : Windows 95    .




 
1.2.2.1    TCP/IP.







 
 ,    Notepad  F4   Norton Comander      




 
(IP  )  ( )




 
( ) (    "" 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




 
  Host information




 
 .




 
1.2.2.3    .




 
         ,            .       INFORMIX   Delphi.     Delphi   Database Desktop.   :





 
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



    


  1.      root.
    2. 

  2.   informix.
    3. 

 
              admintool.    ,    (  informix      100):

 
    groupadd -g 150 informix

  3.   informix    .
    4. 

 
              admintool.    ,    ( informix     informix):

 
    useradd -d /opt/informix -g informix -m -u 151 informix



  4.   informix    (   /opt/informix).
    5. 

 
        :

 
     cd /opt/informix

 
     tar xvf <   (*.tar)>



  5.    INFORMIXDIR.
    6. 

 
        :

 
    INFORMIXDIR=/opt/informix

 
    export INFORMIXDIR



  6.   installonline     informix.     ,   ,     .
    7. 

 
    cd $INFORMIXDIR

 
    ./installonline



  7.     informix (              .profile)  :
    8. 

 
    INFORMIXDIR=/opt/informix

 
    export INFORMIXDIR

 
    PATH=$PATH:$INFORMIXDIR/bin

 
    export PATH

 
    INFORMIXSERVER=<,       ,  onlinenet>

 
    export INFORMIXSERVER

 
    ONCONFIG=<,      ,  onconfig.net>

 
    export ONCONFIG

  8.        .           - sysmaster,    .  ,             .                :
    9. 

 
    touch < ,  root_chunk>

 
    chown informix root_chunk

 
    chgrp informix root_chunk

 
    chmod 660 root_chunk



  9.   /etc/services          "" informix.
    10. 

 
    :

 
    onserv  1540/tcp



  10.  ,     $INFORMIXDIR/realise/ONLINE_7.10      Informix   .     ,      . (  Informix OnLine Dynamic Server v 7.10   Solaris for x86              /etc/system,       .)     .
    11. 

  11.      informix.
    12. 

  12.   $INFORMIXDIR/etc/sqlhosts     :




 
          




 
  



 
 



 



 
 






 



 



 



 






 
:



 



 



 






 



 



 



 






 
onlinenet



 
ontlitcp



 
sunserv



 
onserv









 
        informix         .

 
           .





    


  1.     onmonitor,   parameters  initialize.            ,    .             ,      .            .
    2. 

  2.    Disk Parameters   :
    3. 

 
    MIRROR -  N

 
    Tape Dev. -  /dev/null

 
    Log. Tape Dev. -  /dev/null

 
    Root Size -    DbSpace

 
    Primary Path -     ,    8

 
    



  3.  Esc.
    4. 

  4.    Shared Memory Parameters   :
    5. 

 
    Server Number -  10

 
    Server Name -    ,      12

 
    



  5.  Esc.        Esc.
    6. 

  6.              ,   Y.    .
    7. 

  7.     Parameters
    8. 

 
           Quiscent,           .



  8.  EXIT. 
    9. 

  9.  MODE.
    10. 

  10.      On-Line.
    11. 



  11.         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   :






 
  nmonitor         .




 
  (    Off Line   On Line)









 
  (    On Line   Off Line)









 
        (    Off Line   Quiescent)









 
        (    On Line   Quiescent)

 
                ,         








 
              .        .







 
1.5    .




 
      :






 
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


 
 






 
    






 
     





 
   





 
   






 
1.5.5   oncheck



 
    ,     ..          .       :

 
   ncheck -p < >



 
1.5.6   sysmaster



 
  sysmaster      .     28 .          Informix.      SQL         ,  ,     ..         sysmaster     .


 
1.6     




 
          - chuncks.       ""       .    chunks  "" .             ,    "" .  ""    .   ,  ( )     "" ,      chunk         chunks.           chunks,      "" .  chunk   20000 ,   30000 . ,      chunk    ,        "" ,         50000 .



 
1.6.1   chunk     .



 
   chunk          (   )   ""    (    ).

 
             chunk   .




 
  chunk        onspaces







 
   :






 
  cd <  >

 
  cat /dev/null > < >

 
  chmod 660 < >




 
   "" :




 
onspaces -a <  > -p <  . chunk> -o <> -s <  >



 
:


 
   <  >           chunk.

 
   <>      "" .      0     .


 
  chunk        onmonitor








 
   :






 
  cd <  >

 
  cat /dev/null > < >

 
  chmod 660 < >




 
   "" :




 
1.6.2  chunk    .



 
  chunk         ,    chunk.   chunk    .     chunk    (   )    ,    ""    (    ).

 
 ,       chunk         0 (  ).




 
 chunk    







 
Onspaces -d <  > -p <  . chunk> -o <>










 
ontape -s -L 0



 
1.6.3  chunk  .



 
    ,   ,        chunk       chunk - "".      chunk      chunk       D  "" (.      ).           chunk (   . .)   .    :







 





 
       ""

 
1.6.4     .



 
          (   )   ""    (    )      chunk.

 
             chunk.

 
 ,         .  ,       ,       .        (       ONCONFIG)   MIRROR  ("1").




 
       onspaces








 
   :






 
  cd <  >

 
  cat /dev/null > < >

 
  chmod 660 < >




 
   "" :




 
onspaces -c -d <  . > -p <  hunk> -o <> -s < chunk>






 
ontape -s -L 0






 
       onmonitor







 
   :






 
  cd <  >

 
  cat /dev/null > < >

 
  chmod 660 < >




 
   "" :






 
ontape -s -L 0



 
1.6.5      .



 
        ,            .


 
       onspaces








 
   :






 
  cd <  >

 
  cat /dev/null > < >

 
  chmod 660 < >




 
   "" :




 
onspaces -m < . > -p <  hunk   .> -o <> -m <   hunk>






 
ontape -s -L 0






 
       onmonitor








 
   :






 
  cd <  >

 
  cat /dev/null > < >

 
  chmod 660 < >




 
   "" :






 
ontape -s -L 0



 
1.6.6    .



 
          chunk    .     chunk   ,   (       ).       .


 
       onspaces







 
onspaces -d < . >








 
ontape -s -L 0






 
       onmonitor







 
ontape -s -L 0



 
1.6.7   



 
        .           0.             .




 
      onparams







 
nparams -a -d <  .  > -s <  >








 
ontape -s -L 0

 
1.6.8   



 
        .           0.       id.       onstat -l (.    ).




 
     onparams







 
nparams -d -l <id  >








 
ontape -s -L 0


 
1.7  .




 
   Informix    .     0,     .     1,      ,       0.     2,      ,       1.     ,      0     1  2    ..     .       .     .      :




 
        (       ONCONFIG)   TAPEDEV (        onmonitor (Archive-> Tape-Parameters)).         . ,                   ,       . !    ontape      .




 
   0









 
ntape -s -L 0









 
   1









 
ntape -s -L 1









 
   2









 
ntape -s -L 2









 
:




 
      ,    ,          /etc/hosts.equv       .


 
1.8  




 
          0, 1, 2            ,         0.     :




 
        ,       ,  ,          ID   .          .



 
1.8.1     



 
                .      ,      .    :

 
ontape -r -D <    >

 
  ,        (       ONCONFIG)   TAPEDEV     .



 
1.8.2   



 
       .     :






 
ontape -r






Last-modified: Tue, 15 Sep 1998 12:44:43 GMT

  :