  Informix-SE 7.24.UC5    ͽ 
     亯

  Kurt Wall, kwall@uswest.net
  v0.4, 1998 11 2
  嵿, jdongsu@untel.co.kr
  1999 4 21

     Informix Standard Engine ESQL/C   ġ,
    뿡    (FAQs) 亯 ̴.  ޵,
  ۾   ؾ߸ Ѵ.     ͽ-SE
  ġϰ     ϰԵǴ ֹ ؼ Ѵ.
  ODBC ESQL/C Ư κп ؼ ϴ.  ⿡ 
  ͺ̽ ̷п  Թ ƴϴ.   ε  °
  ʱ å ľ Ѵ.   ϸ,  ̷ å õ
  ħ ߰ϰ ʹ.
  ______________________________________________________________________

  

  1. AID CDATA s_intro(LABEL)LABEL
     1.1  
        1.1.1  0.4
        1.1.2  0.3
        1.1.3  0.2
        1.1.4  0.1
     1.2 Disclaimer
     1.3 
        1.3.1  

  2. Ʈ ϱAID CDATA s_obtain(LABEL)LABEL
     2.1 Ǵ ÷  ʴ ÷
     2.2 Intraware ϱ
     2.3 Ʈ ϱ
        2.3.1 CD ֹϱ
        2.3.2 Intraware ٿε ޱ
           2.3.2.1 libc5 
           2.3.2.2 glibc 
     2.4 IDN ϱ
     2.5 IIUG ϱ
     2.6  ΰ?
     2.7   Ѱ?

  3. ġ AID CDATA s_install(LABEL)LABEL
     3.1 ġ  ۾
        3.1.1 (EMinformix׷ 
        3.1.2 (EMinformix   AID CDATA s2_useracct(LABEL)LABEL
        3.1.3 (EMdba 
        3.1.4 ġ 丮 
     3.2 Ʈ ġϱ
        3.2.1 ESQL/C
        3.2.2 SE
        3.2.3 ICONNECT
     3.3 ġ ۾
        3.3.1 (TTsqlhosts  AID CDATA s2_config_sqlhosts(LABEL)LABEL
     3.4 ġ ׽Ʈ ϱ

  4. ͽ ϱAID CDATA s_running(LABEL)LABEL
     4.1 ͺ̽  ϱ
        4.1.1 sqlexec ϱ
        4.1.2 sqlexecd ϱ
     4.2 ߱
     4.3   ڵ ΰ?

  5.  ֳ?AID CDATA s_probs(LABEL)LABEL
     5.1    ϴ°?AID CDATA s1_remote_conn(LABEL)LABEL
     5.2 μ ̺   ΰ?AID CDATA s_zombie(LABEL)LABEL
     5.3 װ͵  ϴ°?AID CDATA s_zombiefix(LABEL)LABEL
     5.4 DBACCESS xterm ׸̼ Ʈ ߻Ų!
     5.5  Ϸ Ʈ ̹  ̴!
     5.6 NFS-Ʈ Ͻý   ִ°?

  6. ٸ ̽AID CDATA s_interfaces(LABEL)LABEL
     6.1 ODBC ̹ Ѱ?
     6.2 JDBC   ִ°?
     6.3 perl ̽ ִ°?
     6.4 PHP ?

  7. SCO ̳ʸ ϱAID CDATA s_sco(LABEL)LABEL
     7.1  󿡼 SCO ̳ʸ   ִ°?

  8. ٸ ͽ ǰAID CDATA s_otherprods(LABEL)LABEL
     8.1 4GL/D4GL/IDS/⿡_ǰ_߰ϼ    ΰ?

  9. ŸAID CDATA s_misc(LABEL)LABEL
     9.1 SE IDS/ODS  ΰ?
     9.2  õ  ΰ?
     9.3 sqlexec sqlexecd  ΰ?
     9.4 Informix-SE "忡 "Ѱ?
     9.5 Informix-SE -μ 迡  ΰ?
     9.6 ESQL/C "忡 "Ѱ?
     9.7    ִ°?
        9.7.1  ۼ϶
        9.7.2 Ÿ ׽Ʈϱ
        9.7.3 IIUG ϱ
        9.7.4 Informix  
     9.8 "SE"   ΰ?
     9.9 ִ  ϵ

  10. ߰ ҽAID CDATA s_resources(LABEL)LABEL
     10.1 Informix   
     10.2 Informix-SE  AID CDATA s1_docs(LABEL)LABEL
     10.3 ġ ħ(HOWTO)
     10.4  ƮAID CDATA s1_websites(LABEL)LABEL
     10.5 õ ƮAID CDATA s1_software(LABEL)LABEL
     10.6 
     10.7 ϸ Ʈ
     10.8 Informix FAQ
     10.9   ּ!

  11. CreditsAID CDATA s_credits(LABEL)LABEL

  ______________________________________________________________________

  1.  

  1.1.   

  1.1.1.   0.4

  1998 11 2

  1.    ͽ ǰ  ҽ ߰

  2. glibc    ߰

  3. "sqlexec sqlexecd  ΰ?"  亯

  4. informix ڿ ׷  ⿡   ۼ

  5. future-proofing ߰

  6.  ȣ ߰

  7. ""  ߰

  8. Ƽμ 忡 õ   ߰

  9. ߰ ҽ   ߰

  10.
     NFSƮ ͺ̽    ߺм

  11.
       

  12.
     Ÿ  

  1.1.2.   0.3

   Ϲ  - 1998 9 25

  1. sqlexec    

  2. PHP  ħ ߰

  3. NFS  ο 

  4.   

  5. Ÿ  

  1.1.3.   0.2

    - 1998 9 20

  1.1.4.   0.1

  ʰ  - 1998 9 18 comp.databases.informix  linux-informix
  IIUG ϸ Ʈ Խ.

  1.2.  Disclaimer

   1998 Kurt Wall, All Rights Reserved This FAQ is freed documentation;
  you can redistribute it and/or modify it under the terms of version 2
  of the GNU General Public License as published by the Free Software
  Foundation.  This document is distributed in the hope that it will be
  useful, but without any warranty; without even the implied warranty of
  merchantability or fitness for a particular purpose.  See the GNU
  General Public License for more details.  You can obtain a copy of the
  GNU General Public License by writing to the Free Software Foundation,
  Inc., 674 Mass Ave., Cambridge, MA 02139, USA.  All errors are
  strictly my responsibility: after applying corrections sent in by
  helpful folks, any remaining typos and bad information are my fault.
  That said, if you start global thermonuclear war based on what you
  read here, that's your fault!

  1.3.  

   FAQ ʿϴٰ Ǵ޵ , ׸  ð  ( ^^;)
  ɰ̴.   뷫 Ŵ ׷ Ϸ Ѵ. ̰ Ʒ
  ּҿ ¶    ̴:

  o  http://www.iug.org/techinfo/linux/linux_faq.html

  o  http://www.users.uswest.net/~kwall/iolfaq.html

  o  http://www.intrware.com/ms/itwr/pfaq/ifmx/linuxfaq/iolfaq.html

   FAQ ٸ  Ϸ ̳  ݰ ̴.  
   鿡   ְų ̴:

  o  Ϻ - ۾ .   ڼ  Norihiro Gouto
     (ngotou@geocities.co.jp)  Ұ.

  o  ξ - ۾ .   ڼ  Alejandro Fernandez
     (afernand@lanet.com.ar)   .

  o  縶Ͼƾ - ۾ .  ڼ  Sebastian Paul Avarvarei
     (proteus@tearwarent.internal.romus.com)   .

  o  Ͼ -   ٸ 

  ̰   ִ ͸ FTP ּҴ:

  o  http://www.users.uswest.net/~kwall/iolfaq.tar.gz

  ,  Ϲ   FTPƮ ԽõǱ ٶ. Intraware
    FAQ (Dan Ѵ) ̷ϰ, ׵  
  ڿ ̰Ϳ  ũ  ̴.

  1.3.1.   

  o  IANAL - I Am Not A Lawyer

  o  TANSTAAFL - There Ain't No Such Thing As A Free Lunch

  o  IDN - Informix Developers Network

  o  IDS - Informix Dynamic Server

  o  IIUG - International Informix Users Group

  o  RDBMS - Relational DataBase Management System

  o  YMMV - Your Mileage May Vary

  2.  Ʈ ϱ

  2.1.  Ǵ ÷  ʴ ÷

   FAQ  ֱٿ Ҷ, Informix-SE  ׽Ʈ
  ÷( )  : ׽Ʈ Ǿ:

  o  Caldera OpenLinux 1.2 (kernel 2.0.33, libc5)

  o  S.u.S.E. 5.2 (libc5)

  o  RedHat 5.1 (kernel 2.0.34, glibc 2.0.7)

  glibc  Ʈ Pentium II 400 Mhz󿡼 ۵ϴ RedHat
  5.1 ׽ƮǾ, libc5  쿡 Pentium II 400 Mhz
  ۵ϴ OpenLinux 1.2 ׽ƮǾٰ Ѵ.

  ͽ    иǴ Ʈ ִ.   libc5
  ϵǾ Caldera OpenLinux 1.2, S.u.S.E. 5.2, Slackware 3.5
   , Debian 1.3  ǿ  Ǿ. ͽ
  ο glibc(libc6̶ ҷ)  ߰ RedHat ڵ
  װ   ְԵ ̴. ͽ 10   ߿ 
    ̴.

  glibc/libc6  ý ϴ ý۵鵵 κ libc5 Ÿ
  ġϰ libc5     ̴. ̰  ʴ
  ̹Ƿ  ý    . ׷
  ýۿ  ϰ ִٴ    δ
    ̴(caveatemptor). glibc/libc6 ýۿ libc5
  ġϴ     ִ ``߰ ҽ''  ϶.

  [:   ϴ  SE 7.24UC5 ǥǾ,
  glibc ¥ RH5.2  ۵ϰ  Ȯߴ.]

  2.2.  Intraware ϱ

  :     ̱ ƴ϶,  800-331-1763
  ȭؾ Ѵ.  ̱ ۿ 800  ̾ϴ  ׻  
  ƴ϶ µ, ϵ   ͽ 繫ǿ  
   ̴. ġ 
  http://www.informix.com/informix/contact/offices 湮 .

  Informix-SE ٿε ,   ͽ ٿε带
  ϴ Intraware Ʈ ؾ Ѵ.  ̰, 
  ״ ٷ ʴ. ϱ ؼ
  http://www.intraware.com/idn/linux/index.html  ø 
  ȴ.   Intraware   ð  ڵ ȣ 
   ް  ̴( 뷫 20и ޾Ҵ).   μصΰ
    ξ.

  2.3.  Ʈ ϱ

  2.3.1.  CD ֹϱ

  CD ֹϷ 800-331-1763 ȭ .

  2.3.2.  Intraware ٿε ޱ

  Intraware ڵ ȣ  ,
  http://www.intraware.com/idn/linux/index.html "Download Page"
  ũ Ŭ ,  ýۿ   Ѵ. 
  (language supplements) ʿ ʴٸ, Informix Connect
  Version 7.24.UC5 Informix SE Version 7.24.UC5 ٿε 
  ȴ.

  2.3.2.1.  libc5 

  informix_se___esql_c_bundle_for_linux.zip ̸ 9.5 Mb¥
  zip  .

  2.3.2.2.  glibc 

  informix_se___esql_c_bundle_7_24_uc5_for_linux_on_kernel_2_0_34__glibc_2_0_7__red_hat_.zip
   ̸(峭ƴ!) 12.1Mb zip  .

  2.4.  IDN ϱ

   ,  û̴. IDN ͽ  Ʈũ
  (Informix Developers Network)̴.  IDN ϵ   
  ͽ  Ǵ    ؼ  
  ٸ    ִ.

  2.5.  IIUG ϱ

   , ̰͵  û̴. IIUG  ͽ
   ׷ (International Informix Users Group)̴.  ͽ
  ׵ ǰ  ϵ  Ϳ  츮 IIUG
  ؾ Ѵ.  IIUGƮ ߿ κе  ڵ ؼ
  Informix-SE  ýۿ ġϰ ۽Ű  
  HOWTO, ϰ ˻  comp.databases.informix  ī̺,
  ׸   Informix-SE ġϰ ϴ ϵ  
    ڵ grundle ϰ ִ.

  2.6.   ΰ?

   ٷ̴ ̰ Ⱑ Ƿ,    
  ִ. ڸ " ."  װ ݵ "" 
  ,   Informix-SE󿡼 ø̼ ϰ
  Ѵٸ    ڿ ؼ Ÿ ̼
  ؾ߸ Ѵ. ߿ ʿϴٸ     ִ.
  ͽ      ׵ ¿   
  밡 Ѵ.   ڼ  http://www.informix.com/cgi-
  bin/contact.pl   ͽ   μ  .

  2.7.    Ѱ?

  ̴. ׷ ¥ ϸ ȵȴ(TANSTAAFL).  
    ؾ Ѵ.  ֳİ? RDBMS  ͼ 
    RDBMS   ֿ Կ  ϳ  
  ̴(  Կ Ÿ ̼  ̴).  ̰
  ٸ Ʈ  "" " " ͼ   
  ο ̵鿡Դ  ̴. ׷, Ϲ  
  ũμƮ (Dell) ȸ ϴ    
   񽺿  ſ Ѵٴ   ʿ䵵 .

    ࿡   ڼ :
  http://www.informix.com/informix/services/csp   .

  comp.databases.informix   ͽ  ͽ ǰ 
  ڵ   ִ.   ڽ 迡   c.d.i װ
   ϸ Ʈ  ż ó̴.  c.d.i. ڵ
  γ ϰ, ϳ , Խϱ(posting)  DejaNews
  (http://www.dejanews.com)  ˻ϰ ׷   ٸ鼭 
  Ұ  Ѵ.  "c.d.i ¾Ʒ ο  ƹ͵
  "(Ecclesiastes[:༺ ϳ] ̾).
  ׷Ƿ  David Williams ǰ IIUG Ʈ ϴ
  Informix FAQ  б⸦  ̴.

  3.  ġ 

  : ͽ Ʈ ִ ġ ħ IIUGƮ ִ Nils
  Myklebust  HOWTO  ߺǴ κе ִ (``߰
  ҽ'' ).  ̰ ΰ    ̴:

  1. ٶǵ, ݺ , 츮  ߿  ˰Ե ̴.

  2. ڵ  ٸ  װ͵ ߰   ִ.

  3.1.  ġ  ۾

  Ʒ   Ѵ:

  o  ȣƮ  ̸ frodo̰  hobbit.com̴

  o   root ڷ αǾ ִ

  o   Bourne shell 迭(Bourne, Korn, bash, pdksh) ϰ ִ

  3.1.1.  informix ׷ 

  κ   addgroup̳ groupadd   ϳ 
   ̴.   α׷ ο  ׷ .  
  ý usercfg GUI  ִٸ װ  ص ȴ.
    ٲ  ȴ.

       <frodo> $ groupadd -g 777 informix

  Ǵ

       <frodo> $ addgroup -g 777 informix

    GID (group ID) 777 informix ̸ ׷ .
  GID   ̴;   Ҵ   GID 
   ְ (Ҵ GID  cat /etc/group), Ư  
  ʰ   GID   ִ.   ܰ迡  
  informix ڸ informix ׷  Ǿ Ѵ.   ٸ
   ڰ  ׷ ,  ڴ  ͺ̽
  ϰ   ְ ɰ̴ -   ƴϴ.

  3.1.2.  informix    

  κ   adduser useradd   ϳ  ִ.
    α׷ ο ڸ .   ý
  usercfg GUI   ִٸ, װ  ص ȴ. 
   ٲ  ȴ.

       <frodo> $ useradd -u 777 -g informix informix

  Ǵ

       <frodo> $ adduser informix

  ù °  UID(-u 777) ʱ ׷(-g informix)  
  䱸Ѵ.  װ ʱ ׷ informix̰ UID 777
  informixڸ .   UID   ̴;  
  Ҵ   UID   ְ (Ҵ UID ؼ
  cat /etc/passwd), Ư  ʰ   UID  
  ִ.  informixڴ  ׷ informix׷̾Ѵ;
  ϴٸ,  ڰ  ׷̾ Ѵ.

   °  adduser ϴµ,  밳 (Caldera OpenLinux
  ϰ  ׻) useraddα׷ ȭ  ũƮ
  Ʈ̴.     ũƮ Ѵٸ ʱ׷
  ϶   informix ԷѴ.      
    ִ useradd   Ѵ.  ڼ  man
  useradd .

  Informix-SE informixڰ Ȩ 丮 Ʈ  
  ʿ .   informixα  ó , ׷
  Ѵٰ ؼ ذ  ͵ .  ݸ鿡 Informix Dynamic Server Ȩ
  丮 ʿ ϹǷ, ߿  IDS   װ ġ
  ȹ̶,  Ȩ 丮  δ  ׶  ܰ踦  
   ̴.

  3.1.3.  dba  

  dba ̸   ``<tt>informix</tt>  ''
    .     ͺ̽  ϴµ
   ̴.  ⿡ ΰ Ģ ȴ:

  1. ͺ̽ µ informixڸ  .

  2. dba informix׷   .  ׷ ϸ ͺ̽
        ī Ĺ ̴.

    Ȩ 丮 ͺ̽  ̹Ƿ װ ġ
   Ű Ѵ.   ý 쿡, dba Ȩ 丮
  /dbms̰, װ   ũ ġϰ   Ʈ
  Ͻýۿ Ʈȴ.  ̷ϸ ͺ̽   Ʈ
   ý Ұų  Ųٷ Ǵ  ȴ.

  3.1.4.  ġ 丮 

  , ͽ ġ 丮  Ѵ.  Ͻý 
  ǥ  ̰,  (, ̺귯 Ǵ ٸ
  ̳ʸ ) /usr̳ /opt ġ  Ѵ.   ý
  ϵ  /usr/local ġȴ.   ý 쿡 װ͵
  /opt ִ.    ϴ  ġ  
  ̴(/tmp  /dev   ).

       <frodo> $ mkdir /opt/informix
       <frodo> $ chown informix.informix /opt/informix
       <frodo> $ chmod 755 /opt/informix

  3.2.  Ʈ ġϱ

   $INFORMIXDIR ȯ   ġ 丮 Ű
  Ѵ:

       <frodo> $ export INFORMIXDIR=/opt/informix

  , н Ѵ.  ׷  ġ ũƮ ǰǥ
  (branding information) ã  ̴:
       <frodo> $ export PATH=$PATH:$INFORMIXDIR/bin

  ٿε  ص 丮  װ͵ unzipѴ (
  丮 ġ 丮 ٸ ̾ Ѵ).    CD-ROM
   ִٸ,  CD-ROMκ ٷ ġ  ִ.

       <frodo> $ cd /downloads
       <frodo> $ unzip informix_se___esql_c_bundle_for_linux.zip

    ESQLC.TAR, SE.TAR ICONNECT.TAR ִ ESQLC, SE,
  ICONNECT   丮 Ե ̴.   ġ丮
  (  /opt/informix), tarϵ ESQLC, SE, ICONNECT
   Ǯ Ѵ.

  [:  ͽ  ICONNECT, CLI  Ŭ̾Ʈ
   ǰ ϳ  Client SDK · ϰ ִ. ڼ
   http://www.informix.com   .]

  3.2.1.  ESQL/C

  ESQL.TAR Ǯ:

       <frodo> $ tar xvf /downloads/ESQLC/ESQL.TAR

  ESQL/C ġϰ ̼ Ѵ (Intraware   Ϸ
  ȣ ̼ Ű 䱸 ̴):

       <frodo> $ ./installesql

  3.2.2.  SE

  SE.TAR Ǯ:

       <frodo> $ tar xvf /downloads/SE/SE.TAR

  SE ġϰ ̼ Ѵ (Intraware   Ϸ ȣ
  ̼ Ű 䱸 ̴):

  <frodo> $ ./installse

  3.2.3.  ICONNECT

  :  ܰ ̴. Informix-SE Informix-CONNECT ġ
  ʾƵ  Ѵ.  SE ESQL/C Ѵ ʿ
  (connectivity) ϰ ִ.  IConnect  SE
  ESQL/C ġǾ   ýۿ ġ ESQL/C ̳ʸ 
    ֵ ϱ   ̴.

  ICONNECT.TAR Ǯ:

       <frodo> $ tar xvf /downloads/ICONNECT/ICONNECT.TAR

  ICONNECT ġϰ ̼ Ѵ (Intraware   Ϸ
  ȣ ̼ Ű 䱸 ̴):

       <frodo> $ ./installconn

  3.3.  ġ ۾

  ġ ۾  . ͽ  Ǿ ϰ,
  ()  TCP/IP  ϴ  δ.

  3.3.1.  sqlhosts   

  켱, $INFORMIXDIR/etc/sqlhosts  纻  Ѱ.  
   anal̶,  cp -p Ǵ cp -a  Ͽ  
  ð ¥   ִ.

  sqlhosts 纻  ,   Ѵ.   Ʒó
  ̴  ϰų ּó(#  Ͽ)   ִ.

       demo_on  onipcshm  on_hostname  on_servername

    Informix Dynamic Server  ̹Ƿ,  
  Ұϴ.  ȣƮ̸ uname -n ° Ȯ ġؾ ϸ,
  ׷  -25591   ɰ̴.  ϴ 
   ʴ´.   ׸ ̷  ̴

       demo_se  seipcpip  frodo.hobbit.com  sqlexec

  1. ׸ 1  ͺ̽  ̸̴.

  2. ׸ 2   ̴(ͽ  
     "nettype" ޵ȴ)

  3. ׸ 3   ϰ ִ ȣƮ ̸̴.

  4. ׸ 4   ̸̴(δ, seipcpip ῡ 
     ̸   ̳ ̳ʸ Ų.  쿡 sqlexec).

  seipcpip   ϰ,   ݷθ
    ִ.   seipcpip    θ
    𸣰ڴ.  Ư  ȯ濡(׷, װ Informix-
  SE ̹   ̴).  ׷,    
  ܾѴ:  ׷   Ư  ٸ, Informix-SE
    ϱ ؼ seipcpip nettype ϶.

  [:  κ  ƹ ̻ϱ.    ñϽ
    ñ ٶϴ.]

  3.4.  ġ ׽Ʈ ϱ

     غ  ְ,  ġ Ȯ غ
  Ǿ.    ִ ͽ ڰ ƴ϶,  
   ϴ   .

  dbtest ׽Ʈ ͺ̽  丮 , 
  丮 cdѴ.  $INFORMIXDIR ȯ  ͽ ġ
  丮 Ű ϰ; ϰ, $INFORMIXSERVER ȯ 
   sqlhosts Ͽ   ̸ Ѵ. 
  $INFORMIXDIR/bin   $PATH  ߰Ѵ:

       <frodo> $ export INFORMIXDIR=/opt/informix
       <frodo> $ export INFORMIXSERVER=demo_se
       <frodo> $ export PATH=$PATH:$INFORMIXDIR/bin

  dbaccessdemo7   丮 stores7 ߺ ͺ̽
  ϰ   鵵  丮  ̴.

       <frodo> $ dbaccessdemo7

  dbaccess    ȭ  ̽ ϰ,
  װ ͺ̽ ۾  ִ.

       <frodo> $ dbaccess

  ޴ Query-language  ( Q ԷѴ) Choose
  (C) Ѵ.  ̰ ߺ ͺ̽   
   ̴.  Ŀ Ű Ͽ sel_ ϴ   ϳ
  ϰ, ͸   ,   Ե ̴.   
  ϵ ۵ϸ,   迡 Ǵ Informix-SE 
  ̴.  Ѵ!

  4.  ͽ ϱ

  4.1.  ͺ̽  ϱ

  4.1.1.  sqlexec ϱ

  Informix-SE ϱ ؼ,  ּ  $INFORMIXDIR 
  $INFORMIXSERVER ȯ溯  ְ, $INFORMIXDIR/bin  
  ο ÷Ǿ  Ȯ ض. ׷ٸ, 

       <frodo> $ dbaccess

   Էϸ  ۵ ̴. ͸     ִ
  ͺ̽  Ÿ, ȭǥ Ű Ͽ  ϴ
  ͺ̽ ϰ ͸ .

  4.1.2.  sqlexecd ϱ

  ͺ̽ ȣƮ(ͺ̽ Ȱϴ )   
   , sqlexecd  . ׷   
  Ѵٸ  о.

  sqlexecd  Ǳ , Ʈ  ۵Ǿ߸ Ѵ.
  ̰ ϼϱ  پ  ִ.  ϵ ,
  $INFORMIXDIR Ǿ ϰ ݵ ȿ ͺ̽ 
  ̸($INFORMIXDIR/etc/sqlhosts ǵ ) sqlexecd ڷ
  Ǿ߸ Ѵ.

  ڼ  ``   ϴ°?''  .  sqlexecd
    ҷ,  rc.local ( ý 𿣰 ġ
  ִ) ߰Ѵ.  ,  SysV init Ÿ ũƮ
  Ѵٸ,    ص ȴ.    𸣰ڴٸ,
  rc.local ٹ ϸ ȴ.

       export INFORMIXDIR=/ͽ/ġ/丮
       $INFORMIXDIR/lib/sqlexecd ͺ̸̽

  sqlexecd ٸ  ð Ϸ, ó  
  Ѵ.  ǻ, /etc/profile $INFORMIXDIR  $INFORMIXSERVER
  ϴ  Ϲ̴.   Ʈ, Ư Ը ü,
  ̰͵ ٸ ͽ- ȯ  ϱ  ϳ ̻ 
  ʱȭ ũƮ Ѵ.

  4.2.  ߱

  dbaccess Ҷ, dbaccess ϴ ( Ȳ)
  õ sqlexec μ ڵ  ̹Ƿ, 
  sqlexec  ʿ䰡 .  ׷,   Ȳ, sqlexec 
  ü ٴ dbaccess  Ǵ ϵ ESQL/C α׷  sqlexec
  θ μ    Ѵ. ׷  
  ͺ̽ ջ  ֱ ̴. θ μ ̴ 
  sqlexec ñ׳   ˴ٿ ȸ  ̴.

  ̰    Ǯ ʰڴٸ  ߿ϴ:  ٸ
   ϰ  ʴ´ٸ  sqlexecμ  .
  ̷ Դ  Ư Ʈ α׸ ϴ ͺ̽,
   ͺ̽    ɼ ÷ش. Ʈ
  α ۵ , sqlexec ̴   ҿ
  Ʈ ߱ϰ װ͵  roll-back  ʴ´: ۵ 
   ʰ, sqlexec Բ ױ , ٸ μ
  κ ŵ ͸  ϰ  ̴.  
  ̷ ϱ ġ ʴ´!  ٸ    ȮҶ 
  sqlexec μ  .

  ݸ, sqlexecd ̴    ϴ. װ  
     û  Ʈ  ִٰ, ׵ 䱸
  ϱ  sqlexec μ ϰ(fork off),  ٸ û
   ̴.

  4.3.    ڵ ΰ?

  Informix-SE  ڵ带 ΰ-  ִ · ٲٱ ؼ,
  finderr α׷ Ѵ (ٽ, $INFORMIXDIR/bin ο ԵǾ
  ִ Ȯ Ұ):

       finderr <-num>  -num    ؽƮ Ѵ.
       finderr <num>  -num   ؽƮ Ѵ.
       finderr <+num>  num   ؽƮ Ѵ.

  ͽ Answers OnLine Ʈ (``ͽ '' ) 
   ִ Informix Error Messages ħ  ȣ ã  
  ִ.

  5.   ֳ?

  5.1.     ϴ°?

   Ŭ̾Ʈ   ִٰ,   sqlexec μ
  ϴ(fire off) sqlexecd   #97893 ( ѵ)
  #97889 (ֶ󸮽 ѵ  ֵǴ) , sqlexec 
    μ ̺  .  (``μ ̺ 
   ΰ?'' ``װ͵  ϴ°?'' ).  
      Ѵٸ, ̷ ض:

  o  $INFORMIXDIR/etc/sqlhosts sqlexecd  ϵ Ѵ

     1. seipcpip sesoctcp Ѵ.

     2. sqlexec sqlexecd Ѵ.

  o    /etc/services Ѵ.   ߰϶

       sqlexecd     1536/tcp

  ׸   ƹ ġ  ְ. ̹  ƴ϶
  1536  ٸ  Ʈ ȣ   ִ.

  o   Ʈ   Ŭ̾Ʈ  sqlexec  ϱ
     ؼҴ sqlexecd Ѵ.

       $INFORMIXDIR/lib/sqlexecd demo_se

    ͺ̽  ̸ demo_se Ѵ.

  5.2.  μ ̺   ΰ?

  װ͵ ͽ  ϸ "츮 ȸʸ ¾ 
  ȵŸ!"̴.  ;-) ϰ, װ͵  #97893 ǥ̴.  
  ״ ͺ̽    ϱ 
  (sesoctcp)    ϰ ߻ϴ  .   
  󿡼  (seipcpip) Ҷ ߻Ѵٴ  ִ.
  ִ  glibc   #97893  Ǿ, ο
   #101155  ߴٴ ̴: SEIPCPIP  ()
   5.1 ÷  ʴ ̴.

  5.3.  װ͵  ϴ°?

  Jonathan Leffler (jleffler@informix.com) ȸå nozombie.c 
  Խߴµ, װ nohup   ȴ.   Jonathan
  ڵ  ̴. ̰ (ͽ  ) 
  ƴϰ,  쿡 ϴ  ƴ϶  ִٴ Ϳ
  ϶. YMMV.

         ϴ --  μ SIGCHLD Ѵٸ, װ  ڽĵ 
       ʴ´. α׷ SIGCHLD  SIG_IGN ñ׳ ó 带   ڷ
       ־  ״ Ѵ.  װ sqlexecd ߻Ѵٸ,
       װ SIGCHLD ñ׳ ϰ ǰ, ׷ ⿡   ʴ´.

  ______________________________________________________________________
  /*
  @(#)File:            $RCSfile: nozombie.c,v $
  @(#)Version:         $Revision: 1.1 $
  @(#)Last changed:    $Date: 1998/08/20 21:24:40 $
  @(#)Purpose:         Prevent process from accidentally creating zombies
  @(#)Author:          J Leffler
  @(#)Copyright:       (C) JLSS 1998
  @(#)Product:         :PRODUCT:
  */
  /*TABSTOP=4*/
  #include <signal.h>
  #include <unistd.h>
  #include <stdio.h>
  #include <stdlib.h>
  #ifndef lint
  static const char rcs[] = "@(#)$Id: nozombie.c,v 1.1 1998/08/20 21:24:40 jleffler Exp $";
  #endif
  /*
  ** Exec program specified by arguments with SIGCHLD signals ignored.
  ** This ensures that unless the program re-enables the SIGCHLD signal
  ** handling, it does not leave zombies around, even if it doesn't
  ** clean up behind its children.  This works on POSIX.1 systems (such
  ** as Solaris 2.6 and Linux) pretty straight-forwardly.
  **
  ** Motivation: the initial version of sqlexecd 7.24.UC1 on Linux
  ** caused problems with lots of zombies.
  **
  **      nozombie $INFORMIXDIR/lib/sqlexecd [service]
  */
  int main(int argc, char **argv)
  {
      signal(SIGCHLD, SIG_IGN);
      execv(argv[1], &argv[1]);
      fprintf(stderr, "Failed to execv() %s\n", argv[1]);
      return EXIT_FAILURE;
  }
  ______________________________________________________________________

  Jonathan ڵ ذ ȵǸ, ֱٿ informix.idn.linux Ÿ
   õ . װ signal Լ ۵ϴ 
  ۼν   Ѵ. ,   signalfix.c 
  :

       ______________________________________________________________________
       #include "signal.h"
       #include <unistd.h>
       #include <stdio.h>
       void *signal(int signum,void (*handler)(int))
       {
         struct sigaction sa;
         sa.sa_handler=handler;
         sa.sa_mask=SA_NOMASK;
         sa.sa_flags=SA_RESTART;
         sigaction(signum,&sa,(struct sigaction *)NULL);
       }
       ______________________________________________________________________

  , /usr/include/signal.h  ϰ, ñ׳ Լ ּó
  Ѵ.  ׷ , signalfix.c ̷  Ѵ:

       $ gcc -fpic -shared signalfix.c -o libsig.so

  , sqlexecd  Ѵ:

       $ LD_PRELOAD=/root/sqlexecfix/libsig.so $INFORMIXDIR/lib/sqlexecd servername

  5.4.  DBACCESS xterm ׸̼ Ʈ ߻Ų!

    dbaccess  termcap/terminfo ׸ ϴ
   ۸ Ҵϰ  ׸  ۰ ϴ ͺ ٴ
  ̴.   ̷  ,  ̰ ͽ  ̰,
    Ŭ    ٶ.

   ȿ ȸ  ִ :

  1. $TERM ȯ  linux, vt220 Ǵ vt100 xterm ƴ ٸ
       Ѵ

  2. termcap̳ terminfo õ ׸ Ѵ( 
     纻  Ŀ).  - dbaccess "ti" "te" ׸ 
     Ƿ, װ͵   ִ.     , ti/te
     ׸  ϴ  xtermǿ  ģ.

  3. xterm-dbaccess xterm ׸ ״ ϰ, "ti" "te"׸
     ϰ,  xterm â dbaccess   $TERMȯ 
     xterm-dbaccess Ѵ.

  4. http://www.informix.com/idn-secure/Linux/WebPages/termcap.html 
       ִ ü termcap/terminfo  Ѵ.  ű⿡ 
      鿡  .

  Roger Allen (rja@sis.rpslmc.edu)  °  ϰ ϱ⸦

       /etc/termcap ٸ ̸ xterm ׸ 纻 
       ο ̸  TERM  ϰų  ׸ ϶.
        ͽ Ŵ η 򰡿 ͽ ϴ ʵ  ִ.
         ti te ʵ带 Ѵ.
       ŵ DB-Accessٴ ٸ ͽ    ,
        ׸ , ׸   Ű Ҽ ְ ϴ
       Ư ͽ ׸ ߰  ִ.

  5.5.   Ϸ Ʈ ̹  ̴!

  ٸ  ض.  ͽ Ʈ 1546, װ
  ϴ  ٸ 񽺿 Ǵ  ƴ϶  ̶
  .

  5.6.  NFS-Ʈ Ͻý   ִ°?

  ƴϴ.  ͺ̽  Ͻý NFS 
  Ʈϱ ٴ,

  1.  ȣƮ sqlexecd ̾ ϰ,

  2.  ͺ̽ Ʈ ؼ ؾ߸ Ѵ.

  SE  ̿  ̰ ̳ʸ  , 
  쿡 ش  𸥴. Jonathan Leffler  ,
  "Ӽ  Ѵٸ  翬 Ϸ ܶ --  ջ
  " ̰ ̳ʸ  ǵ ׷ ʵ, 
  ͺ̽ NFS  Ʈϴ  () ΰ 
     ̴:

  1. NFS  ,   ̴.

  2.  NFSƮ Ұ ȴٸ,  ̾  ̰,
     ͺ̽ ϵ鿡    ϴ.

  6.  ٸ ̽

  SE  ˷ ̽  ``õ Ʈ'' .

  6.1.  ODBC ̹ Ѱ?

  ׷.  ``õ Ʈ'' .

  6.2.  JDBC   ִ°?

  ׷.  ͽ ֱٿ  type IV JDBC ̹ ǥߴ.
      ÷  ׽Ʈ ʾ, type IV
  JDBC ̹ SE   ϴ ó δ. YMMV.
  ``õ Ʈ'' .

  6.3.  perl ̽ ִ°?

  ׷, DBD::Informix. ``õ Ʈ'' .

  6.4.  PHP ?

  PHP ֱ  (3.0.3) ͽ Ѵ. ``õ Ʈ''
  .

  7.  SCO ̳ʸ ϱ

  7.1.   󿡼 SCO ̳ʸ   ִ°?

  ׷, iBCS ϸ ϴ.  װ  ͽ
  ̼ Ǳ . IANAL.  Marco Greco Ȯϰ ̰ ϴ
     ִ.  ``õ Ʈ'' .

  8.  ٸ ͽ ǰ

  8.1.  4GL/D4GL/IDS/⿡_ǰ_߰ϼ    ΰ?

   D4GL ͽκ  ֹ  ִ.  · 4GL 
    Ȯ ʴ.

  ֱ ͽ IDS,  Informix Dynamic Server 1998 4/4б ߿
   ̶ ǥߴ. ̰  ҽ̴!

  [:   ϴ   IDS 7.3  ǥǾ,
  ¥RH5.2  ϴ  Ȯ, ¥RH5.2 ϸ
  Ʈ̾!  CD ԵǾ ִ.]

  IIUG  ȸ  ǰ ؼ, õǴ ñ 
  ͽ õ پ ٸ  ͽ ؼ ۾ϰ
  ִ.    ̷ 鿡  ġ ʹٸ ͽ 
  Ʈ  縦 ä: http://www.informix.com/idn-
  secure/Linux/WebPages/survey.html

  9.  Ÿ

  9.1.  SE IDS/ODS  ΰ?

  Ϲ, SE IDS ,     ϰ, װ
   ū   Ư ϴ. ü ϸ,Informix-
  SE    ִ:

  o  BLOB(Binary Large Objects)  

  o  VARCHAR    

  o  TEXT    

  o  BYTE    

  o  ESQL/C Ƽ尡 ƴϴ

  o  ESQL/C TP/XA  

  o  TERMINFO   

  ׷ ̰  SE ؾ ȴٴ ǹ̶  .
  ֳϸ  ſ ܼϱ , Informix-SE wash-and-wear
  RDBMS̴.  װ ġϰ,      ϰ,
  ׸  ͺ̽ ￡ .

  SE  ̴. ...   Ư  MIS ڰ 
  Ʈ  .   SE  η    䱸
  ʴ ø̼   پ;   ƴϸ, װ
  װ  ó   ƴϴ. ٽ ,
  Ʈ̵   ɰ    ̴.

  9.2.   õ  ΰ?

   FAQ  ŵ  ,  ֱ   1998 7
  13 õ Informix-SE 7.24.UC5̴.׷, glibc  
  ڵ 1998 10 14  ǥǾ.

  9.3.  sqlexec sqlexecd  ΰ?

  sqlexecα׷ ͺ̽  ϴ ͺ̽
  ̴.  ͺ̽ ϴ  α׷ ڽŸ
  sqlexec纻  ȴ.  (̰ sqlexec ̴    
    ش). ȣƮ OS  SE μ ڿ
    ʿ ŷ óѴ.  ݸ鿡, sqlexecd 
  ͺ̽ ǵ帮 ʴ´. װ   ͺ̽
    û (밳  ø̼/Ŭ̾Ʈ 
  ߻ϴ) û Ŭ̾Ʈ ϰ, û  ͺ̽
  ϱ  sqlexecμ Ѵ.    ýۿ
  αϷϴ 踦 ٸ rlogind, rlogind ڿ
  ϱ Ű    ϴ.

  9.4.  Informix-SE "忡 "Ѱ?

       װ   ʴ´. SE 
  ̰,   ϳ 䱸 ٷ  ø̴̼.
  ׷,     ൿϴ°   ġ
  ʴ´.

  9.5.  Informix-SE -μ 迡  ΰ?

  ׷, ֳϸ ؿ ִ OS MP óҰ̹Ƿ. ̿ ؼ,
   "Informix-SE  μ  ϴ°?" 
  ̶  "ƴϿ."̴. SE  ̰ 
  μκ  üδ ̵ .

  9.6.  ESQL/C "忡 "Ѱ?

  ׷⵵ ϰ ƴϱ⵵ ϴ. libc5   忡  ʴ.
  ֳϸ libc5 忡  ʰ, ߿ glibc/libc6 Ե
    ϳ.   Jonathan Leffler ESQL/C  DCE
  ͸ Ѵٴ  ߴµ, (κ ) 
  POSIX 常 Ѵ.   ̵   
  , װ͵ ȣȯ .    ߸  ,
   glibc  忡 ϴٰ  ̴.  ֳϸ
   ϱ  C ̺귯 忡 ϱ
  ̴.

  9.7.     ִ°?

  9.7.1.   ۼ϶

     ͽ ϰ ʹٸ, Tom Schaefer
  netd@mindspring.com  HOWTO õ  ۼϰ 
  ҿ ϴ  Ѵ.  HOWTO    Ư
   ʿϴ:

  o  ODBC Ἲ

  o  JDBC Ἲ

  o  Perl, DBD  DBI

     ٸ ͽ ǰ ǥʿ , 츮 װ͵  HOWTO
     FAQ ʿ ̴.

  9.7.2.  Ÿ ׽Ʈϱ

  ٸ ǰ  ð  , ͽ Ÿ
  ׽Ͱ ʿ ̴.  Art Kagel Ÿ α׷ Ѵ. 
  ڼ , kagel@erols.com  ׿  .  ּ 
   ϸ ͽ ׽Ʈ ǰ  ͽ  
   ׽Ʈϰ  ǰ ÷ ġų  ִ:

  o    

  o   ׽Ʈ ͺ̽ ũ

  o  ׽Ʈ ø̼ ⼺ 

  o  ϵ (-, - Ȥ -CPU)

  o    ġ

  o  Ϲ  

  o   ׽Ʈϱ ϴ Ư ͽ ǰ

     , Non-Disclosure Agreement (NDA)  ʿ䰡  ̴.

  9.7.3.  IIUG ϱ

   ͽ  ׷ ͽ ׵ ǰ 
  ǥϵ ϴµ  Ǿ.  ȸ   
  ̴.  , IIUG ϴ  ̸,  ͽ 
  ġ,  ͽ  ͽ ϴ  
   ִ ȸ Եȴ.  http://www.iiug.org ׵   ִ.

  9.7.4.  Informix  

   ׻ ͽ     ְ ׵鿡 
   ȯ õǱ ٶ Ư ͽ ǰ   ִ.
  ׵  ִ.

  9.8.  "SE"   ΰ?

  Standard Engine. Informix-SE cooked,  ˵,  ýۿ
  ϴ ִ ISAM- ͺ̽ ̴.

  9.9.  ִ  ϵ

  ׷  ϵ鿡 ̰ ִ ̵ , Carlton Doe ͽ
  ǥ  ó ĥ IntrawareƮκ ٿε尡 ʱ⿡ 뷫
   700ȸ ߴٰ ߴ.  װ͵  ķ 뷫 
  300 .  ͽ Ÿ ̼   Ǹſ
     ǥ ʾҴ.  ũμƮ  NT 
   α׷   ٷ̿   ǥǾ.  ּ
  ʱ⿡  ٿε尡 NTٿε带 . ;-).

  10.  ߰ ҽ

  10.1.  Informix   

  o  http://www.informix.com/linux

  o  http://www.informix.com/solution/linux/freelx.html

  10.2.  Informix-SE  

  o  Answers OnLine
     http://www.informix.com/answers/oldsite/answers/english/se72xux.html

  10.3.  ġ ħ(HOWTO)

  o  IIUG http://www.iiug.org/techinfo/linux/linux_top.html

  o  Informix (IDN  ʿ) http://www.informix.com/idn-
     secure/Linux/WebPages/install.html

  o  glibc- ýۿ libc ġϱ
     http://sunsite.unc.edu/LDP/HOWTO/Glibc2-HOWTO.html

  o   Informix-CLI ġϰ ϱ
     http://www.iiug.org/techinfo/linux/Howto_Informix_CLI.html

  10.4.   Ʈ

  o  Linux󿡼 SCO ̳ʸ ϱ
     http://www.ctonline.it/~marcog/ifmxlinux.htm

  o  InxUtil http://www.inxutil.com

  o   ͽ  ׷ http://www.iiug.org

  o  4GL Ϸ http://www.aubury.demon.co.uk/a4gl.html

  o   ٸ 4GL Ϸ http://www.querix.com

  o  Ϻ ͽ http:/www.informix.com/jp

  10.5.  õ Ʈ

  o  ODBC ̹

  o  Intraware http://www.intraware.com/informix

  o  OpenLink Software http://www.openlinksw.com

  o  Informix ClientSDK www.intraware.com/informix/

  o  SCO SQL-Retriever www.sco.com/vision/products/sql/retriever

  o  JDBC ̹

  o  OpenLink Software http://www.openlinksw.com

  o  Informix http://www.informix.com/informix/products/javaannc.html

  o  (perl)̽ DBD::Informix̴.
     http://www.cpan.org/modules/by-category/07_Database_Interfaces/
        ִ.  DBI DBD::Informix ʿϴٸ ͽ
      .

  o  PHP 3.0.3 ͽ Ѵ.  http://www.php.net 湮϶.

  10.6.  

  o  comp.databases.informix (gatewayed to informix-list)

  o  informix.idn.linux (IDN  ʿ)

  10.7.  ϸ Ʈ

  Ϲ  ؼ,
  http://www.iiug.org/usenet/iiug_forums.html 湮 .

  o  linux-informix (IIUG ).  majordomo@iiug.org  
     "subscribe linux-informix" ޽ .

  o  informix-list (IIUG ).  majordomo@iiug.org  
     "subscribe informix-list" ޽ .

  o  SuSE  ׵  ͽ Ʈ
     http://www.suse.com/Mailinglists/suse-informix.info.html 
     ִ.

  10.8.  Informix FAQ

  o  HTML http://www.iiug.org/techinfo/faq/faq_top.html

  o  Text ftp://ftp.iiug.org/pub/informix/faq

  10.9.    ּ!

  ٲ ϸ:    ߸ Ǵ   ũ ߰ϸ
  kwall@uswest.net   . ͺ̽ ϰ,
  4GLڵ带 ϰų -ϴ  ȭϴ  ʹ޶
   û.    ٻڰ   ڹ 
  ϱ ġʴ´.    FAQ  Ʈ  ڶ, ͽ
  FAQ IIUG ī̺긦 ã,    ʿ 亯 ã
  ߴٸ comp.databases.informix ԽѴ.    FAQ ԽŰ
   װ  ͽ  ִٸ   Ϳ 
  Ⲩ  ̴.

  11.  Credits

  ͽ ׵ ħ  ϰ ޾Ƶ̰ ׵ ǰ
   ϴ  Ƿ   Ѵ.

  IIUG Carlton Doe Ư Ѵ. ״  IIUG linux-
  informix ϸ Ʈ   ī̺鿡  
  ߰  ⼭   Ḧ ߴ.    
  ͺ̽  ѷ  seipcpip  sesoctcp Ȯϰ 
  Jonathan Leffler  Nils Myklebust  Ѵ.  Marco Greco,
  Art Kagel ׸ Tom Schaefer   ߴ.

  Matt Welsh  Linuxdoc-SGML Ű

   åڵ鿡 Ѵ.  Linuxdoc-SGML  FAQ ۼ
  ܼϰ ־  ϳ     
    ְ  ־.

     Ѵ(ĺ ): ͸ڵ, Medhi Afshar,
  Orlando Andico, Joe Archer, Mike Aubury, Sebastian Paul Avarvarei,
  Dave, Fernando Fernandez, Marco Greco, Art Kagel, Christian Kirch,
  Jonathan Leffler, Michael Perry, Dan Peters, Mike Reetz, George
  Tereshko, Billy Wheeler, Rob Zook

