Hello,

Does anyone have a list of the current possible values for the
sysmaster:sysseglst table for the seg_class column? I searched
through documentation and older posts and was not able to find it
documented. I know that 1 = Resident and 2 = Virtual. We have a home
grown monitoring script and I want to decode the values and display a
description. Any help would be greatly appreciated.

We are running 11.50.FC6.

Thank You,

Dave

Hi Dave,

decodes the values for you:

SELECT seg_osshmid, seg_osshmkey, seg_address,
decode(seg_class, 1, "Resident",2,"Virtual",3,"Message","Other") as CLASS,
format_units( seg_size,"b") AS SIZE,
format_units( seg_blkused,"4") AS USED,
format_units( seg_blkfree,"4") AS FREE
FROM sysseglst

Happy New Year and best regards,

Stuart




From: Dave <in4mixdba (AT) gmail (DOT) com>
To: informix-list (AT) iiug (DOT) org
Date: 02/01/2012 17:00
Subject: sysseglst seg_class Values
Sent by: informix-list-bounces (AT) iiug (DOT) org



Hello,

Does anyone have a list of the current possible values for the
sysmaster:sysseglst table for the seg_class column? I searched
through documentation and older posts and was not able to find it
documented. I know that 1 = Resident and 2 = Virtual. We have a home
grown monitoring script and I want to decode the values and display a
description. Any help would be greatly appreciated.

We are running 11.50.FC6.

Thank You,

Dave
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list








Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number
741598.
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU