Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Informix - Performance Tuning - Help !

    Hi Experts,

    I am basically DB2 DBA. But I need to analyze two informix servers (9.4 and 10.x on AIX 5.3)

    Please help me find some document that can be helpful.

    The situation is such that I do not even know where is the relevant information and how to query this info. Can someone hep me with an example.

    eg. tarnsactions per second
    Hit ratios
    Lock waits
    Informix memory usage
    disk space alllocations and usage.

    Thanks

    DBFinder
    Last edited by DBFinder; 09-23-11 at 08:11.

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi Db,

    for what you want, the start point is the onstat command, logged as informix.
    * the main one for what you want: onstat -p
    will give you the main 50 main indicators of your instance ( mainly the ones you are looking for )

    for disk space, use onstat -d

    for memory usage per session, use onstat -g ses

    onstat is very simple to use and has many options thatwill give you almost all
    the perf counters of your instance.
    type onstat -- to have a brief help

    Hope this helps

    Eric

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks Eric,

    How can I find the memory allocated to informix ?

    Regards

  4. #4
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,

    on all onstat -<something> commands output, at the first line on the right you have the current Shared Memory allocated size in Kb.

    if you want more details, onstat -g mem and onstat -g seg are good candidates.

    To have all the options of onstat, type onstat -- | more.

    And if you are furious for coding SQL, explore the sysmaster database, but sincerely onstat is so practical and useful when you are in a rush.

    Regards,

    Eric

  5. #5
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks for quick response.

    I can find my way around now.

    Regards

Posting Permissions

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