state of IDS in sysmaster tables
Waldemar Znoinski asked whether the state of IDS (single-user, online, quiescent) can be read via SQL. John Miller said to use select sh_mode from sysshmvals, with values -1 offline, 0 initialisation, 1 quiescent, 2 recovery, 3 backup, 4 shutdown, 5 online and 6 abort, and that single-user is an attribute of online. Art Kagel added that HDR, RSS and SDS secondaries show mode 2. Waldemar thanked them.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi folks, I just went thru sysmaster:sys* tables and I've tried to find it on CDI and here - no luck. Is there a way of checking current state (Single-user, On-Line, Quiescent) of IDS (I saw sysonlinelog table which would be harsh to parse :/). cheers
... is there a way of checking it in sysmaster tables or others (so somehow using SQL).
Waldemar:
While yes the state of the server is stored in sysmaster. It is sometimes
hard to get at because the server is not operational, such as, when the
Informix server is in Quiescent mode. To find the mode
select sh_mode from sysshmvals;
-1 Offline (-1 = 255)
0 Initialisation
1 Quiescent
2 Recovery
3 Backup
4 Shutdown
5 Online
6 Abort.
You can think of single user as an atrribute of being online and
not a mode.
These modes match up to the return codes of onstat
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 07/29/2010 12:07:21 PM:
> [image removed]
>
> state of IDS in sysmaster tables [20697]
>
> WALDEMAR ZNOINSKI
>
> to:
>
> ids
>
> 07/29/2010 12:08 PM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> Hi folks,
> I just went thru sysmaster:sys* tables and I've tried to find it on CDI
and
> here - no luck. Is there a way of checking current state (Single-user,
> On-Line, Quiescent) of IDS (I saw sysonlinelog table which would be harsh
to
> parse :/).
>
> cheers
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
SELECT sh_mode
FROM sysshmvals;
mode = 5 is online
mode = 2 is recovery - including HDR, RSS, and SDS secondaries which are
always in perpetual recovery.
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, Jul 29, 2010 at 3:07 PM, WALDEMAR ZNOINSKI <waldek@znoinski.pl>wrote:
> Hi folks,
> I just went thru sysmaster:sys* tables and I've tried to find it on CDI and
> here - no luck. Is there a way of checking current state (Single-user,
> On-Line, Quiescent) of IDS (I saw sysonlinelog table which would be harsh
> to
> parse :/).
>
> cheers
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016369c9078b1ff64048c8c3873
thanks for the replies folks!