Results 1 to 11 of 11
  1. #1
    Join Date
    Feb 2009
    Posts
    4

    Unanswered: Informix database

    Hello everybody!!!
    I am new to this Informix Database. Wanted some help from you all.

    Here I am posting some of the queries.
    (i) Command to check the Informix Database if it is Alive.
    (ii) Command to check how many tables are there in the database.
    (iii) Command to check the status of the databases.

    Please help me out, if anybody has the answers and also if somebody knows any URL where I can able to find these answers, please do let me know.


    Thanks In Advance,
    N

  2. #2
    Join Date
    Aug 2005
    Posts
    140
    i suppose you want to check the status of informix instance (not informix database)
    (i),(iii)
    Code:
    onstat -
    (ii) http://www.dbforums.com/informix/160...ll-tables.html

  3. #3
    Join Date
    Feb 2009
    Posts
    4
    Thanks for your reply!!!!!!

    Yes, I want to check the status of informix instances.

    But I am not able see the first answer.


    Thanks,
    Nabanita

  4. #4
    Join Date
    Nov 2004
    Posts
    143
    To check the status of informix instance, run the below

    onstat -

    Nitin

  5. #5
    Join Date
    Feb 2009
    Posts
    4
    Hey Thanks Nitin!!!!!!

  6. #6
    Join Date
    Sep 2008
    Posts
    33

    Hi

    If you have muliple instances,You can use
    onstat -g dis to see the status of each instance

    Regards
    Mallik

  7. #7
    Join Date
    Feb 2009
    Posts
    4
    Thanks A Lot Mallik!!!!!!!!!

  8. #8
    Join Date
    Feb 2009
    Posts
    2

    Informix dbexport and dbimport

    )Hi guys

    I need to do a dbexport and then a dbimport of the database I want to know the command for dbexport and dbimport , also what to know that does buffered and unbufferd means.

    thanks
    Last edited by rovee25; 02-06-09 at 03:57.

  9. #9
    Join Date
    Feb 2009
    Posts
    2
    Guys I need the exact syntax for doing the following

    i) dbexport

    ii) dbimport

    iii) what does buffered and unbuffered logging means

  10. #10
    Join Date
    Aug 2005
    Posts
    140
    I don't wanna be arrogant, but I think that some people
    don't se the purpose of this forum.
    So please, don't ask questions that can be very easily answered by reading the relevant manual.

    peace

  11. #11
    Join Date
    Sep 2008
    Posts
    33
    Hi,

    Lets use this forum in better way.Those questionns are really silly.U can get those in google and got many pdf's for that.

    Mallik

Posting Permissions

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