IMA_STATUS_LOOKUP

ima_server_state_mask	1	No thread switching
	2	Adding a new session
	4	Server will shutdown when last session exits
	8	Server WILL shutdown
	16	Server running with session accounting set
	32	Server is recording CPU statistic information

ima_server_internal_state_mask	0	Uninitialized
	16	Initializing
	32	Normal Processing mode
	37	Switching Sessions
	48	Server is Idle
	64	Server is closing down (set server shut)
	80	Server WILL shut down
	96	Server has encountered an error

ima_dmf_cache_status	1	Group
	2	Fwait
	4	Wbwait
	8	FCflush
	16	Shared Cache
	32	Pass abort in progress
	64	PrePass abort

ima_active_log_files	1	Primary Log file II_LOG_FILE
	2	Dual Log file II_DUAL_LOG

ima_log_header_status	1	Valid
	2	Recovery in progress
	3	EOF_OK
	4	BAD
	5	OK

ima_log_version	65537	Pre-OpenINGRES
	65538	OpenINGRES 1.1/03

ima_log_file_status	1	Logging system will attempt to use Dual IO
	2	Primary log has been opened
	4	Dual log has been opened
	8	Dual logging in progress
	16	Logging system will not use Dual IO

ima_logging_system_status	1	Online
	2	Consistency Point needed
	4	Logging system is full (stall condition)
	8	Force-Abort limit has been exceeded
	16	Logging system is in recovery mode
	32	Archiver is active
	64	Archiver is shutting down
	128	rcpconfig -imm_shutdown has been requested
	256	Archiver has shutdown, but is needed
	512	Purge in progress
	1024	Logging system is opening a new database
	2048	Logging system is closing a database
	4096	rcpconfig -shutdown has been requested
	8192	BCP has been written
	16384	Consistency point flush in progress
	32768	End Consistency point being processed
	65536	Consistency point has been completed
	131072	Consistency point has been signalled
	262144	Stall for start of CP
	524288	Online Checkpoint in progress
	1048576	Lartool used for manual abort
	2097152	Lartool used for manual commit

ima_lock_stall_type	1	Stall all except the Master CSP process
	2	Stall all user (logical) locks

ima_locking_system_status	1	AST_ENABLE
	2	CLUSTER_SYSTEM
	4	CSP_RUNDOWN
	8	IN_CSP_COMPLETION

ima_server_capabilities	1	Resource Control
	2	C2 security
	4	INGRES DBMS
	8	RMS
	16	INGRES Star
	32	RECOVERY server

ima_cursor_flags	1	DIRECT_UPDATE
	2	DEFERRED_UPDATE

ima_server_flatten_options	1	Optional flattening
	2	No flattening
	4	Flatten non aggregates
	8	Flatten non singleton

ima_server_listen_mask	1	Normal connections allowed
	2	Only special (priv) users connections permitted
	4	Server will close down when the last session exits

ima_server_activity	0	Uninitialized
	1	Initializing
	2	Shutting down
	3	Normal operation
	4	Participating in 2PC recovery

ima_async_mask	1	Timeout can happen
	2	Interrupts are allowed
	4	Thread stack has been corrupted
	64	Thread is marked for termination
	128	Interrupt is pending
	256	No transaction in progress
	512	Thread is a monitor session
	1024	Thread has fatal error
	2048	Request aborted
	4096	Thread started in mid-quantum
	8192	Event has completed
	16384	Interrupt received
	32768	Timed out
	65536	Collect CPU statistics for this session

ima_db_status	1	Database is active
	2	Database is journaled
	4	Control block is invalid
	8	Internal database - used for internal sessions
	16	Log records for this db are being purged to jnl
	32	OpenDB Pending
	64	CloseDB pending
	128	Recovery in progress
	256	Fast Commit
	512	Database invalid but being opened
	1024	CloseDB done
	2048	Tx waiting for OpenDB to complete
	4096	Db undergoing online ckp and is stalled
	8192	Db undergoing online ckp and is active
	16384	Db undergoing online ckp and is in final stage
	131072	Final Backup state - ckp only needs to update cnf
	262144	Error occurred on db during online ckp

ima_process_status	1	Process is still active
	2	Process is master recovery process (RCP)
	4	Process is archiver process (ACP)
	8	process is a fast commit server
	16	process is a server that has died abnormally
	32	process is a server
	64	process is checkpoint process
	128	process is dead and recovered
	256	process is a server with a shared buffer manager
	512	process is idle (connected to SBM but may exit)
	1024	process has died
	2048	process has been killed by logging system
	4096	FOREIGN_RUNDOWN
	8192	Process participates in Consistency Point

ima_tx_status	1	No log record written yet
	2	BT record has been written to log
	4	Tx is waiting for an online CKP
	8	Tx is protected from the ACP - BOF will not pass
	16	Records for this Tx should be archived
	32	No db changes will be made inside this Tx
	64	This Tx will never be the oldest for abort
	128	Tx needs recovery
	256	Tx has been chosed as the oldest for abort
	512	Tx is marked for abort by the RCP
	1024	Tx is marked for abort by the server
	2048	Tx is undergoing Pass Abort
	4096	Tx is accessing an inconsistent DB
	8192	Tx waiting for log event completion
	16384	Tx is part of a distributed Tx
	32768	Tx is prepared
	65536	REASSOC_WAIT
	131072	RESUME
	262144	MAN_ABORT
	524288	MAN_COMMIT
	1048576	LOGWRITER_THREAD
	2097152	SAVEABORT
	4194304	Tx needs space which it has not reserved
	8388608	Tx has lost the parent DBMS

ima_facility_index	0	(none)
	1	(Compatibility Lib)
	2	(Abstract Data type Facility)
	3	(Data Manipulation Facility)
	4	(Optimizer Facility)
	5	(Parser Facility)
	6	(Query Execution Facility)
	7	(Query Storage Facility)
	8	(Relation Descriptor Facility)
	9	(System Control Facility)
	10	(Utility Facility)
	11	(Database Utility Facility)
	12	(General Communication facility)
	13	(Remote Query facility)
	14	(Transaction Processing facility)
	15	(Gateway facility)
	16	(Security Extensions facility)

ima_rdf_cache_status	1	Relation description cache is allocated
	2	LDB description cache is allocated
	4	Relation hash table is created
	8	Qtree hash table is created
	16	DEFAULT hash table is created