10. Understanding Ingres Management Architecture : Class ID Objects : IMA_STATUS_LOOKUP
 
Share this page                  
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_session_mode
      1
Initiating
 
      2
Input
 
      3
Output
 
      4
Terminating
 
      5
Exchange
 
     10
Read
 
ima_thread_state
      0
Unallocated block
 
      1
Computable
 
      2
Event wait
 
      3
MUTEX
 
      4
STACK_WAIT
 
      5
UWAIT
 
      6
CNDWAIT
 
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_fcserver_cond
      1
CPREADY
 
      2
CPWAIT
 
      3
RECOVER
 
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_tx_wait_reason
      1
FORCE
 
      2
FREE
 
      3
SPLIT
 
      4
HDRIO
 
      5
CKBDB
 
      6
OPENDB
 
      7
BCPSTALL
 
      8
LOGFULL
 
      9
FREEBUF
 
     10
LASTBUF
 
     11
BUFIO
 
     12
EVENT
 
     13
WRITEIO
 
     14
LOGSPACE
 
ima_lk_attribute
      1
Physical
 
      2
Temporary
 
      4
Cancel
 
      8
Enqwait
 
     16
ConCancel
 
ima_lk_mode
      0
Null
 
      1
Intent Shared
 
      2
Intent Exclusive
 
      3
Shared
 
      4
Shared-Intent-Exclusive
 
      5
Exclusive
 
ima_lk_state
      1
GR
 
      2
CV
 
      3
WT
 
ima_lklist_status
      1
Waiting
 
      2
Non Protected
 
      4
Orphaned
 
      8
EWAIT
 
     16
RECOVER
 
     32
MASTER
 
     64
ESET
 
    128
EDONE
 
    256
NOINTERRUPT
 
    512
SHARED
 
   1024
PARENT_SHARED
 
   2048
ENQWAITING
 
   4096
GDLK_SRCH
 
   8192
ST_ENQ
 
  16384
MASTER_CSP
 
ima_lk_type
      1
DATABASE
 
      2
TABLE
 
      3
PAGE
 
      4
EXTEND_FILE
 
      5
BM_PAGE
 
      6
CREATE_TABLE
 
      7
OWNER_ID
 
      8
CONFIG
 
      9
DB_TEMP_ID
 
     10
SV_DATABASE
 
     11
SV_TABLE
 
     12
SS_EVENT
 
     13
TBL_CONTROL
 
     14
JOURNAL
 
     15
OPEN_DB
 
     16
CKP_DB
 
     17
CKP_CLUSTER
 
     18
BM_LOCK
 
     19
BM_DATABASE
 
     20
BM_TABLE
 
     21
CONTROL
 
     22
EVCONNECT
 
     23
AUDIT
 
     24
ROW
 
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