If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > explanation of the memory pool names.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-11-02, 16:37
julia ding julia ding is offline
Registered User
 
Join Date: Dec 2002
Posts: 4
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,
Reply With Quote
  #2 (permalink)  
Old 12-12-02, 04:09
thedafna thedafna is offline
Registered User
 
Join Date: Oct 2002
Posts: 52
What is your Informix version? OS?
Reply With Quote
  #3 (permalink)  
Old 12-12-02, 10:05
julia ding julia ding is offline
Registered User
 
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.
Reply With Quote
  #4 (permalink)  
Old 12-13-02, 06:12
Roelwe Roelwe is offline
Registered User
 
Join Date: Aug 2002
Location: Belgium
Posts: 534
Check http://www.oninit.com/onstat

link the G's
onstat -g ses
__________________
rws
Reply With Quote
  #5 (permalink)  
Old 12-13-02, 22:29
rnealejr rnealejr is offline
Registered User
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On