Results 1 to 12 of 12
  1. #1
    Join Date
    Apr 2004
    Posts
    9

    Unhappy Unanswered: Informix doesn't start

    Hi
    I have a problem starting Informix. I have to export data from Unix (Informix) to Window 2000(Sql Server 2000) box. The Informix program is called lycs. It is written in Informix SE 7.20 and C. We are using SCO UNIX. The way the file structure is INFORMIX has a separate directory with the entire utility file under root and data has a separate directory under root. The main data base (main.dbs) is sitting under root/user3/LRT/main.dbs. The Informix utility file is sitting under root/usr/Informix/etc ... bin .. . now I want to start the dbschema or at least initialize the database from UNIX or use dbaccess command. The problem is :

    1)when I use oninit to start database it says not found(from any directory).
    2)when I try to use dbschema , it say not found (from any directory).
    3) Doesn't accept any command of Informix from Unix prompt.

    Question is:

    Where I am making mistake?
    How can I find what instances of Informix database server is running and what port Informix are listening to?
    I could not find onconfig file in Informix/etc directory.

    I am a very new to Informix --- Can anyone help me solve the problem. All I have to do is to transfer the data from Informix to SQL Server 2000.

    Please help me my job is pretty much depending on this successful transfer of this data from Informix to Sql Server 2000.

    Thanks
    Moloy Bagchi

  2. #2
    Join Date
    Apr 2004
    Location
    Brussels
    Posts
    57
    - In unix you must be user informix to start the informix server.
    - For IDS you have this :
    The user needs environment variables :
    INFORMIXDIR pointing to the root directory of informix installation
    ONCONFIG withthe name of the onconfig file. without onconfig you can't start
    INFORMIXSERVER with the name of your informix instance, that name is also found in the onconfig file and in the sqlhosts file
    SQLHOSTS with the mapping of the servernames, connection method en service (port)number.

  3. #3
    Join Date
    Apr 2004
    Posts
    9

    Question Thanks and one more question

    Thanks for you prompt reply. I have one more question

    1) I have a User name Informix but when-ever I try to log-in using that account in unix(Instead of root) and try to execute any command it say permission denied . Why is that?

    2) How and where can I find the port number that informix server is listening to ?

    3) I am still confused with ONCONFIG enviornment variable what will be the value of it and where can I find it?

    Your reply will be really appreciated.

    Thanks again
    Moloy

  4. #4
    Join Date
    Apr 2004
    Location
    The Netherlands
    Posts
    7
    Did you try su-ing to the informix account, when you're logged in as root?

    Lex

  5. #5
    Join Date
    Apr 2004
    Posts
    9

    No I did not

    No I did not su-ing to Informix account because I was trying to login as informix from unix login prompt and getting all these errors . How do I use it su-ing?

    Thanks

    Moloy

  6. #6
    Join Date
    Apr 2004
    Location
    Brussels
    Posts
    57
    - with the classic unix command "su <user_name>" you become the new user, however if you want to take the environment of the user the command is "su - <user_name>" with dash+blank (see manual pages su)
    - It seems you didn't know the mechanism Informix find itselfs :
    1. The INFORMIXDIR variable points to the informix directory that contains bin, etc, ...
    2. The PATH variable includes $INFORMIXDIR/bin
    3. The ONCONFIG variable points to the onconfig file in $INFORMIXDIR/etc
    4. The INFORMIXSERVER variable is the name of the informix instance which you want to 'init' or 'connect', this name is the same name you must have in the onconfig file in variable DBSERVERNAME or DBSERVERALIASES, the same name is in the sqlhosts file
    5. The $INFORMIXDIR/etc/sqlhosts or alternatively the INFORMIXSQLHOSTS variable is the connectivity file. It describes the mapping between $INFORMIXSERVER, the hostname (could be remotely), the connect method (socket, ipc, shm) and the appropriate port number/name if socket (soctcp).
    6. The unix file /etc/services maps the port name to the port number.
    the port number informix uses :
    So on 1 machine you can have f.i. 1 /usr/informix directory with 1 sqlhosts file and multiple INFORMIXSERVER instances.
    OLd but very easy admin explanation at http://docs.rinet.ru:8083/InforSmes/index.htm
    The whole stuff at http://www-306.ibm.com/software/data.../pubs/library/

    Good luck,
    Yves & Willy

  7. #7
    Join Date
    Apr 2004
    Location
    The Netherlands
    Posts
    7

    unix basics

    first you log in as root
    then type

    su informix

    after that you're user informix!

    if you do

    su - informix

    your profile is executed as well

    Lex

  8. #8
    Join Date
    Apr 2004
    Posts
    9

    Unhappy onconfile file doen't exits

    First of all I want to thank all of you for such tremendous responses to my few questions. I manage to move forward quite a lot with your help , but still not accomplish what I set out to do . So I need little more help again from all of you.

    when I run "env" in unix prompt I get this

    # env
    HOME=/
    HZ=100
    INFORMIXDIR=/usr/informix
    KEYBOARD=C/US
    LANG=C
    LOGNAME=root
    MAPCHAN=/usr/lib/mapchan/88591.dk
    NUMLOCK=no
    PATH=/usr/informix/bin:/sbin:/usr/sbin:/usr/bin:/etc:/usr/ccs/bin:/usr/ccs/bin
    SHELL=/sbin/sh
    SHIFTDOWN=yes
    TERM=ansi
    TFADMIN=
    TIMEOUT=0
    TZ=:Canada/Eastern
    XKEYBOARD=C/US
    XMODIFIERS=@im=Local
    XNLSPATH=/usr/X/lib/Xsi/C/US
    _TTYNAME=/dev/pts012
    #
    so my informix path and informixdir is being set up.

    Now when I try to find onconfig file in \usr\Informix\bin directory,, there is no onconfig file

    # cd /usr
    # cd informix/etc
    # ls -a
    . Termcap ja_jp termcap zh_tw
    .. brand ko_kr th_th
    .snfile cnv50t60.sql sefiles updmenu.sql
    ISQL-cr en_us sqlfiles xpg4_is.sql
    SE-cr install sqlhosts zh_cn

    when I try to run sqlhosts this is all I get

    # more sqlhosts
    #************************************************* *******#
    # INFORMIX SOFTWARE, INC.
    #
    # PROPRIETARY DATA
    #
    # THIS DOCUMENT CONTAINS TRADE SECRET DATA WHICH IS THE PROPERTY OF
    # INFORMIX SOFTWARE, INC. THIS DOCUMENT IS SUBMITTED TO RECIPIENT IN
    # CONFIDENCE. INFORMATION CONTAINED HEREIN MAY NOT BE USED, COPIED OR
    # DISCLOSED IN WHOLE OR IN PART EXCEPT AS PERMITTED BY WRITTEN AGREEMENT
    # SIGNED BY AN OFFICER OF INFORMIX SOFTWARE, INC.
    #
    # THIS MATERIAL IS ALSO COPYRIGHTED AS AN UNPUBLISHED WORK UNDER
    # SECTIONS 104 AND 408 OF TITLE 17 OF THE UNITED STATES CODE.
    # UNAUTHORIZED USE, COPYING OR OTHER REPRODUCTION IS PROHIBITED BY LAW.
    #
    #
    # Title: sqlhosts.demo
    # Sccsid: @(#)sqlhosts.demo 9.2 7/15/93 15:20:45
    # Description:
    # Default sqlhosts file for running demos.
    #
    #************************************************* *******

    demo_on onipcshm on_hostname on_servername
    demo_se seipcpip se_hostname sqlexec
    cg_se seipcpip lrt sqlexec


    SO I see the instance of the database is cg_se. but when I set up the INFORMIXSERVERNAME enviornment variable and then try to run dbaccess it says there is a error finding the database. I don't see any prot number or nothing.

    if I try to go to etc/services to see the assigned port number ,, I get

    # cd etc
    # more services
    #ident "@(#)services 1.9"
    #ident "$Header$"

    #
    # assigned numbers from rfc1060
    #
    tcpmux 1/tcp
    echo 7/tcp
    echo 7/udp
    discard 9/tcp sink null
    discard 9/udp sink null
    systat 11/tcp users
    systat 11/udp users
    daytime 13/tcp
    daytime 13/udp
    netstat 15/tcp
    netstat 15/udp
    qotd 17/tcp quote
    qotd 17/udp quote
    chargen 19/tcp ttytst source
    chargen 19/udp ttytst source
    ftp-data 20/tcp
    ftp 21/tcp
    telnet 23/tcp
    smtp 25/tcp mail
    time 37/tcp timserver
    time 37/udp timserver
    name 42/tcp nameserver
    name 42/udp nameserver
    whois 43/tcp nicname # usually to sri-nic
    whois 43/udp nicname # usually to sri-nic
    nameserver 53/udp domain
    nameserver 53/tcp domain
    apts 57/tcp #any private terminal service
    apfs 59/tcp #any private file service
    bootps 67/udp bootp
    bootpc 68/udp
    tftp 69/udp
    rje 77/tcp netrjs #any private rje
    finger 79/tcp
    http 80/tcp
    link 87/tcp ttylink
    supdup 95/tcp
    hostnames 101/tcp hostname # usually to sri-nic
    iso-tsap 102/tcp
    x400 103/tcp # ISO Mail
    x400-snd 104/tcp
    csnet-ns 105/tcp #CSNET Name Service
    pop-2 109/tcp # Post Office
    pop-3 110/tcp # Post Office
    sunrpc 111/udp rpcbind
    sunrpc 111/tcp rpcbind
    auth 113/tcp authentication
    sftp 115/tcp
    uucp-path 117/tcp
    nntp 119/tcp usenet readnews untp # Network News Transfer
    erpc 121/udp
    ntp 123/tcp # Network Time Protocol
    ntp 123/udp # Network Time Protocol
    nb-ns 137/udp nbns netbios-nameservice
    nb-ns 137/tcp nbns netbios-nameservice
    nb-dgm 138/udp nbdgm netbios-datagram
    nb-dgm 138/tcp nbdgm netbios-datagram
    nb-ssn 139/tcp nbssn netbios-session
    imap-4 143/tcp
    NeWS 144/tcp news # Window System
    iso-tp0 146/tcp
    iso-ip 147/tcp
    bftp 152/tcp
    snmp 161/udp
    snmp-trap 162/udp
    cmip-manage 163/tcp
    cmip-agent 164/tcp
    print-srv 170/tcp
    bgp 179/tcp
    smux 199/tcp
    #
    # UNIX specific services
    #
    # these are NOT officially assigned
    #
    exec 512/tcp
    login 513/tcp
    shell 514/tcp cmd # no passwords used
    printer 515/tcp spooler # line printer spooler
    timed 525/udp timeserver
    courier 530/tcp rpc # experimental
    # uucpd is not supported by System V UNIX.
    uucp 540/tcp uucpd # uucp daemon.
    biff 512/udp comsat
    who 513/udp whod
    syslog 514/udp
    talk 517/udp
    ntalk 518/udp
    route 520/udp router routed
    new-rwho 550/udp new-who # experimental
    rmonitor 560/udp rmonitord # experimental
    monitor 561/udp # experimental
    pcserver 600/tcp # ECD Integrated PC board srvr
    bootps-alt 950/udp # bootps port used with DHCP
    ingreslock 1524/tcp
    aas 1601/tcp # Address Allocation Server
    nfsd 2049/udp # NFS server daemon
    listen 2766/tcp # sysv listener service
    ttymon 2767/tcp # sysv tty service
    xserver0 6000/tcp # X-Window Server Display 0
    pppmsg 911/tcp # PPP daemon
    inetinst 6969/tcp # Network Install
    inetinst 1006/spx # Network Install
    i2odialog 360/tcp # i2o configuration dialog agent
    unixtsa 413/tcp
    dtspc 6112/tcp # subprocess control

    no where it says which one is assigned to informix.

    One more thing ,, when I do su - informix . and get a $ prompt back , I cann't issue any command relating to informix (like dbaccess or any other command says not found or permission denied). No sure why is that>

    I am using Informix SE 7.20.

    if I log in as root and then su -ing it to informix,, no informix command works. Now if I try from root and try to run dbaccess(after setting all the env variables) I can see the db access running but without database name (for example I see --------@cg_se---- but not main@cg_se).

    Any help would be appreciated.

    Thanks
    Moloy

  9. #9
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    A couple of issues:

    1. Check the .profile for Informix. My guess is that you don't have any informix variables defined nor do you have .../informix/bin defined in your path - which is why you can't run any informix commands.


    2. Your onconfig will be under .../informix/etc unless an environment variable points otherwise. If you don't have one, you need to create one.

    3. Your sqlhosts is incomplete, but it's likely that the terminal session is attempting to connect thorugh a shared memory connection which is not needed in sqlhosts.
    Fred Prose

  10. #10
    Join Date
    Apr 2004
    Location
    Brussels
    Posts
    57
    I know it's rather difficult (in the begin), but I guess you not herite a documented DB :
    - onconfig file is for IDS, normally in $INFORMIXDIR/etc and not $INFORMIXDIR/bin. ONCONFIG variable could also contain a full path
    - you must set up INFORMIXSERVER variable (INFORMIXSERVERNAME is not a recognized variable)
    - you've find the sqlhosts file, bu I did'tn know the meaning of "seipcip", "soctcp" needs a portnumber but not ipc or shm connections.
    - Look at the documentation for Informix SE, and aaargh p3.8 onconfig only for IDS , not for SE cfr : http://www-306.ibm.com/software/data...7921a-pdf.html
    and all the info you need (I hope) Admin Guide for Informix SE 7.x at http://www-306.ibm.com/software/data.../9002-pdf.html p1.8 and 1.12

    Good luck again,
    Yves & Willy

  11. #11
    Join Date
    Apr 2004
    Posts
    9

    Smile I can see .sql file and .unl files

    I finally find a way to do a dbexport of one of the database in that UNIX box. I can see the .exp directory, and inside that I can see the .sql file and the .unl file. I still have to get those in the sql server 2000 box but that is another issue. The problem I had was due to inexperience in UNIX administration. I was setting up the "env" variable in the root level and then when I use to do su - informix the required environment variables were not there. That was the first major mistake. Then I did not set up the DBPATH environment variable. As we have different directory for different company, the dbaccess/dbschema/dbexport commands are all getting confused to which company I was pointing. Then there are other issues as I was not familiar with Informix as well. Although I couldn't find the port number the informix is listening to>> but I had the .SQL file and all those .UNL(560) files to work with.

    But over all I want to thank you guys/gals all to help me out. You probably save my job. Is there anything I need to know to export/run those .sql and .unl file from UNIX BOX to window 2000 box for SQL SERVER 2000.

    Thanks again for such great help.

    Moloy

  12. #12
    Join Date
    Jul 2003
    Location
    Chennai,India
    Posts
    11
    U cant restore with a dbexport taken from Informix in to SQL server. Instead try to import data using SQL server wizard giving data source as appropriate informix driver available in ur machine.

    Niranjan.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •