sysseglst seg_class Values

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, >From this old chat with the labs presentation ( www.iiug.org/webcasts/replay/08apr08.pdf), the following select statement 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@gmail.com> To: informix-list@iiug.org Date: 02/01/2012 17:00 Subject: sysseglst seg_class Values Sent by: informix-list-bounces@iiug.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@iiug.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