Unix Technical Forum

Dynamic Virtual segment allocation - finding the cause?

This is a discussion on Dynamic Virtual segment allocation - finding the cause? within the Informix forums, part of the Database Server Software category; --> IDS9.30HC5, HP-UX11i One of our hundreds of users has run something that's caused extra virtual segment allocation. Background: The ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 05:29 PM
malc_p@btinternet.com
 
Posts: n/a
Default Dynamic Virtual segment allocation - finding the cause?

IDS9.30HC5, HP-UX11i
One of our hundreds of users has run something that's caused extra
virtual segment allocation.
Background:
The system runs for months on a single Virtual segment of 600Mb, quite
happily day and night with up to 300 connections, all running any one
of the hundred or so 4gl OLTP programs which are the most used; they
generally tend to be enquiry or updates for about a dozen rows, tops
(it's a policy administration system). There's some progs that build
reports, other stuff like that.
Just a couple of times lately, the system has added 6 100Mb (SHMADD
size) segments after which the OS has none left so we get an OS error
report (over a 15-minute period); obviously some user has run a
program or report with a wildcard query that's asked for sort or group
space, yes?
Trouble is, by the time we get the alert, whatever the rogue is has
finished and we can't seem to find out what it was doing it, so we
need to somehow jump in early.
OK, no big deal, I've now set up a cron which will detect the first
new allocation so when it does it again I can be in quick to do some
delving.
What do I do? (and don't start me on onmode -F on HP-UX!!!!!!!!!!)
First off is onstat -g seg to find the address of the new segment, no
problem.
But once I've done that, what's the next move?
I'm guessing onstat -g mem and find out what processes have a pool
starting within that new segment?
Also, there's onstat -g afr when I've found a likely target, but I
don't know what the "memid" identifiers mean - there's fragman, osenv,
sqscb,osenvgentcb and so on but I can't find definitions for these.
TIA
Malc

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:39 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com