Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Posts
    4

    Unanswered: explanation of the memory pool names.

    I searched IBM web site very hard and couldn't find the explanation of memory pool names displayed by 'onstat -g ses'.
    These pool names are abbreviations.
    Is there any one can help me find related documents about this?
    The pool names I concern are:
    sapi, temprec, sqscb, keys, opentable,

  2. #2
    Join Date
    Oct 2002
    Posts
    52
    What is your Informix version? OS?

  3. #3
    Join Date
    Dec 2002
    Posts
    4
    Informix Dynamic Server 2000 Version is 9.21.HC4XM.
    The box is a HP box.

    In fact, this is a remote machine and I don't have privilege to access it.
    People passed me the log dumped out by 'onstat', I analyze them.

    The issue I got is, when our application (using informix jdbc methods to access database) running, the memory assign to the application sql session kept on growing. In fact, other memory pools size were quite stable except the pools I listed.

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Check http://www.oninit.com/onstat

    link the G's
    onstat -g ses
    rws

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    There really is not detailed documentation like this - anything ending with scb, you can translate to session control block. The sapi, I believe references the server api for the datablade module.

Posting Permissions

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