Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2009
    Posts
    21

    Unanswered: Cant Even Log In

    Hi,
    I am a real Beginner, I have used Oracle, MySql but not Informix
    so my question are
    1) How do you Login , Oracle it is simple it wil lask you username - tiger
    and password - scott
    2) is there any site which will be a step by step guide how to use informix 10.5 because though i looked up IBM is doesnt give a tutorial for out and out total beginner

    any help would be appreciated

    thanks

  2. #2
    Join Date
    Feb 2009
    Posts
    51
    Quote Originally Posted by minhaj_arif
    Hi,
    I am a real Beginner, I have used Oracle, MySql but not Informix
    so my question are
    1) How do you Login , Oracle it is simple it wil lask you username - tiger
    and password - scott
    2) is there any site which will be a step by step guide how to use informix 10.5 because though i looked up IBM is doesnt give a tutorial for out and out total beginner

    any help would be appreciated

    thanks
    I remember me when I was a beginner Informix DBA I didn’t know how I can shutdown Informix. Thanks IBM for it. But today you can to find some IBM resources about IDS. I will speak about it in point 2.
    1.You asked - How do you Login
    You should login in operating system as user Informix with necessary password (default password informix). And you will get all privileges, for example, as root in UNIX.
    2. You speak about Informix 10.5. As I know this is Informix 11.1 or 11.5. Please do “onstat –“ and post output here.
    For IDS 11.1 you can find Infocenter 11.1.
    For IDS 11.5 you can find Infocenter 11.5.

  3. #3
    Join Date
    Apr 2009
    Posts
    21

    futher login query

    I did do onstat and it says it is version 11.5
    But i am not a DBA and neither a Database guy i am a programmer have to deal with informix my problem is i dont know how to use it
    1) can u please guide me step by step as how to login.
    how i go is AllProgram--->IBM informix client sdk 3.5-->ILogonDemo-->
    and the ILoginDemo will pop up a with tab file and Help,
    File--> run--> this ask me a couple of questions like server name, host, protocol whick i do put in but doesnt work shows me one orthe other error am i going right is this how it works

    Thanks

  4. #4
    Join Date
    Apr 2009
    Posts
    21
    i have informix on widow xo when i installed it, it created a informix user just in case if it helps on typing onstat this is what it gave


    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set INFORMIXDIR=C:\PROGRA
    ~1\IBM\IBMINF~1\11.50

    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set INFORMIXSERVER=ol_ids
    _1150_1

    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set ONCONFIG=ONCONFIG.ol_
    ids_1150_1

    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set PATH=C:\PROGRA~1\IBM\
    IBMINF~1\11.50\bin;C:\WINDOWS\system32;C:\WINDOWS; C:\WINDOWS\System32\Wbem;C:\PR
    OGRA~1\ibm\gsk7\bin;C:\PROGRA~1\ibm\gsk7\lib;C:\Pr ogram Files\IBM\Informix\Clien
    t-SDK\bin;C:\Program Files\ibm\gsk7\bin;C:\Program Files\ibm\gsk7\lib

    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set CLASSPATH=C:\PROGRA~1
    \IBM\IBMINF~1\11.50\extend\krakatoa\krakatoa.jar;C :\PROGRA~1\IBM\IBMINF~1\11.50\
    extend\krakatoa\jdbc.jar;

    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set DBTEMP=C:\PROGRA~1\IB
    M\IBMINF~1\11.50\infxtmp

    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set CLIENT_LOCALE=EN_US.C
    P1252

    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set DB_LOCALE=EN_US.8859-
    1

    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set SERVER_LOCALE=EN_US.C
    P1252

    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set DBLANG=EN_US.CP1252

    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>mode con codepage select=
    1252

    Status for device CON:
    ----------------------
    Lines: 300
    Columns: 80
    Keyboard rate: 31
    Keyboard delay: 1
    Code page: 1252


    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>onstat
    Your evaluation license will expire on 2009-07-18 02:00:00

    IBM Informix Dynamic Server Version 11.50.TC3TL -- On-Line -- Up 02:26:49 -- 7
    8208 Kbytes

    Userthreads
    address flags sessid user tty wait tout locks nreads nwrites

    ee65018 ---P--D 1 informix - 0 0 0 31 103
    ee65600 ---P--F 0 informix - 0 0 0 0 73
    ee65be8 ---P--F 0 informix - 0 0 0 0 0
    ee661d0 ---P--F 0 informix - 0 0 0 0 0
    ee667b8 ---P--F 0 informix - 0 0 0 0 0
    ee66da0 ---P--F 0 informix - 0 0 0 0 0
    ee67388 ---P--F 0 informix - 0 0 0 0 0
    ee67970 ---P--F 0 informix - 0 0 0 0 0
    ee67f58 ---P--F 0 informix - 0 0 0 0 0
    ee68540 ---P--- 8 informix - 0 0 0 0 0
    ee68b28 ---P--B 9 informix - 0 0 0 0 0
    ee69110 Y--P--D 22 informix - c0c3580 0 0 0 0
    ee696f8 ---P--D 13 informix - 0 0 0 2 0
    ee69ce0 ---P--D 12 informix - 0 0 0 0 0
    ee6a2c8 ---P--- 20 informix - 0 0 1 64 16
    ee6a8b0 ---P--- 19 informix - 0 0 1 156 2
    ee6ae98 ---P--- 21 informix - 0 0 1 60 16
    17 active, 128 total, 25 maximum concurrent

    Profile
    dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cache
    d
    324 340 11491 97.18 140 211 794 82.37


    isamtot open start read write rewrite delete com
    mit rollbk
    11281 1232 1793 4717 412 14 0 39
    0

    gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
    2 0 0 0 0 0 2

    ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
    0 0 0 3.37 0.90 11 11

    bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seq
    scans
    40 0 3030 0 0 0 7 304


    ixda-RA idx-RA da-RA RA-pgsused lchwaits
    19 0 5 24 1


    C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>

Posting Permissions

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