Was this helpful?
Class ID Objects
This list of classid objects is taken from an Ingres 2006 9.0.4 release.
On Windows, the following servers were running:
DBMS
GCC
Star
RCP
ACP
Bridge Server
DAS
JDBC
GCN
Remote Command server
On an Ingres 2006 9.0.4 NPTL release on Linux, the following servers were running:
DBMS
GCC
Star
RCP
ACP
DAS
GCN
Notes:
1. This is not a complete list of all IMA objects in Actian X.
2. A description is provided, where time has allowed.
3. Objects with IMA can be added or removed.
Classid
Description
exp.adf.adg.dt_id
 
exp.adf.adg.dt_ix
 
exp.adf.adg.dt_name
 
exp.adf.adg.dt_stat
 
exp.adf.adg.fi_dtarg1
 
exp.adf.adg.fi_dtarg2
 
exp.adf.adg.fi_dtarg3
 
exp.adf.adg.fi_dtarg4
 
exp.adf.adg.fi_dtresult
 
exp.adf.adg.fi_id
 
exp.adf.adg.fi_ix
 
exp.adf.adg.fi_numargs
 
exp.adf.adg.fi_opid
 
exp.adf.adg.fi_type
 
exp.adf.adg.op_id
 
exp.adf.adg.op_ix
 
exp.adf.adg.op_name
 
exp.adf.adg.op_type
 
exp.clf.di.di_slaveno
The Linux server slave number, starting at 1. The processes themselves are numbered from 0.
exp.clf.di.dimo_collect
Setting this object causes DI I/O slave statistics to be collected.
exp.clf.di.dimo_cpu.tm_msecs
Number of milliseconds of CPU consumed by the slave
exp.clf.di.dimo_cpu.tm_secs
Number of seconds of CPU consumed by the slave
exp.clf.di.dimo_dio
Number of DIO (disk I/O) operations done by the slave
exp.clf.di.dimo_idrss
The resident set size of the slave
exp.clf.di.dimo_majflt
Number of major page faults in the slave
exp.clf.di.dimo_maxrss
The maximum resident set size of the slave
exp.clf.di.dimo_minflt
Number of minor page faults by the slave
exp.clf.di.dimo_msgrcv
Number of messages received by the slave
exp.clf.di.dimo_msgsnd
Number of messages sent by the slave
exp.clf.di.dimo_msgtotal
Total number of messages sent and received by the slave
exp.clf.di.dimo_nivcsw
Number of involuntary context switches by the slave
exp.clf.di.dimo_nsignals
Number of signals received by the slave
exp.clf.di.dimo_nswap
Number of times the slave has been swapped out
exp.clf.di.dimo_nvcsw
Number of voluntary context switches out of the slave (probably for i/o)
exp.clf.di.dimo_reads
Number of read operations done by the slave
exp.clf.di.dimo_stime.tm_msecs
System CPU milliseconds in the slave
exp.clf.di.dimo_stime.tm_secs
System CPU seconds consumed by the slave
exp.clf.di.dimo_utime.tm_msecs
User CPU milliseconds by the slave
exp.clf.di.dimo_utime.tm_secs
User CPU seconds by the slave
exp.clf.di.dimo_writes
Number of write calls by the slave
exp.clf.gv.bldlevel
 
exp.clf.gv.bytetype
 
exp.clf.gv.charset
 
exp.clf.gv.cnf_index
 
exp.clf.gv.cnf_name
 
exp.clf.gv.cnf_value
 
exp.clf.gv.cnfdat_index
 
exp.clf.gv.cnfdat_name
 
exp.clf.gv.cnfdat_value
 
exp.clf.gv.env
 
exp.clf.gv.genlevel
 
exp.clf.gv.hw
 
exp.clf.gv.instance
 
exp.clf.gv.language
 
exp.clf.gv.majorvers
 
exp.clf.gv.minorvers
 
exp.clf.gv.os
 
exp.clf.gv.patchlvl
 
exp.clf.gv.sql92_conf
 
exp.clf.gv.system
 
exp.clf.gv.tcpport
 
exp.clf.gv.version
 
exp.clf.nt.cs.cnd_index
 
exp.clf.nt.cs.cnd_name
 
exp.clf.nt.cs.cnd_next
 
exp.clf.nt.cs.cnd_prev
 
exp.clf.nt.cs.cnd_waiter
 
exp.clf.nt.cs.desched_usec_sleep
 
exp.clf.nt.cs.dio_resumes
 
exp.clf.nt.cs.lastquant
 
exp.clf.nt.cs.max_sem_loops
 
exp.clf.nt.cs.mon.breakpoint
 
exp.clf.nt.cs.mon.crashserver
 
exp.clf.nt.cs.mon.debug
 
exp.clf.nt.cs.mon.resume_session
 
exp.clf.nt.cs.mon.rm_session
 
exp.clf.nt.cs.mon.shutserver
 
exp.clf.nt.cs.mon.stopcond
 
exp.clf.nt.cs.mon.stopserver
 
exp.clf.nt.cs.mon.suspend_session
 
exp.clf.nt.cs.num_processors
 
exp.clf.nt.cs.samp_index
 
exp.clf.nt.cs.samp_numsamples
 
exp.clf.nt.cs.samp_numtlsdirty
 
exp.clf.nt.cs.samp_numtlsprobes
 
exp.clf.nt.cs.samp_numtlsreads
 
exp.clf.nt.cs.samp_numtlssamples
 
exp.clf.nt.cs.samp_numtlsslots
 
exp.clf.nt.cs.samp_numtlswrites
 
exp.clf.nt.cs.scb_bio
 
exp.clf.nt.cs.scb_client_type
 
exp.clf.nt.cs.scb_cnd
 
exp.clf.nt.cs.scb_connect
 
exp.clf.nt.cs.scb_cputime
 
exp.clf.nt.cs.scb_dio
 
exp.clf.nt.cs.scb_index
 
exp.clf.nt.cs.scb_inkernel
 
exp.clf.nt.cs.scb_length
 
exp.clf.nt.cs.scb_lio
 
exp.clf.nt.cs.scb_locks
 
exp.clf.nt.cs.scb_mask
 
exp.clf.nt.cs.scb_mask_num
 
exp.clf.nt.cs.scb_memory
 
exp.clf.nt.cs.scb_mode
 
exp.clf.nt.cs.scb_nmode
 
exp.clf.nt.cs.scb_owner
 
exp.clf.nt.cs.scb_pid
 
exp.clf.nt.cs.scb_ppid
 
exp.clf.nt.cs.scb_self
 
exp.clf.nt.cs.scb_state
 
exp.clf.nt.cs.scb_state_num
 
exp.clf.nt.cs.scb_stk_size
 
exp.clf.nt.cs.scb_svcb
 
exp.clf.nt.cs.scb_thread_id
 
exp.clf.nt.cs.scb_thread_type
 
exp.clf.nt.cs.scb_thread_type_num
 
exp.clf.nt.cs.scb_type
 
exp.clf.nt.cs.scb_username
 
exp.clf.nt.cs.srv_block.aq_length
 
exp.clf.nt.cs.srv_block.aquantum
 
exp.clf.nt.cs.srv_block.attn
 
exp.clf.nt.cs.srv_block.bquantum0
 
exp.clf.nt.cs.srv_block.bquantum1
 
exp.clf.nt.cs.srv_block.cpu
 
exp.clf.nt.cs.srv_block.current
 
exp.clf.nt.cs.srv_block.cursors
 
exp.clf.nt.cs.srv_block.disconnect
 
exp.clf.nt.cs.srv_block.elog
 
exp.clf.nt.cs.srv_block.error_code
 
exp.clf.nt.cs.srv_block.event_mask
 
exp.clf.nt.cs.srv_block.format
 
exp.clf.nt.cs.srv_block.gca_name
 
exp.clf.nt.cs.srv_block.hwm_active
 
exp.clf.nt.cs.srv_block.idle_time
 
exp.clf.nt.cs.srv_block.known_list
 
exp.clf.nt.cs.srv_block.mask
 
exp.clf.nt.cs.srv_block.max_active
 
exp.clf.nt.cs.srv_block.max_sessions
 
exp.clf.nt.cs.srv_block.next_id
 
exp.clf.nt.cs.srv_block.num_active
 
exp.clf.nt.cs.srv_block.num_sessions
 
exp.clf.nt.cs.srv_block.pid
 
exp.clf.nt.cs.srv_block.process
 
exp.clf.nt.cs.srv_block.q_per_sec
 
exp.clf.nt.cs.srv_block.quantums
 
exp.clf.nt.cs.srv_block.read
 
exp.clf.nt.cs.srv_block.ready_mask
 
exp.clf.nt.cs.srv_block.reject
 
exp.clf.nt.cs.srv_block.saddr
 
exp.clf.nt.cs.srv_block.scballoc
 
exp.clf.nt.cs.srv_block.scbdealloc
 
exp.clf.nt.cs.srv_block.sem_stats.cs_smms_count
 
exp.clf.nt.cs.srv_block.sem_stats.smmsx_count
 
exp.clf.nt.cs.srv_block.sem_stats.smmx_count
 
exp.clf.nt.cs.srv_block.sem_stats.smmxx_count
 
exp.clf.nt.cs.srv_block.sem_stats.smss_count
 
exp.clf.nt.cs.srv_block.sem_stats.smssx_count
 
exp.clf.nt.cs.srv_block.sem_stats.smsx_count
 
exp.clf.nt.cs.srv_block.sem_stats.smsxx_count
 
exp.clf.nt.cs.srv_block.shutdown
 
exp.clf.nt.cs.srv_block.startup
 
exp.clf.nt.cs.srv_block.state
 
exp.clf.nt.cs.srv_block.stk_count
 
exp.clf.nt.cs.srv_block.stk_list
 
exp.clf.nt.cs.srv_block.stksize
 
exp.clf.nt.cs.srv_block.svcb
 
exp.clf.nt.cs.srv_block.to_list
 
exp.clf.nt.cs.srv_block.toq_cnt
 
exp.clf.nt.cs.srv_block.user_sessions
 
exp.clf.nt.cs.srv_block.wait_stats.bio_done
 
exp.clf.nt.cs.srv_block.wait_stats.bio_idle
 
exp.clf.nt.cs.srv_block.wait_stats.bio_time
 
exp.clf.nt.cs.srv_block.wait_stats.bio_waits
 
exp.clf.nt.cs.srv_block.wait_stats.bior_done
 
exp.clf.nt.cs.srv_block.wait_stats.bior_time
 
exp.clf.nt.cs.srv_block.wait_stats.bior_waits
 
exp.clf.nt.cs.srv_block.wait_stats.biow_done
 
exp.clf.nt.cs.srv_block.wait_stats.biow_time
 
exp.clf.nt.cs.srv_block.wait_stats.biow_waits
 
exp.clf.nt.cs.srv_block.wait_stats.dio_done
 
exp.clf.nt.cs.srv_block.wait_stats.dio_idle
 
exp.clf.nt.cs.srv_block.wait_stats.dio_time
 
exp.clf.nt.cs.srv_block.wait_stats.dio_waits
 
exp.clf.nt.cs.srv_block.wait_stats.dior_done
 
exp.clf.nt.cs.srv_block.wait_stats.dior_time
 
exp.clf.nt.cs.srv_block.wait_stats.dior_waits
 
exp.clf.nt.cs.srv_block.wait_stats.diow_done
 
exp.clf.nt.cs.srv_block.wait_stats.diow_time
 
exp.clf.nt.cs.srv_block.wait_stats.diow_waits
 
exp.clf.nt.cs.srv_block.wait_stats.lg_done
 
exp.clf.nt.cs.srv_block.wait_stats.lg_idle
 
exp.clf.nt.cs.srv_block.wait_stats.lg_time
 
exp.clf.nt.cs.srv_block.wait_stats.lg_waits
 
exp.clf.nt.cs.srv_block.wait_stats.lge_done
 
exp.clf.nt.cs.srv_block.wait_stats.lge_time
 
exp.clf.nt.cs.srv_block.wait_stats.lge_waits
 
exp.clf.nt.cs.srv_block.wait_stats.lio_done
 
exp.clf.nt.cs.srv_block.wait_stats.lio_time
 
exp.clf.nt.cs.srv_block.wait_stats.lio_waits
 
exp.clf.nt.cs.srv_block.wait_stats.lior_done
 
exp.clf.nt.cs.srv_block.wait_stats.lior_time
 
exp.clf.nt.cs.srv_block.wait_stats.lior_waits
 
exp.clf.nt.cs.srv_block.wait_stats.liow_done
 
exp.clf.nt.cs.srv_block.wait_stats.liow_time
 
exp.clf.nt.cs.srv_block.wait_stats.liow_waits
 
exp.clf.nt.cs.srv_block.wait_stats.lk_done
 
exp.clf.nt.cs.srv_block.wait_stats.lk_idle
 
exp.clf.nt.cs.srv_block.wait_stats.lk_time
 
exp.clf.nt.cs.srv_block.wait_stats.lk_waits
 
exp.clf.nt.cs.srv_block.wait_stats.lke_done
 
exp.clf.nt.cs.srv_block.wait_stats.lke_time
 
exp.clf.nt.cs.srv_block.wait_stats.lke_waits
 
exp.clf.nt.cs.srv_block.wait_stats.tm_done
 
exp.clf.nt.cs.srv_block.wait_stats.tm_idle
 
exp.clf.nt.cs.srv_block.wait_stats.tm_time
 
exp.clf.nt.cs.srv_block.wait_stats.tm_waits
 
exp.clf.nt.cs.srv_block.write
 
exp.clf.nt.cs.srv_block.wt_list
 
exp.clf.nt.cs.thread_eventDISKIO
 
exp.clf.nt.cs.thread_eventLOCK
 
exp.clf.nt.cs.thread_eventLOCKEVENT
 
exp.clf.nt.cs.thread_eventLOG
 
exp.clf.nt.cs.thread_eventLOGEVENT
 
exp.clf.nt.cs.thread_eventLOGIO
 
exp.clf.nt.cs.thread_eventMESSAGEIO
 
exp.clf.nt.cs.thread_facilityADF
 
exp.clf.nt.cs.thread_facilityCLF
 
exp.clf.nt.cs.thread_facilityDMF
 
exp.clf.nt.cs.thread_facilityDUF
 
exp.clf.nt.cs.thread_facilityGCF
 
exp.clf.nt.cs.thread_facilityGWF
 
exp.clf.nt.cs.thread_facilityOPF
 
exp.clf.nt.cs.thread_facilityPSF
 
exp.clf.nt.cs.thread_facilityQEF
 
exp.clf.nt.cs.thread_facilityQSF
 
exp.clf.nt.cs.thread_facilityRDF
 
exp.clf.nt.cs.thread_facilityRQF
 
exp.clf.nt.cs.thread_facilitySCF
 
exp.clf.nt.cs.thread_facilitySXF
 
exp.clf.nt.cs.thread_facilityTPF
 
exp.clf.nt.cs.thread_facilityULF
 
exp.clf.nt.cs.thread_numsamples
 
exp.clf.nt.cs.thread_stateCNDWAIT
 
exp.clf.nt.cs.thread_stateCOMPUTABLE
 
exp.clf.nt.cs.thread_stateEVENT_WAIT
 
exp.clf.nt.cs.thread_stateFREE
 
exp.clf.nt.cs.thread_stateMUTEX
 
exp.clf.nt.cs.thread_stateSTACK_WAIT
 
exp.clf.nt.cs.thread_stateUWAIT
 
exp.clf.nt.me.num.bytes_used
 
exp.clf.nt.me.num.free_pages
 
exp.clf.nt.me.num.get_pages
 
exp.clf.nt.me.num.pages_used
 
exp.clf.nt.me.num.test_count
 
exp.clf.nt.me.num.test_errs
 
exp.clf.nt.me.num.test_mod
 
exp.clf.unix.cs.cnd_index
ID of a condition variable, a string of the decimal address of the variable. Since this may be a 64-bit pointer, it cannot be held in an integer
exp.clf.unix.cs.cnd_name
The user-given name for the condition variable
exp.clf.unix.cs.cnd_next
The next condition in the chain
exp.clf.unix.cs.cnd_prev
The previous condition in the chain
exp.clf.unix.cs.cnd_waiter
The SCB waiting for the condition
exp.clf.unix.cs.desched_usec_sleep
On uni-processor, amount of time to sleep to de-schedule this server (in microseconds), allowing the server holding a CS semaphore to run (and presumably release it); controlled by the variable II_DESCHED_USEC_SLEEP
exp.clf.unix.cs.dio_resumes
 
exp.clf.unix.cs.lastquant
 
exp.clf.unix.cs.max_sem_loops
Maximum spin loops for CS semaphore before sleeping begins; controlled by the variable II_MAX_SEM_LOOPS
exp.clf.unix.cs.mon.breakpoint
 
exp.clf.unix.cs.mon.crashserver
 
exp.clf.unix.cs.mon.debug
 
exp.clf.unix.cs.mon.resume_session
 
exp.clf.unix.cs.mon.rm_session
OBSOLETE. This object is dangerous. Use exp.scf.scs.scb_remove_session.
exp.clf.unix.cs.mon.shutserver
 
exp.clf.unix.cs.mon.stopcond
 
exp.clf.unix.cs.mon.stopserver
 
exp.clf.unix.cs.mon.suspend_session
 
exp.clf.unix.cs.num_processors
Number of processors believed to exist on this host. Used to pick algorithms appropriate for different environments. Use II_NUM_OF_PROCESSORS to change.
exp.clf.unix.cs.scb_asmask
Thread's async mask as a string
exp.clf.unix.cs.scb_asmask_num
Async mask–look up ima_async_mask in IMA_STATUS_LOOKUP
exp.clf.unix.cs.scb_asunmask
 
exp.clf.unix.cs.scb_asunmask_num
 
exp.clf.unix.cs.scb_async
 
exp.clf.unix.cs.scb_base_priority
 
exp.clf.unix.cs.scb_bio
Number of "buffered" I/Os charged to this session
exp.clf.unix.cs.scb_bior
 
exp.clf.unix.cs.scb_biow
 
exp.clf.unix.cs.scb_client_type
Zero in SCB’s for CL-level threads. The client's identification field.
exp.clf.unix.cs.scb_cnd
Condition being waited for, if any
exp.clf.unix.cs.scb_connect
Time in seconds from epoch when session was started.
exp.clf.unix.cs.scb_cputime
Seconds of CPU charged to this thread. May be inaccurate.
exp.clf.unix.cs.scb_dio
Disk I/O charged to this thread
exp.clf.unix.cs.scb_dior
 
exp.clf.unix.cs.scb_diow
 
exp.clf.unix.cs.scb_ef_mask
Event flag wait mask
exp.clf.unix.cs.scb_index
The ID of the session, a decimal string of the address of the control block. Since this might be a 64-bit pointer, it cannot fit into an integer.
exp.clf.unix.cs.scb_inkernel
Flag indicating whether in delicate internal state (switching thread, checking quantum, and so on)
exp.clf.unix.cs.scb_length
Actual length of this SCB, as allocated.
exp.clf.unix.cs.scb_lgevent
 
exp.clf.unix.cs.scb_lio
 
exp.clf.unix.cs.scb_lior
 
exp.clf.unix.cs.scb_liow
 
exp.clf.unix.cs.scb_lkevent
 
exp.clf.unix.cs.scb_locks
OBSOLETE
exp.clf.unix.cs.scb_logs
 
exp.clf.unix.cs.scb_mask
String of session mask
exp.clf.unix.cs.scb_mask_num
Bitmap of session mask–look up ima_async_mask in IMA_STATUS_LOOKUP
exp.clf.unix.cs.scb_memory
OBSOLETE
exp.clf.unix.cs.scb_mode
Session mode–look up ima_session_modes in IMA_STATUS_LOOKUP
exp.clf.unix.cs.scb_nmode
Next session mode–look up ima_session_modes in IMA_STATUS_LOOKUP
exp.clf.unix.cs.scb_owner
Constant 0xAB0000BA
exp.clf.unix.cs.scb_pid
PID of the server containing this session
exp.clf.unix.cs.scb_ppid
 
exp.clf.unix.cs.scb_priority
Current thread priority
exp.clf.unix.cs.scb_self
CS_SID of the SCB. The same as the index in the Linux CL.
exp.clf.unix.cs.scb_sem_count
Number of semaphores locked by this thread
exp.clf.unix.cs.scb_sm_next
First semaphore owned by this thread
exp.clf.unix.cs.scb_state
One of CS_FREE, CS_COMPUTABLE, CS_STACK_WAIT, CS_UWAIT, CS_EVENT_WAIT, CS_MUTEX, CS_CNDWAIT
exp.clf.unix.cs.scb_state_num
Thread state–look up ima_thread_state in IMA_STATUS_LOOKUP
exp.clf.unix.cs.scb_stk_area
OBSOLETE
exp.clf.unix.cs.scb_stk_size
Stack size
exp.clf.unix.cs.scb_svcb
Pointer to server block that started this thread
exp.clf.unix.cs.scb_thread_id
 
exp.clf.unix.cs.scb_thread_type
-1 for internal thread, 0 for user thread
exp.clf.unix.cs.scb_thread_type_num
-1 for internal thread, 0 for user thread
exp.clf.unix.cs.scb_timeout
Current timeout value, in seconds
exp.clf.unix.cs.scb_type
Constant 0xABCD
exp.clf.unix.cs.scb_uic
The UID of the session owner; mostly useless because it is not really known and meaningless default values are used
exp.clf.unix.cs.scb_username
The username associated with this thread, from the connection information
exp.clf.unix.cs.srv_block.aq_length
 
exp.clf.unix.cs.srv_block.aquantum
 
exp.clf.unix.cs.srv_block.attn
 
exp.clf.unix.cs.srv_block.bquantum0
 
exp.clf.unix.cs.srv_block.bquantum1
 
exp.clf.unix.cs.srv_block.cpu
CPU time (seconds) in process so far
exp.clf.unix.cs.srv_block.current
Currently active session ID
exp.clf.unix.cs.srv_block.cursors
Configured number of active cursors per session
exp.clf.unix.cs.srv_block.disconnect
 
exp.clf.unix.cs.srv_block.elog
 
exp.clf.unix.cs.srv_block.error_code
Current "major" error STATUS in the server
exp.clf.unix.cs.srv_block.event_mask
 
exp.clf.unix.cs.srv_block.facility
 
exp.clf.unix.cs.srv_block.format
 
exp.clf.unix.cs.srv_block.gca_name
The GCA listen address for this server
exp.clf.unix.cs.srv_block.hwm_active
 
exp.clf.unix.cs.srv_block.idle_time
 
exp.clf.unix.cs.srv_block.known_list
 
exp.clf.unix.cs.srv_block.mask
 
exp.clf.unix.cs.srv_block.max_active
Max number of active threads allowed
exp.clf.unix.cs.srv_block.max_sessions
Max number of threads allowed
exp.clf.unix.cs.srv_block.next_id
exp.clf.unix.cs.srv_block.num_active
Number of currently active threads
exp.clf.unix.cs.srv_block.num_sessions
Number of current sessions
exp.clf.unix.cs.srv_block.pid
OBSOLETE. Use exp.scf.scd.server.pid
exp.clf.unix.cs.srv_block.process
 
exp.clf.unix.cs.srv_block.q_per_sec
Number of quantums per second
exp.clf.unix.cs.srv_block.quantums
Number of elapsed quantum intervals
exp.clf.unix.cs.srv_block.read
 
exp.clf.unix.cs.srv_block.ready_mask
 
exp.clf.unix.cs.srv_block.reject
 
exp.clf.unix.cs.srv_block.saddr
 
exp.clf.unix.cs.srv_block.scballoc
 
exp.clf.unix.cs.srv_block.scbdealloc
 
exp.clf.unix.cs.srv_block.sem_stats.cs_smmp_count
Number of multi-processor naps
exp.clf.unix.cs.srv_block.sem_stats.cs_smms_count
 
exp.clf.unix.cs.srv_block.sem_stats.cs_smnonserver_count
Number of non-server naps
exp.clf.unix.cs.srv_block.sem_stats.cs_smsp_count
Number of single processor naps
exp.clf.unix.cs.srv_block.sem_stats.smc_count
Requests for cross-process semaphores
exp.clf.unix.cs.srv_block.sem_stats.smcl_count
Spins waiting for cross-process semaphores
exp.clf.unix.cs.srv_block.sem_stats.smcx_count
Collisions on cross-process semaphores
exp.clf.unix.cs.srv_block.sem_stats.smmsx_count
 
exp.clf.unix.cs.srv_block.sem_stats.smmx_count
 
exp.clf.unix.cs.srv_block.sem_stats.smmxx_count
 
exp.clf.unix.cs.srv_block.sem_stats.sms_count
Requests for shared semaphore
exp.clf.unix.cs.srv_block.sem_stats.smss_count
 
exp.clf.unix.cs.srv_block.sem_stats.smssx_count
 
exp.clf.unix.cs.srv_block.sem_stats.smsx_count
Collisions on shared versus exclusive
exp.clf.unix.cs.srv_block.sem_stats.smsxx_count
 
exp.clf.unix.cs.srv_block.sem_stats.smx_count
Requests for exclusive semaphore access
exp.clf.unix.cs.srv_block.sem_stats.smxx_count
Collisions exclusive versus exclusive
exp.clf.unix.cs.srv_block.shutdown
 
exp.clf.unix.cs.srv_block.startup
 
exp.clf.unix.cs.srv_block.state
Server internal state–look up using ima_server_internal_state_mask in IMA_STATUS_LOOKUP
exp.clf.unix.cs.srv_block.stk_count
 
exp.clf.unix.cs.srv_block.stk_list
 
exp.clf.unix.cs.srv_block.stksize
Configured stack size
exp.clf.unix.cs.srv_block.svcb
 
exp.clf.unix.cs.srv_block.to_list
List of SCB’s waiting for events that can time out
exp.clf.unix.cs.srv_block.toq_cnt
 
exp.clf.unix.cs.srv_block.user_sessions
How many non-CS threads there are
exp.clf.unix.cs.srv_block.wait_stats.bio_done
Total BIOs done
exp.clf.unix.cs.srv_block.wait_stats.bio_idle
BIOs while idle
exp.clf.unix.cs.srv_block.wait_stats.bio_time
Tick count in BIO wait
exp.clf.unix.cs.srv_block.wait_stats.bio_waits
Number of waits for BIO
exp.clf.unix.cs.srv_block.wait_stats.bior_done
 
exp.clf.unix.cs.srv_block.wait_stats.bior_time
 
exp.clf.unix.cs.srv_block.wait_stats.bior_waits
 
exp.clf.unix.cs.srv_block.wait_stats.biow_done
 
exp.clf.unix.cs.srv_block.wait_stats.biow_time
 
exp.clf.unix.cs.srv_block.wait_stats.biow_waits
 
exp.clf.unix.cs.srv_block.wait_stats.dio_done
Total DIOs completed
exp.clf.unix.cs.srv_block.wait_stats.dio_idle
Total DIOs completed while idle
exp.clf.unix.cs.srv_block.wait_stats.dio_time
Tick count in DIO wait
exp.clf.unix.cs.srv_block.wait_stats.dio_waits
Number of waits for DIO
exp.clf.unix.cs.srv_block.wait_stats.dior_done
 
exp.clf.unix.cs.srv_block.wait_stats.dior_time
 
exp.clf.unix.cs.srv_block.wait_stats.dior_waits
 
exp.clf.unix.cs.srv_block.wait_stats.diow_done
 
exp.clf.unix.cs.srv_block.wait_stats.diow_time
 
exp.clf.unix.cs.srv_block.wait_stats.diow_waits
 
exp.clf.unix.cs.srv_block.wait_stats.event_count
 
exp.clf.unix.cs.srv_block.wait_stats.event_wait
 
exp.clf.unix.cs.srv_block.wait_stats.lg_done
Total LG completions
exp.clf.unix.cs.srv_block.wait_stats.lg_idle
LG completions while idle
exp.clf.unix.cs.srv_block.wait_stats.lg_time
Tick count in LG wait
exp.clf.unix.cs.srv_block.wait_stats.lg_waits
Number of waits for LG
exp.clf.unix.cs.srv_block.wait_stats.lge_done
 
exp.clf.unix.cs.srv_block.wait_stats.lge_time
 
exp.clf.unix.cs.srv_block.wait_stats.lge_waits
 
exp.clf.unix.cs.srv_block.wait_stats.lio_done
 
exp.clf.unix.cs.srv_block.wait_stats.lio_time
 
exp.clf.unix.cs.srv_block.wait_stats.lio_waits
 
exp.clf.unix.cs.srv_block.wait_stats.lior_done
 
exp.clf.unix.cs.srv_block.wait_stats.lior_time
 
exp.clf.unix.cs.srv_block.wait_stats.lior_waits
 
exp.clf.unix.cs.srv_block.wait_stats.liow_done
 
exp.clf.unix.cs.srv_block.wait_stats.liow_time
 
exp.clf.unix.cs.srv_block.wait_stats.liow_waits
 
exp.clf.unix.cs.srv_block.wait_stats.lk_done
Total LK completions
exp.clf.unix.cs.srv_block.wait_stats.lk_idle
LK completions while idle
exp.clf.unix.cs.srv_block.wait_stats.lk_time
Tick count in LK wait
exp.clf.unix.cs.srv_block.wait_stats.lk_waits
Number of waits for LK
exp.clf.unix.cs.srv_block.wait_stats.lke_done
 
exp.clf.unix.cs.srv_block.wait_stats.lke_time
 
exp.clf.unix.cs.srv_block.wait_stats.lke_waits
 
exp.clf.unix.cs.srv_block.wait_stats.tm_done
 
exp.clf.unix.cs.srv_block.wait_stats.tm_idle
 
exp.clf.unix.cs.srv_block.wait_stats.tm_time
 
exp.clf.unix.cs.srv_block.wait_stats.tm_waits
 
exp.clf.unix.cs.srv_block.write
 
exp.clf.unix.cs.srv_block.wt_list
List of SCBs waiting for an event
exp.clf.unix.me.num.bytes_used
Number of bytes of memory (possible shared) requested by this server
exp.clf.unix.me.num.free_pages
Number of times the MEfree_pages routine was called to free memory pages back to the O/S
exp.clf.unix.me.num.get_pages
Number of times the MEget_pages routine was called to request memory from the O/S
exp.clf.unix.me.num.pages_used
Number of memory 'pages' in use by this server
exp.clf.unix.me.num.test_count
DEBUGGING CONTROL OBJECT–tests internal memory routines–DO NOT USE
exp.clf.unix.me.num.test_errs
DEBUGGING CONTROL OBJECT–causes internal memory test routines to be executed–DO NOT USE
exp.clf.unix.me.num.test_mod
DEBUGGING CONTROL OBJECT–tests internal memory routines–DO NOT USE
exp.dmf.dm0p.bm_bufcnt
Number of buffers (single page and group) in the cache
exp.dmf.dm0p.bm_check
The number of times that a cached page was checked to see if it was still valid
exp.dmf.dm0p.bm_clock
 
exp.dmf.dm0p.bm_dirty
Number of times a dirty page was unfixed (removed from cache)
exp.dmf.dm0p.bm_fcount
Number of free buffers
exp.dmf.dm0p.bm_fcwait
 
exp.dmf.dm0p.bm_fix
Number of fix calls (fetching a page into cache is "fix"ing it)
exp.dmf.dm0p.bm_flimit
Lower limit on free list size (used to control forced-write behavior)
exp.dmf.dm0p.bm_force
Number of 'forces'–intermediate writes before the end of transaction.
exp.dmf.dm0p.bm_fwait
Number of free buffer waiters
exp.dmf.dm0p.bm_gcnt
Number of group buffers
exp.dmf.dm0p.bm_gfcount
Number of free group buffers
exp.dmf.dm0p.bm_glcount
Number of fixed group buffers
exp.dmf.dm0p.bm_gmcount
Number of modified group buffers
exp.dmf.dm0p.bm_gpages
Number of pages in a group buffer
exp.dmf.dm0p.bm_greads
Number of group reads performed
exp.dmf.dm0p.bm_gsyncwr
 
exp.dmf.dm0p.bm_gwait
 
exp.dmf.dm0p.bm_gwrites
Number of group writes performed
exp.dmf.dm0p.bm_hit
Number of times that a requested page is found in cache
exp.dmf.dm0p.bm_hshcnt
Number of hash buckets
exp.dmf.dm0p.bm_iowait
Number of stalls for i/o completion
exp.dmf.dm0p.bm_lcount
Number of fixed buffers
exp.dmf.dm0p.bm_mcount
Number of modified buffers
exp.dmf.dm0p.bm_mlimit
Upper limit on modify list size
exp.dmf.dm0p.bm_mwait
Number of mutex waits
exp.dmf.dm0p.bm_pgsize
 
exp.dmf.dm0p.bm_reads
Number of single page reads
exp.dmf.dm0p.bm_reclaim
 
exp.dmf.dm0p.bm_refresh
Number of times that a cached page was found to be invalid and was refreshed
exp.dmf.dm0p.bm_replace
 
exp.dmf.dm0p.bm_sbufcnt
Number of single page buffers in the cache
exp.dmf.dm0p.bm_status
Buffer manager status: look up using ima_dmf_cache_status in IMA_STATUS_LOOKUP
exp.dmf.dm0p.bm_syncwr
 
exp.dmf.dm0p.bm_unfix
Number of unfix calls–the number of times a page was released from cache.
exp.dmf.dm0p.bm_wbend
Number of pages on modify list at which to stop asynchronous write behind threads
exp.dmf.dm0p.bm_wbstart
Number of pages on modify list at which to start asynchronous write behind threads
exp.dmf.dm0p.bm_writes
Number of writes
exp.dmf.dm0p.bmc_bmcwait
 
exp.dmf.dm0p.bmc_cpcheck
 
exp.dmf.dm0p.bmc_cpcount
 
exp.dmf.dm0p.bmc_cpindex
 
exp.dmf.dm0p.bmc_dbcsize
 
exp.dmf.dm0p.bmc_fcflush
 
exp.dmf.dm0p.bmc_lockreclaim
 
exp.dmf.dm0p.bmc_srv_count
 
exp.dmf.dm0p.bmc_status
 
exp.dmf.dm0p.bmc_tblcsize
 
exp.dmf.dm0p.lbm_check
Number of times that a page in the local buffer manager was checked to make sure it was still valid
exp.dmf.dm0p.lbm_dirty
Dirty pages unfixed
exp.dmf.dm0p.lbm_fcwait
 
exp.dmf.dm0p.lbm_fix
Number of fix calls
exp.dmf.dm0p.lbm_force
Immediate writes
exp.dmf.dm0p.lbm_fwait
Free buffer waiters
exp.dmf.dm0p.lbm_greads
Group reads
exp.dmf.dm0p.lbm_gsyncwr
 
exp.dmf.dm0p.lbm_gwait
 
exp.dmf.dm0p.lbm_gwrites
Group writes
exp.dmf.dm0p.lbm_hit
Page found is cache
exp.dmf.dm0p.lbm_iowait
Stall for I/O completion
exp.dmf.dm0p.lbm_mwait
Mutex waits
exp.dmf.dm0p.lbm_pgsize
 
exp.dmf.dm0p.lbm_reads
Reads
exp.dmf.dm0p.lbm_reclaim
 
exp.dmf.dm0p.lbm_refresh
Cached page was invalid
exp.dmf.dm0p.lbm_replace
 
exp.dmf.dm0p.lbm_syncwr
 
exp.dmf.dm0p.lbm_unfix
Unfix calls
exp.dmf.dm0p.lbm_wb_active
 
exp.dmf.dm0p.lbm_wb_flush
 
exp.dmf.dm0p.lbm_wb_flushed
 
exp.dmf.dm0p.lbm_wb_gflushed
 
exp.dmf.dm0p.lbm_wb_hwm
 
exp.dmf.dm0p.lbm_wb_threads
 
exp.dmf.dm0p.lbm_writes
Writes
exp.dmf.dm0p.lbmc_bmcwait
 
exp.dmf.dm0p.lbmc_fcflush
 
exp.dmf.dm0p.lbmc_lockreclaim
 
exp.dmf.dm0p.wb_active
 
exp.dmf.dm0p.wb_flush
 
exp.dmf.dm0p.wb_flushed
 
exp.dmf.dm0p.wb_gflushed
 
exp.dmf.dm0p.wb_hwm
 
exp.dmf.dm0p.wb_threads
 
exp.dmf.lg.ldb_buffer
Database information
exp.dmf.lg.ldb_d_first_la
String of first log record (for dump) associated with this DB
exp.dmf.lg.ldb_d_first_la.la_block
 
exp.dmf.lg.ldb_d_first_la.la_offset
Offset of first dump log record
exp.dmf.lg.ldb_d_first_la.la_sequence
Sequence of first dump log record
exp.dmf.lg.ldb_d_last_la
String of last log address (for dump) associated with this DB
exp.dmf.lg.ldb_d_last_la.la_block
 
exp.dmf.lg.ldb_d_last_la.la_offset
Offset of last dump log record
exp.dmf.lg.ldb_d_last_la.la_sequence
Sequence of last dump log record
exp.dmf.lg.ldb_database_id
Database ID for this database according to the iidatabase catalog in iidbdb
exp.dmf.lg.ldb_db_name
The name of this database
exp.dmf.lg.ldb_db_owner
The username of the DBA of this database
exp.dmf.lg.ldb_id.id_id
The id_id value for the database open in the logging system. Each database has a unique id_id value and a recycle id_instance count. For the ID displayed in logstat or ipm, use 65536 * id_id + id_instance.
exp.dmf.lg.ldb_id.id_instance
Instance value of this db_id_id–for recycling
exp.dmf.lg.ldb_j_first_la
String of first journal log record
exp.dmf.lg.ldb_j_first_la.la_block
 
exp.dmf.lg.ldb_j_first_la.la_offset
First journal log record offset
exp.dmf.lg.ldb_j_first_la.la_sequence
First journal log record sequence
exp.dmf.lg.ldb_j_last_la
String of last journal log record
exp.dmf.lg.ldb_j_last_la.la_block
 
exp.dmf.lg.ldb_j_last_la.la_offset
Last journal log record offset
exp.dmf.lg.ldb_j_last_la.la_sequence
Last journal log record sequence
exp.dmf.lg.ldb_l_buffer
Number of characters in the ldb_buffer
exp.dmf.lg.ldb_lpd_count
Number of LPD references to this database
exp.dmf.lg.ldb_lxb_count
Number of transactions
exp.dmf.lg.ldb_lxbo_count
Number of ongoing transactions for checkpoint
exp.dmf.lg.ldb_sback_lsn
String of start of backup log sequence number
exp.dmf.lg.ldb_sback_lsn_high
High part of start backup LSN
exp.dmf.lg.ldb_sback_lsn_low
Low part of start backup LSN
exp.dmf.lg.ldb_sbackup
String of start backup LGA
exp.dmf.lg.ldb_sbackup.la_block
 
exp.dmf.lg.ldb_sbackup.la_offset
Offset of start backup LGA
exp.dmf.lg.ldb_sbackup.la_sequence
Sequence of start backup LGA
exp.dmf.lg.ldb_stat.begin
Begins by database
exp.dmf.lg.ldb_stat.end
Ends by database
exp.dmf.lg.ldb_stat.force
Force by database
exp.dmf.lg.ldb_stat.read
Reads by database
exp.dmf.lg.ldb_stat.wait
Waits by database
exp.dmf.lg.ldb_stat.write
Writes by database
exp.dmf.lg.ldb_status
Status string for a database attached to the logging system.
exp.dmf.lg.ldb_status_num
Status as a bitmask–look up ima_db_status in IMA_STATUS_LOOKUP
exp.dmf.lg.lfb_active_log
String of the active log, either the primary or the dual
exp.dmf.lg.lfb_active_log_num
Active log number–look up ima_active_log_files in IMA_STATUS_LOOKUP
exp.dmf.lg.lfb_archive_end
 
exp.dmf.lg.lfb_archive_end.la_block
 
exp.dmf.lg.lfb_archive_end.la_offset
 
exp.dmf.lg.lfb_archive_end.la_sequence
 
exp.dmf.lg.lfb_archive_prevcp
 
exp.dmf.lg.lfb_archive_prevcp.la_block
 
exp.dmf.lg.lfb_archive_prevcp.la_offset
 
exp.dmf.lg.lfb_archive_prevcp.la_sequence
 
exp.dmf.lg.lfb_archive_start
 
exp.dmf.lg.lfb_archive_start.la_block
 
exp.dmf.lg.lfb_archive_start.la_offset
 
exp.dmf.lg.lfb_archive_start.la_sequence
 
exp.dmf.lg.lfb_buf_cnt
Count of log buffers
exp.dmf.lg.lfb_channel_blk
Last block written/read to/from the file associated with the main channel
exp.dmf.lg.lfb_dual_channel_blk
Last block written/read to/from the file associated with the dual channel
exp.dmf.lg.lfb_forced_lga
String of forced LGA
exp.dmf.lg.lfb_forced_lga.la_block
 
exp.dmf.lg.lfb_forced_lga.la_offset
Offset of forced LGA
exp.dmf.lg.lfb_forced_lga.la_sequence
Sequence of forced LGA
exp.dmf.lg.lfb_forced_lsn
High part of forced LSN
exp.dmf.lg.lfb_forced_lsn_high
 
exp.dmf.lg.lfb_forced_lsn_low
Low part of force LSN
exp.dmf.lg.lfb_hdr_lgh_active_logs
Active Log files–look up as ima_active_log_files in IMA_STATUS_LOOKUP
exp.dmf.lg.lfb_hdr_lgh_begin
String of log address of last begin in the log file
exp.dmf.lg.lfb_hdr_lgh_begin_blk
 
exp.dmf.lg.lfb_hdr_lgh_begin_off
Offset of last begin
exp.dmf.lg.lfb_hdr_lgh_begin_seq
Sequence of last begin
exp.dmf.lg.lfb_hdr_lgh_checksum
Checksum of file header
exp.dmf.lg.lfb_hdr_lgh_count
Number of log pages
exp.dmf.lg.lfb_hdr_lgh_cp
String of log address of last consistency point
exp.dmf.lg.lfb_hdr_lgh_cp_blk
 
exp.dmf.lg.lfb_hdr_lgh_cp_off
Offset of last CP
exp.dmf.lg.lfb_hdr_lgh_cp_seq
Sequence of last CP
exp.dmf.lg.lfb_hdr_lgh_cpcnt
Maximum CP interval for invoking archiver
exp.dmf.lg.lfb_hdr_lgh_end
String of log address of last end of file
exp.dmf.lg.lfb_hdr_lgh_end_blk
 
exp.dmf.lg.lfb_hdr_lgh_end_off
Offset of last end of file
exp.dmf.lg.lfb_hdr_lgh_end_seq
Sequence of last end of file
exp.dmf.lg.lfb_hdr_lgh_l_abort
Force abort limit
exp.dmf.lg.lfb_hdr_lgh_l_cp
Expected next CP
exp.dmf.lg.lfb_hdr_lgh_l_logfull
Log Full limit
exp.dmf.lg.lfb_hdr_lgh_last_lsn
 
exp.dmf.lg.lfb_hdr_lgh_last_lsn_lsn_high
 
exp.dmf.lg.lfb_hdr_lgh_last_lsn_lsn_low
 
exp.dmf.lg.lfb_hdr_lgh_percentage_logfull
 
exp.dmf.lg.lfb_hdr_lgh_size
Size of a log page
exp.dmf.lg.lfb_hdr_lgh_status
String of log header status
exp.dmf.lg.lfb_hdr_lgh_status_num
Log Header Status–look up as ima_log_header_status in IMA_STATUS_LOOKUP
exp.dmf.lg.lfb_hdr_lgh_tran_high
High part of last xact id used
exp.dmf.lg.lfb_hdr_lgh_tran_id
String of last xact id used
exp.dmf.lg.lfb_hdr_lgh_tran_low
Low part of last xact id used
exp.dmf.lg.lfb_hdr_lgh_version
Logging system version–look up as ima_log_version in IMA_STATUS_LOOKUP
exp.dmf.lg.lfb_reserved_space
Amount of logfile space reserved
exp.dmf.lg.lfb_stat_dual_readio
Number of read from the II_DUAL_LOG
exp.dmf.lg.lfb_stat_dual_writeio
Number of write complete to the II_LOG_FILE
exp.dmf.lg.lfb_stat_end
Transactions ended on this logging system
exp.dmf.lg.lfb_stat_force
Log forces
exp.dmf.lg.lfb_stat_kbytes
Amount of (512 byte) blocks written
exp.dmf.lg.lfb_stat_log_readio
Number of read from the II_LOG_FILE
exp.dmf.lg.lfb_stat_log_writeio
Number of write complete to the II_LOG_FILE
exp.dmf.lg.lfb_stat_split
Number of log splits
exp.dmf.lg.lfb_stat_wait
Log waits
exp.dmf.lg.lfb_stat_write
Log writes
exp.dmf.lg.lfb_stat_writeio
Actual write I/Os to this log
exp.dmf.lg.lfb_status
String of status of this log file
exp.dmf.lg.lfb_status_num
Logging system status–look up as ima_log_file_status in IMA_STATUS_LOOKUP
exp.dmf.lg.lgd_check_stall
Point at which checking for various stall and logfull conditions (smallest of lgh_l_logfull, lgh_l_abort, lgd_cpstall) should begin
exp.dmf.lg.lgd_cnodeid
Node ID number for this local node. If not a cluster, this number will be 0.
exp.dmf.lg.lgd_cpstall
Maximum log file can grow to while executing a consistency point
exp.dmf.lg.lgd_csp_pid
The Process ID of the CSP
exp.dmf.lg.lgd_gcmt_numticks
Number of piggy-back write "ticks" after which a buffer has waited long enough and should be forced to disk.
exp.dmf.lg.lgd_gcmt_threshold
Threshold value at which group commit should be performed. As soon as there are more active protected transactions than this, group commit will begin.
exp.dmf.lg.lgd_ldb_inuse
 
exp.dmf.lg.lgd_ldbb_count
 
exp.dmf.lg.lgd_ldbb_size
 
exp.dmf.lg.lgd_lfbb_count
 
exp.dmf.lg.lgd_lfbb_size
 
exp.dmf.lg.lgd_lpb_inuse
Number of LPBs in use
exp.dmf.lg.lgd_lpbb_count
 
exp.dmf.lg.lgd_lpbb_size
 
exp.dmf.lg.lgd_lpd_inuse
Number of LPDs in use
exp.dmf.lg.lgd_lpdb_count
 
exp.dmf.lg.lgd_lpdb_size
 
exp.dmf.lg.lgd_lxb_inuse
Number of LXBs in use
exp.dmf.lg.lgd_lxbb_count
 
exp.dmf.lg.lgd_lxbb_size
 
exp.dmf.lg.lgd_n_logwriters
Total number of available logwriter threads
exp.dmf.lg.lgd_no_bcp
CP in progress; do not start new one
exp.dmf.lg.lgd_protect_count
Number of protect transactions
exp.dmf.lg.lgd_stat.add
Log add calls
exp.dmf.lg.lgd_stat.bcp_stall_wait
Stalls caused by BCP writes
exp.dmf.lg.lgd_stat.begin
Log transaction begins
exp.dmf.lg.lgd_stat.dual_readio
Number of read from the II_DUAL_LOG
exp.dmf.lg.lgd_stat.dual_writeio
Number of write complete to the II_DUAL_LOG
exp.dmf.lg.lgd_stat.end
Log transaction end
exp.dmf.lg.lgd_stat.force
Log force call
exp.dmf.lg.lgd_stat.free_wait
Waits for free log buffer
exp.dmf.lg.lgd_stat.group_count
 
exp.dmf.lg.lgd_stat.group_force
Number of group forces
exp.dmf.lg.lgd_stat.inconsist_db
Number of inconsistent databases occurred
exp.dmf.lg.lgd_stat.kbytes
Number of (512 byte) blocks written to the log file.
exp.dmf.lg.lgd_stat.log_readio
Number of read from the II_LOG_FILE
exp.dmf.lg.lgd_stat.log_writeio
Number of write complete to the II_LOG_FILE
exp.dmf.lg.lgd_stat.pgyback_check
Number of pgyback_write checks
exp.dmf.lg.lgd_stat.pgyback_write
Writes initiated by piggy-back
exp.dmf.lg.lgd_stat.readio
Log read I/Os
exp.dmf.lg.lgd_stat.remove
Log remove calls
exp.dmf.lg.lgd_stat.split
Log splits
exp.dmf.lg.lgd_stat.stall_wait
Number of times stalled in LGwrite
exp.dmf.lg.lgd_stat.wait
Log waits
exp.dmf.lg.lgd_stat.write
Log write calls
exp.dmf.lg.lgd_stat.writeio
Log write I/Os
exp.dmf.lg.lgd_status
String of logging system status
exp.dmf.lg.lgd_status_num
Integer of log status bits: look up ima_logging_system_status in IMA_STATUS_LOOKUP
exp.dmf.lg.lpb_bufmgr_id
ID of process' Buffer Manager
exp.dmf.lg.lpb_cond
Fast commit server condition look up ima_fcserver_cond in IMA_STATUS_LOOKUP
exp.dmf.lg.lpb_force_abort_sid
Session ID of this process' force abort special thread
exp.dmf.lg.lpb_gcmt_asleep
Indicator to track the state of the group commit thread 0–performing group commit;non zero–suspending
exp.dmf.lg.lpb_gcmt_lxb
 
exp.dmf.lg.lpb_gcmt_sid
Session ID of this process' group commit special thread
exp.dmf.lg.lpb_id.id_id
The unique identifier associated with a process in the logging system. Each process has a unique id_id and a recycle id_instance counter. To get the id displayed in logstat, use (65536 * id_id) + id_instance
exp.dmf.lg.lpb_id.id_instance
Recycle counter for the id_id of this log process
exp.dmf.lg.lpb_lpd_count
Count of open databases
exp.dmf.lg.lpb_pid
Process id of the process attached to the logging system as a decimal number
exp.dmf.lg.lpb_stat.begin
Log begin per process
exp.dmf.lg.lpb_stat.end
Log end per process
exp.dmf.lg.lpb_stat.force
Log force per process
exp.dmf.lg.lpb_stat.readio
Log read I/Os per process
exp.dmf.lg.lpb_stat.wait
Log waits
exp.dmf.lg.lpb_stat.write
Log writes per process
exp.dmf.lg.lpb_status
String representing the status of the process
exp.dmf.lg.lpb_status_num
Status bits for this process–look up ima_process_status in IMA_STATUS_LOOKUP
exp.dmf.lg.lxb_cp_lga
String of CP interval for this transaction
exp.dmf.lg.lxb_cp_lga.la_block
 
exp.dmf.lg.lxb_cp_lga.la_offset
Offset of CP interval for this transaction
exp.dmf.lg.lxb_cp_lga.la_sequence
Sequence of CP interval for this transaction
exp.dmf.lg.lxb_db_id_id
Id_id of the database associated with this transaction
exp.dmf.lg.lxb_db_name
Name of the database for this transaction
exp.dmf.lg.lxb_db_owner
DBA of the database associated with this transaction
exp.dmf.lg.lxb_dis_tran_id_hexdump
String of hexdump of the tran id, for use by XA_RECOVER
exp.dmf.lg.lxb_first_lga
String representing the first log address associated with this transaction
exp.dmf.lg.lxb_first_lga.la_block
 
exp.dmf.lg.lxb_first_lga.la_offset
Offset of begin record
exp.dmf.lg.lxb_first_lga.la_sequence
Sequence of begin record
exp.dmf.lg.lxb_id.id_id
The unique id_id value for this transaction. Each transaction has a unique id_id value and a recycle id_instance counter. To get the value displayed in ipm and logstat, use 65536 * id_id + id_instance
exp.dmf.lg.lxb_id.id_instance
Sequence number for the id_id value of this transaction
exp.dmf.lg.lxb_is_prepared
Y if this transaction is prepared; otherwise N
exp.dmf.lg.lxb_is_xa_dis_tran_id
String of XA transaction ID, if relevant
exp.dmf.lg.lxb_last_lga
String representing the last log address associated with this transaction
exp.dmf.lg.lxb_last_lga.la_block
 
exp.dmf.lg.lxb_last_lga.la_offset
Offset of last log record
exp.dmf.lg.lxb_last_lga.la_sequence
Sequence of last log record
exp.dmf.lg.lxb_last_lsn
String of last log record
exp.dmf.lg.lxb_last_lsn_high
High part of last log recore LSN
exp.dmf.lg.lxb_last_lsn_low
Low part of last log record LSN
exp.dmf.lg.lxb_pid
Process ID of the process (server) which started this transaction. The value is returned as a decimal integer.
exp.dmf.lg.lxb_pr_id_id
ID_id of the process (server) which 'owns' this transaction.
exp.dmf.lg.lxb_reserved_space
Logfile space reserved by xact
exp.dmf.lg.lxb_sequence
Sequence number
exp.dmf.lg.lxb_sid
The session id in the server which owns the transaction
exp.dmf.lg.lxb_stat.force
Log force by transaction
exp.dmf.lg.lxb_stat.split
Log splits by transaction
exp.dmf.lg.lxb_stat.wait
Log wait by transaction
exp.dmf.lg.lxb_stat.write
Log writes by transaction
exp.dmf.lg.lxb_status
Status of this transaction
exp.dmf.lg.lxb_status_num
Status integer–look up ima_tx_status in IMA_STATUS_LOOKUP
exp.dmf.lg.lxb_tran_id
The transaction ID for this transaction
exp.dmf.lg.lxb_tran_id.db_high_tran
'High' part of the transaction ID
exp.dmf.lg.lxb_tran_id.db_low_tran
'Low' part of the transaction ID
exp.dmf.lg.lxb_user_name
Name of the user associated with this transaction
exp.dmf.lg.lxb_wait_reason
String representation of the reason that this transaction is waiting
exp.dmf.lg.lxb_wait_reason_num
Wait reason–look up ima_tx_wait_reason in IMA_STATUS_LOOKUP
exp.dmf.lk.lkb_attribute
String of attributes for a lock
exp.dmf.lk.lkb_attribute_num
Lock attribute–look up ima_lk_attribute in IMA_STATUS_LOOKUP
exp.dmf.lk.lkb_count
Count of physical requests
exp.dmf.lk.lkb_cx_req.cx_lock_id
 
exp.dmf.lk.lkb_grant_mode
String representing the granted mode of this lock (S, IX, and so on)
exp.dmf.lk.lkb_grant_mode_num
Grant mode–look up ima_lk_mode in IMA_STATUS_LOOKUP
exp.dmf.lk.lkb_id.id_id
The unique id_id of a lock block. Each locked resource has a unique lock associated with it–these locks are held on a lock list. Each lock block has a unique id_id value and a recycle id_instance value
exp.dmf.lk.lkb_llb_id_id
The id_id of the locklist to which this lock belongs
exp.dmf.lk.lkb_request_mode
String representing the mode in which this lock has been requested
exp.dmf.lk.lkb_request_mode_num
Request mode–look up ima_lk_mode in IMA_STATUS_LOOKUP
exp.dmf.lk.lkb_rsb_id_id
The id_id of the resource with which this lock is associated
exp.dmf.lk.lkb_state
The state of the lock as a string (granted, waiting, and so on)
exp.dmf.lk.lkb_state_num
Lock state number–look up ima_lk_state in IMA_STATUS_LOOKUP
exp.dmf.lk.lkd_csid
The cluster ID of the current node
exp.dmf.lk.lkd_csp_id
The process ID of the CSP
exp.dmf.lk.lkd_lbk_count
Allocated LBK entries
exp.dmf.lk.lkd_lbk_size
Maximum LBK entries
exp.dmf.lk.lkd_lkb_inuse
Count of LKBs
exp.dmf.lk.lkd_lkh_size
Active LLB entries
exp.dmf.lk.lkd_llb_inuse
 
exp.dmf.lk.lkd_lock_stall
Type of lock stall–look up ima_lock_stall_type in IMA_STATUS_LOOKUP
exp.dmf.lk.lkd_max_lkb
Default maximum LKB per lock list
exp.dmf.lk.lkd_next_llbname
 
exp.dmf.lk.lkd_node_fail
Cluster node failure indication
exp.dmf.lk.lkd_rbk_count
Allocated RBK entries
exp.dmf.lk.lkd_rbk_size
Maximum RBK entries
exp.dmf.lk.lkd_rsb_inuse
Count of RSBs
exp.dmf.lk.lkd_rsh_size
Size of RSB hash table
exp.dmf.lk.lkd_sbk_count
Allocated SBK entries
exp.dmf.lk.lkd_sbk_size
Maximum SBK entries
exp.dmf.lk.lkd_stat.allocate_cb
Number of allocate_cb calls
exp.dmf.lk.lkd_stat.asynch_complete
Number of enq_complete completions
exp.dmf.lk.lkd_stat.cancel
Number of timeout cancels
exp.dmf.lk.lkd_stat.cnt_gdlck_call
Number of continue deadlock search calls
exp.dmf.lk.lkd_stat.cnt_gdlck_sent
Number of continue deadlock message sent
exp.dmf.lk.lkd_stat.convert
Number of explicit convert requests
exp.dmf.lk.lkd_stat.convert_deadlock
Number of converts that deadlocked
exp.dmf.lk.lkd_stat.convert_search
Number of convert deadlock searches
exp.dmf.lk.lkd_stat.convert_wait
Number of converts that waited
exp.dmf.lk.lkd_stat.create_list
Number of create list calls
exp.dmf.lk.lkd_stat.csp_msgs_rcvd
Number of messages received by CSP so far
exp.dmf.lk.lkd_stat.csp_wakeups_sent
Number of LK_wakeup calls made by CSP
exp.dmf.lk.lkd_stat.deadlock
Number of requests that deadlocked
exp.dmf.lk.lkd_stat.deadlock_search
Number of deadlock searches performed
exp.dmf.lk.lkd_stat.deallocate_cb
Number of deallocate_cb calls
exp.dmf.lk.lkd_stat.deq
Number of deq requested
exp.dmf.lk.lkd_stat.dlock_locks_examined
Number of LKBs seen by deadlock
exp.dmf.lk.lkd_stat.enq
Number of enq requested
exp.dmf.lk.lkd_stat.gdeadlock
Number of global deadlock detected
exp.dmf.lk.lkd_stat.gdlck_call
Number of continue deadlock search calls
exp.dmf.lk.lkd_stat.gdlck_grant
Number of global locks grant before the the global deadlock search
exp.dmf.lk.lkd_stat.gdlck_search
Number of pending global deadlock search requests
exp.dmf.lk.lkd_stat.gdlck_sent
Number of global deadlock messages sent
exp.dmf.lk.lkd_stat.lbk_highwater
Highwater mark of LBK allocation
exp.dmf.lk.lkd_stat.lkb_highwater
 
exp.dmf.lk.lkd_stat.llb_highwater
Highwater mark of LLB usage
exp.dmf.lk.lkd_stat.max_lcl_dlk_srch
Max length of a deadlocksearch
exp.dmf.lk.lkd_stat.max_lock_chain_len
Max length of a LKB chain search
exp.dmf.lk.lkd_stat.max_locks_per_txn
 
exp.dmf.lk.lkd_stat.max_rsrc_chain_len
Max length of a RSB chain search
exp.dmf.lk.lkd_stat.rbk_highwater
Highwater mark of RBK allocation
exp.dmf.lk.lkd_stat.release
Number of released physical locks
exp.dmf.lk.lkd_stat.release_all
Number of release lists
exp.dmf.lk.lkd_stat.release_partial
Number of partial releases
exp.dmf.lk.lkd_stat.request_convert
Number of request with implied conversions
exp.dmf.lk.lkd_stat.request_new
Number of request new lock calls
exp.dmf.lk.lkd_stat.rsb_highwater
Highwater mark of RSB usage
exp.dmf.lk.lkd_stat.sbk_highwater
Highwater mark of SBK allocation
exp.dmf.lk.lkd_stat.sent_all
Number of sent all deadlock search request
exp.dmf.lk.lkd_stat.synch_complete
Number of SS$_SYNCH completions
exp.dmf.lk.lkd_stat.totl_gdlck_search
Number of global deadlock search requests
exp.dmf.lk.lkd_stat.wait
Number of requests that waited
exp.dmf.lk.lkd_stat.walk_wait_for
 
exp.dmf.lk.lkd_status
String of global locking system status.
exp.dmf.lk.lkd_status_num
Bitmask of global locking system status: look up ima_locking_system_status in IMA_STATUS_LOOKUP
exp.dmf.lk.llb_connect_count
Number of LLBs that reference this list through llb_shared_llb–used only if status LLB_SHARED
exp.dmf.lk.llb_event.type_high
 
exp.dmf.lk.llb_event.type_low
 
exp.dmf.lk.llb_event.value
 
exp.dmf.lk.llb_evflags
Zero or LK_CROSS_PROCESS_EVENT(1)
exp.dmf.lk.llb_ew_stamp
 
exp.dmf.lk.llb_id.id_id
Index for the lock list block–each locklist has an ID_ID (which is unique) and an ID_INSTANCE (which is a cycle count)–to get the value displayed in lockstat, use (65536 * id_id) + id_instance
exp.dmf.lk.llb_lkb_count
The count of locks on this list (each lock is known as a lock block or blk)
exp.dmf.lk.llb_llkb_count
The count of logical locks on this list
exp.dmf.lk.llb_max_lkb
The maximum locks permitted on this locklist
exp.dmf.lk.llb_name0
High byte of an internal unique lock list identifier (used in clusters)
exp.dmf.lk.llb_name1
Low byte of internal lock list identifier used in clusters
exp.dmf.lk.llb_pid
PID of server owning this lock list as a decimal number
exp.dmf.lk.llb_related_count
The count of related LLBs
exp.dmf.lk.llb_related_llb
The related lock list, as a pointer
exp.dmf.lk.llb_related_llb_id_id
The id_id of the related lock list
exp.dmf.lk.llb_search_count
Deadlock searches on this list
exp.dmf.lk.llb_sid
Session ID of the session which owns this locklist (not unique in the installation, but only in a server)
exp.dmf.lk.llb_stamp
The stamp of the current lock request
exp.dmf.lk.llb_status
String showing the status of the lock list
exp.dmf.lk.llb_status_num
Bitmask of locklist status–look up ima_lklist_status in IMA_STATUS_LOOKUP
exp.dmf.lk.llb_tick
The current clock tick when making the global deadlock search request
exp.dmf.lk.llb_wait_id_id
The id_id of the locklist which holds the lock that the owner of this locklist is waiting for. This object only has a value when the current locklist is blocked.
exp.dmf.lk.rsb_convert_mode
String of the convert mode for the resource
exp.dmf.lk.rsb_convert_mode_num
Integer value of the convert mode for the resource–look up ima_lk_mode in IMA_STATUS_LOOKUP
exp.dmf.lk.rsb_grant_mode
A string representing the mode of a lock granted on this resource.
exp.dmf.lk.rsb_grant_mode_num
Integer value of the granted mode for the resource–look up ima_lk_mode in IMA_STATUS_LOOKUP
exp.dmf.lk.rsb_id.id_id
The id_id of a resource being locked. Each resource has a unique id_id value and a recycle id_instance counter.
exp.dmf.lk.rsb_invalid
Zero if valid, non-zero if invalid
exp.dmf.lk.rsb_name
A string representing the name/key of the resource
exp.dmf.lk.rsb_name0
The type of the resource/lock combination–look up the value for the ima_lk_type column in the IMA_STATUS_LOOKUP table
exp.dmf.lk.rsb_name1
ID of the database associated with this resource–look up the value in the iidatabase catalog in the iidbdb
exp.dmf.lk.rsb_name2
Reltid of the table associated with this resource–look up in the iirelation catalog of the relevant database
exp.dmf.lk.rsb_name3
Reltidx of the table/index associated with this resource–look up in the iirelation catalog of the appropriate database
exp.dmf.lk.rsb_name4
Page number (if appropriate) of the resource
exp.dmf.lk.rsb_name5
More RSB information depending on RSB type
exp.dmf.lk.rsb_name6
More RSB information depending on RSB type
exp.dmf.lk.rsb_value0
Lower part of value associated with the resource
exp.dmf.lk.rsb_value1
High part of the value associated with the resource
exp.dmf.perf.tmperf_collect
Control object: Any write causes a snapshot of resource use to be taken
exp.dmf.perf.tmperf_cpu.TM_msecs
Milliseconds of CPU used in the server
exp.dmf.perf.tmperf_cpu.TM_secs
Seconds of CPU time used in the server
exp.dmf.perf.tmperf_dio
DIO count for the server
exp.dmf.perf.tmperf_idrss
Current resident set size for the server
exp.dmf.perf.tmperf_majflt
Major faults for the server
exp.dmf.perf.tmperf_maxrss
Max resident set size for the server
exp.dmf.perf.tmperf_minflt
Minor faults for the server
exp.dmf.perf.tmperf_msgrcv
Messages received by the server
exp.dmf.perf.tmperf_msgsnd
Messages sent by the server
exp.dmf.perf.tmperf_msgtotal
Total messages sent/received by the server
exp.dmf.perf.tmperf_nivcsw
Involuntary context switches (time sliced out)
exp.dmf.perf.tmperf_nsignals
Number of signals received
exp.dmf.perf.tmperf_nswap
Number of swaps
exp.dmf.perf.tmperf_nvcsw
Number of voluntary context switches
exp.dmf.perf.tmperf_reads
Number of reads
exp.dmf.perf.tmperf_stime.TM_msecs
Milliseconds of system time
exp.dmf.perf.tmperf_stime.TM_secs
Seconds of system time
exp.dmf.perf.tmperf_utime.TM_msecs
Milliseconds of user time
exp.dmf.perf.tmperf_utime.TM_secs
Seconds of user time
exp.dmf.perf.tmperf_writes
Number of writes
exp.gcf.gca.assoc
Index of GCA association for the process, starting from 1–each connection from a client program is known as an association
exp.gcf.gca.assoc.client_id
 
exp.gcf.gca.assoc.flags
Flags for the association
exp.gcf.gca.assoc.inbound
 
exp.gcf.gca.assoc.partner_id
 
exp.gcf.gca.assoc.partner_protocol
Integer value of the protocol used for the connection to the local partner
exp.gcf.gca.assoc.session_protocol
Integer value of the protocol for this connected session
exp.gcf.gca.assoc.userid
User ID associated with this association
exp.gcf.gca.assoc_count
 
exp.gcf.gca.client
 
exp.gcf.gca.client.api_version
 
exp.gcf.gca.client.flags
 
exp.gcf.gca.client.listen_address
 
exp.gcf.gca.client.local_protocol
 
exp.gcf.gca.client.server_class
 
exp.gcf.gca.data_in
 
exp.gcf.gca.data_out
 
exp.gcf.gca.install_id
 
exp.gcf.gca.msgs_in
 
exp.gcf.gca.msgs_out
 
exp.gcf.gca.trace_level
Current GCA trace level
exp.gcf.gca.trace_log
 
exp.gcf.gcc.conn
 
exp.gcf.gcc.conn.al_flags
 
exp.gcf.gcc.conn.al_proto_lvl
 
exp.gcf.gcc.conn.flags
 
exp.gcf.gcc.conn.gca_assoc_id
 
exp.gcf.gcc.conn.inbound
 
exp.gcf.gcc.conn.lcl_addr.node
 
exp.gcf.gcc.conn.lcl_addr.port
 
exp.gcf.gcc.conn.lcl_addr.protocol
 
exp.gcf.gcc.conn.pl_flags
 
exp.gcf.gcc.conn.pl_proto_lvl
 
exp.gcf.gcc.conn.rmt_addr.node
 
exp.gcf.gcc.conn.rmt_addr.port
 
exp.gcf.gcc.conn.rmt_addr.protocol
 
exp.gcf.gcc.conn.sl_flags
 
exp.gcf.gcc.conn.sl_proto_lvl
 
exp.gcf.gcc.conn.target
 
exp.gcf.gcc.conn.tl_flags
 
exp.gcf.gcc.conn.tl_lcl_id
 
exp.gcf.gcc.conn.tl_proto_lvl
 
exp.gcf.gcc.conn.tl_rmt_id
 
exp.gcf.gcc.conn.trg_addr.node
 
exp.gcf.gcc.conn.trg_addr.port
 
exp.gcf.gcc.conn.trg_addr.protocol
 
exp.gcf.gcc.conn.userid
 
exp.gcf.gcc.conn_count
 
exp.gcf.gcc.data_in
 
exp.gcf.gcc.data_out
 
exp.gcf.gcc.ib_conn_count
 
exp.gcf.gcc.ib_encrypt_mech
 
exp.gcf.gcc.ib_encrypt_mode
 
exp.gcf.gcc.ib_max
 
exp.gcf.gcc.msgs_in
 
exp.gcf.gcc.msgs_out
 
exp.gcf.gcc.ob_conn_count
 
exp.gcf.gcc.ob_encrypt_mech
 
exp.gcf.gcc.ob_encrypt_mode
 
exp.gcf.gcc.ob_max
 
exp.gcf.gcc.pl_proto_lvl
 
exp.gcf.gcc.protocol
 
exp.gcf.gcc.protocol.addr
 
exp.gcf.gcc.protocol.host
 
exp.gcf.gcc.protocol.port
 
exp.gcf.gcc.registry
 
exp.gcf.gcc.registry.addr
 
exp.gcf.gcc.registry.host
 
exp.gcf.gcc.registry.port
 
exp.gcf.gcc.registry_mode
 
exp.gcf.gcc.trace_level
 
exp.gcf.gcn.bedcheck_interval
 
exp.gcf.gcn.cache_modified
 
exp.gcf.gcn.compress_point
 
exp.gcf.gcn.default_class
 
exp.gcf.gcn.expire_interval
 
exp.gcf.gcn.hostname
 
exp.gcf.gcn.installation_id
 
exp.gcf.gcn.local_vnode
 
exp.gcf.gcn.remote_mechanism
 
exp.gcf.gcn.remote_vnode
 
exp.gcf.gcn.server.address
The GCA address of a registered server process, as seen by the name server (iigcn)
exp.gcf.gcn.server.class
The 'class' of the server registered with the name server (iigcn)–this corresponds to the server class parameter specified in CBF
exp.gcf.gcn.server.entry
 
exp.gcf.gcn.server.flags
 
exp.gcf.gcn.server.object
The 'dblist' of the DBMS server registered with the name server–relevant for DBMS servers only
exp.gcf.gcn.ticket_cache_size
 
exp.gcf.gcn.ticket_expire
 
exp.gcf.gcn.ticket_lcl_cache_miss
 
exp.gcf.gcn.ticket_lcl_created
 
exp.gcf.gcn.ticket_lcl_expired
 
exp.gcf.gcn.ticket_lcl_used
 
exp.gcf.gcn.ticket_rmt_cache_miss
 
exp.gcf.gcn.ticket_rmt_created
 
exp.gcf.gcn.ticket_rmt_expired
 
exp.gcf.gcn.ticket_rmt_used
 
exp.gcf.gcn.timeout
 
exp.gcf.gcn.trace_level
 
exp.gcf.gcs.default_mechanism
 
exp.gcf.gcs.installation_mechanism
 
exp.gcf.gcs.mechanism
 
exp.gcf.gcs.mechanism.capabilities
 
exp.gcf.gcs.mechanism.encrypt_level
 
exp.gcf.gcs.mechanism.name
 
exp.gcf.gcs.mechanism.overhead
 
exp.gcf.gcs.mechanism.status
 
exp.gcf.gcs.mechanism.version
 
exp.gcf.gcs.trace_level
 
exp.gcf.gcs.version
 
exp.glf.mo.mem.bytes
 
exp.glf.mo.mem.limit
 
exp.glf.mo.meta.class
The textual class of the classid
exp.glf.mo.meta.classid
The classid key
exp.glf.mo.meta.index
The classid that indexes this classid, so this can be a column in the table
exp.glf.mo.meta.offset
The offset to hand to methods
exp.glf.mo.meta.oid
The ASN.1 OID to assign to this classid
exp.glf.mo.meta.perms
MO permissions for the object
exp.glf.mo.meta.size
MO size of the object
exp.glf.mo.monitors.classid
 
exp.glf.mo.monitors.mon_block
 
exp.glf.mo.monitors.mon_data
 
exp.glf.mo.monitors.mon_id
 
exp.glf.mo.monitors.monitor
 
exp.glf.mo.monitors.qual_regexp
 
exp.glf.mo.num.alloc
 
exp.glf.mo.num.attach
 
exp.glf.mo.num.classdef
 
exp.glf.mo.num.del_monitor
 
exp.glf.mo.num.detach
 
exp.glf.mo.num.free
 
exp.glf.mo.num.get
 
exp.glf.mo.num.getnext
 
exp.glf.mo.num.mutex
 
exp.glf.mo.num.set_monitor
 
exp.glf.mo.num.tell_monitor
 
exp.glf.mo.num.unmutex
 
exp.glf.mo.oid_map.file_name
 
exp.glf.mo.oid_map.file_time
 
exp.glf.mo.sptrees.enqcmps
 
exp.glf.mo.sptrees.enqs
 
exp.glf.mo.sptrees.lkpcmps
 
exp.glf.mo.sptrees.lookups
 
exp.glf.mo.sptrees.name
 
exp.glf.mo.sptrees.prevnexts
 
exp.glf.mo.sptrees.splayloops
 
exp.glf.mo.sptrees.splays
 
exp.glf.mo.strings.bytes
 
exp.glf.mo.strings.defined
 
exp.glf.mo.strings.deleted
 
exp.glf.mo.strings.freed
 
exp.glf.mo.strings.limit
 
exp.glf.mo.strings.refs
 
exp.glf.mo.strings.vals
 
exp.gwf.gwm.glb.aborts
 
exp.gwf.gwm.glb.begins
 
exp.gwf.gwm.glb.closes
 
exp.gwf.gwm.glb.cnd.connections
 
exp.gwf.gwm.glb.commits
 
exp.gwf.gwm.glb.connects.active
 
exp.gwf.gwm.glb.connects.max
 
exp.gwf.gwm.glb.connects.place.max
 
exp.gwf.gwm.glb.def_domain
 
exp.gwf.gwm.glb.def_vnode
 
exp.gwf.gwm.glb.deletes
 
exp.gwf.gwm.glb.errors
 
exp.gwf.gwm.glb.gcm.errs
 
exp.gwf.gwm.glb.gcm.readahead
 
exp.gwf.gwm.glb.gcm.reissues
 
exp.gwf.gwm.glb.gcm.sends
 
exp.gwf.gwm.glb.gcm.usecache
 
exp.gwf.gwm.glb.gcn_checks
 
exp.gwf.gwm.glb.gcn_queries
 
exp.gwf.gwm.glb.gets
 
exp.gwf.gwm.glb.idxfs
 
exp.gwf.gwm.glb.infos
 
exp.gwf.gwm.glb.inits
 
exp.gwf.gwm.glb.num.rop_calls
 
exp.gwf.gwm.glb.num.rop_hits
 
exp.gwf.gwm.glb.num.rop_misses
 
exp.gwf.gwm.glb.num.rreq_calls
 
exp.gwf.gwm.glb.num.rreq_hits
 
exp.gwf.gwm.glb.num.rreq_misses
 
exp.gwf.gwm.glb.opens
 
exp.gwf.gwm.glb.positions
 
exp.gwf.gwm.glb.puts
exp.gwf.gwm.glb.replaces
 
exp.gwf.gwm.glb.sem.places
 
exp.gwf.gwm.glb.sem.stat
 
exp.gwf.gwm.glb.tabfs
 
exp.gwf.gwm.glb.terms
 
exp.gwf.gwm.glb.this_server
 
exp.gwf.gwm.glb.time_to_live
 
exp.gwf.gwm.num.mob_aborts
 
exp.gwf.gwm.num.mob_bad_cpositions
 
exp.gwf.gwm.num.mob_bad_ipositions
 
exp.gwf.gwm.num.mob_begins
 
exp.gwf.gwm.num.mob_closes
 
exp.gwf.gwm.num.mob_commits
 
exp.gwf.gwm.num.mob_deletes
 
exp.gwf.gwm.num.mob_gets
 
exp.gwf.gwm.num.mob_idxfs
 
exp.gwf.gwm.num.mob_inits
 
exp.gwf.gwm.num.mob_opens
 
exp.gwf.gwm.num.mob_positions
 
exp.gwf.gwm.num.mob_puts
 
exp.gwf.gwm.num.mob_replaces
 
exp.gwf.gwm.num.mob_tabfs
 
exp.gwf.gwm.num.mob_terms
 
exp.gwf.gwm.num.xt_aborts
 
exp.gwf.gwm.num.xt_bad_positions
 
exp.gwf.gwm.num.xt_begins
 
exp.gwf.gwm.num.xt_closes
 
exp.gwf.gwm.num.xt_commits
 
exp.gwf.gwm.num.xt_deletes
 
exp.gwf.gwm.num.xt_gets
 
exp.gwf.gwm.num.xt_idxfs
 
exp.gwf.gwm.num.xt_opens
 
exp.gwf.gwm.num.xt_positions
 
exp.gwf.gwm.num.xt_puts
 
exp.gwf.gwm.num.xt_replaces
 
exp.gwf.gwm.num.xt_tabfs
 
exp.gwf.gwm.num.xt_terms
 
exp.gwf.gwm.places.index
 
exp.gwf.gwm.places.sem
 
exp.gwf.gwm.places.type
 
exp.gwf.gwm.servers.class
 
exp.gwf.gwm.servers.cnd
 
exp.gwf.gwm.servers.conn_tree
 
exp.gwf.gwm.servers.connects
 
exp.gwf.gwm.servers.flags
 
exp.gwf.gwm.servers.flags_str
 
exp.gwf.gwm.servers.state
 
exp.gwf.gwm.servers.valid
 
exp.gwf.gwm.session.control.add_vnode
Control object, valid only in SQL session. Write of a vnode or server address adds it to the session domain.
exp.gwf.gwm.session.control.del_vnode
Control object, valid only in SQL session. Write of vnode or server address deletes it from the session domain.
exp.gwf.gwm.session.control.reset_domain
Control object, valid only in SQL session. Any write resets the session domain to the default server.
exp.gwf.gwm.session.dom.index
 
exp.gwf.gwm.trace.aborts
 
exp.gwf.gwm.trace.begins
 
exp.gwf.gwm.trace.closes
 
exp.gwf.gwm.trace.commits
 
exp.gwf.gwm.trace.deletes
 
exp.gwf.gwm.trace.errors
 
exp.gwf.gwm.trace.gets
 
exp.gwf.gwm.trace.idxfs
 
exp.gwf.gwm.trace.infos
 
exp.gwf.gwm.trace.inits
 
exp.gwf.gwm.trace.opens
 
exp.gwf.gwm.trace.positions
 
exp.gwf.gwm.trace.puts
 
exp.gwf.gwm.trace.replaces
 
exp.gwf.gwm.trace.tabfs
 
exp.gwf.gwm.trace.terms
 
exp.gwf.gwm.vnode.expire
 
exp.gwf.sxa.close_count
 
exp.gwf.sxa.close_fail_count
 
exp.gwf.sxa.get_bytid
 
exp.gwf.sxa.get_bytid_rescan
 
exp.gwf.sxa.get_count
 
exp.gwf.sxa.get_fail_count
 
exp.gwf.sxa.key_position_tries
 
exp.gwf.sxa.msgid_count
 
exp.gwf.sxa.msgid_fail_count
 
exp.gwf.sxa.msgid_lookup_count
 
exp.gwf.sxa.open_count
 
exp.gwf.sxa.open_fail_count
 
exp.gwf.sxa.reg_fail_count
 
exp.gwf.sxa.reg_index_try_count
 
exp.gwf.sxa.register_count
 
exp.gwf.sxa.update_attempts
 
exp.qsf.qso.dbp.dusage
 
exp.qsf.qso.dbp.index
Unique index value representing a database procedure in the QSF pool
exp.qsf.qso.dbp.lstate
 
exp.qsf.qso.dbp.name
Human readable name of the database procedure
exp.qsf.qso.dbp.owner
Login name of the user who owns (created) this database procedure
exp.qsf.qso.dbp.size
Size in bytes of this database procedure
exp.qsf.qso.dbp.udbid
ID of the database in which this database procedure was created (look up the id column in iidatabase)
exp.qsf.qso.dbp.usage
Usage counter for this database procedure
exp.qsf.qso.rqp.index
Unique index value representing a repeated query in the QSF pool
exp.qsf.qso.rqp.name
Human readable form of the name of this repeated query. The numeric values are the values used by the application when the query is defined.
exp.qsf.qso.rqp.size
Size in bytes of this repeated query
exp.qsf.qso.rqp.udbid
ID of the database in which this repeat query is defined. Look up the value of the id column in iidatabase
exp.qsf.qso.rqp.usage
Usage counter for this repeat query
exp.qsf.qsr.qsr_bkts_used
Number of hash buckets that actually have at least one object in them (QSF uses a hashing algorithm to speed up access to objects in the cache)
exp.qsf.qsr.qsr_bmaxobjs
Max number of objects ever in any one given bucket
exp.qsf.qsr.qsr_decay_factor
 
exp.qsf.qsr.qsr_memleft
Free memory within the QSF pool
exp.qsf.qsr.qsr_memtot
Total amount of memory to use for QSF's memory pool.
exp.qsf.qsr.qsr_mx_index
High watermark (maximum) number of indexed objects
exp.qsf.qsr.qsr_mx_named
High watermark (maximum) of Named Objects
exp.qsf.qsr.qsr_mx_rsize
Size of the largest single object requested from the QSF pool
exp.qsf.qsr.qsr_mx_size
Size of the largets object stored in the QSF pool
exp.qsf.qsr.qsr_mx_unnamed
High watermark of the number of unnamed objects stored in this QSF pool
exp.qsf.qsr.qsr_mxbkts_used
High watermark of the number of hash buckets that have been used in this QSF pool
exp.qsf.qsr.qsr_mxobjs
High watermark of the number of objects stored in this QSF pool
exp.qsf.qsr.qsr_mxsess
High watermark of the number of concurrent active sessions accessing this QSF pool
exp.qsf.qsr.qsr_named_requests
Number of times that a named object was requested (since the last time the pool was flushed)
exp.qsf.qsr.qsr_nbuckets
Number of hash buckets in this QSF pool
exp.qsf.qsr.qsr_no_destroyed
Number of 'master' objects destroyed
exp.qsf.qsr.qsr_no_index
Current number of 'master' or indexed objects
exp.qsf.qsr.qsr_no_named
Current number of named objects in this QSF pool
exp.qsf.qsr.qsr_no_unnamed
Current number of unnamed objects
exp.qsf.qsr.qsr_nobjs
Number of objects currently stored in QSF
exp.qsf.qsr.qsr_nsess
QSF sessions currently active
exp.rdf.rdi.cache.max_defaults
Maximum number of DEFAULTS that can be cached by RDF
exp.rdf.rdi.cache.max_ldb_descs
Maximum number of LDBs (databases) that can be cached by RDF
exp.rdf.rdi.cache.max_qtree_objs
Maximum number of Query Tree objects that can be cached by RDF
exp.rdf.rdi.cache.max_tables
Maximum number of tables whose information can be cached by RDF
exp.rdf.rdi.cache.size
Size of the RDF cache in bytes
exp.rdf.rdi.flags.cost_set
Indicates whether CPU/net cost are set for distributed query optimization
exp.rdf.rdi.num.bad_cksums
Counter for number of bad checksums detected
exp.rdf.rdi.num.cluster_nodes
Number of nodes known to cluster Actian X installation. 0 if not a cluster installation
exp.rdf.rdi.num.ddbs_caches
Number of distributed databases to cache
exp.rdf.rdi.num.max_sessions
Maximum number of sessions allowed in a server
exp.rdf.rdi.num.memleft
Remaining memory in the RDF pool, in bytes
exp.rdf.rdi.startup.avg_ldbs
Saved input parameter for the average number of ldbs per ddb
exp.rdf.rdi.startup.cache_ddbs
Saved input parameter for the maximum number of ddbs to cache
exp.rdf.rdi.startup.max_tables
Saved input parameter for the number of tables in the relation cache
exp.rdf.rdi.startup.memory
Saved input parameter for the RDF pool size, in bytes
exp.rdf.rdi.startup.table_columns
Saved input parameter for estimated average number of columns per table
exp.rdf.rdi.startup.table_synonyms
Saved input parameter for average number of synonyms per table
exp.rdf.rdi.state_num
Integer value representing the state of the RDF cache–look up ima_rdf_cache_status in the IMA_STATUS_LOOKUP
exp.rdf.rdi.state_str
State of the RDF cache as a human-readable string
exp.rdf.stat.a10_dbdb
Counter for the number of times a tuple has been appended to the iidbdb catalog
exp.rdf.stat.a16_syn
Counter for the number of times a tuple has been appended to the iisynomyms catalog
exp.rdf.stat.a17_comment
Counter for the number of times a tuple has been appended to the iicomment catalog
exp.rdf.stat.a21_seqs
 
exp.rdf.stat.a2_permit
Counter for the number of times permission info has been appended to the catalogs
exp.rdf.stat.a3_integ
Counter for the number of times integrity info has been appended to the catalogs
exp.rdf.stat.a4_view
Counter for the number of times view info has been appended to the catalogs
exp.rdf.stat.a5_proc
Counter for the number of times procedure info has been appended to the catalogs
exp.rdf.stat.a6_rule
Counter for the number of times rule info has been appended to the catalogs
exp.rdf.stat.a7_event
Counter for the number of times event info has been appended to the catalogs
exp.rdf.stat.a8_alltoall
Counter for the number of times "all to public" permission has been set on an object
exp.rdf.stat.a9_rtoall
Counter for the number of times "retrieve to all"/"select to public" permission has been set on an object
exp.rdf.stat.b0_exists
 
exp.rdf.stat.b11_stat
 
exp.rdf.stat.b12_itups
Counter for the number of times integrity tuples were built and placed in the cache
exp.rdf.stat.b13_etups
Counter for the number of times requested event permits were obtained on single RDF call (these are never cached)
exp.rdf.stat.b14_ptups
Counter for the number of times permit tuples were built and placed on the cache
exp.rdf.stat.b15_rtups
Counter for the number of times rule tuples were built and placed on the cache
exp.rdf.stat.b16_syn
Counter for the number of times a tuple has been found in the iisynonyms catalog and placed on the cache
exp.rdf.stat.b18_pptups
Counter for the number of times procedure parameter tuples were built and placed on the cache
exp.rdf.stat.b19_ktups
Counter for the number of times iikey tuples were built and placed on cache
exp.rdf.stat.b1_core
 
exp.rdf.stat.b21_seqs
 
exp.rdf.stat.b2_permit
Counter for the number of times permission info has been built and placed on the cache
exp.rdf.stat.b3_integ
Counter for the number of times integrity info has been built and placed on the cache
exp.rdf.stat.b4_view
Counter for the number of times view info has been built and placed on the cache
exp.rdf.stat.b5_proc
Counter for the number of times procedure info has been built and placed on the cache
exp.rdf.stat.b6_rule
Counter for the number of times rule info has been built and placed on the cache
exp.rdf.stat.b7_event
Counter for the number of times event info has been built (this is never cached)
exp.rdf.stat.c0_exists
 
exp.rdf.stat.c11_stat
 
exp.rdf.stat.c12_itups
Counter for the number of times requested integrity tuples were already on cache
exp.rdf.stat.c14_ptups
Counter for the number of times requested permit tuples were already on the cache
exp.rdf.stat.c15_rtups
Counter for the number of times requested rule tuples were already on cache
exp.rdf.stat.c18_pptups
Counter for the number of times requested procedure parameter tuples were already on cache
exp.rdf.stat.c19_ktups
Counter for the number of times iikey tuples requested were already on the cache
exp.rdf.stat.c1_core
 
exp.rdf.stat.c2_permit
Counter for the number of times requested permission info was already on the cache
exp.rdf.stat.c3_integ
Counter for the number of times requested integrity info was already on the cache
exp.rdf.stat.c4_view
Counter for the number of times requested view info was already on the cache
exp.rdf.stat.c5_proc
Counter for the number of times requested procedure info was already on the cache
exp.rdf.stat.c6_rule
Counter for the number of times requested rule info was already on the cache
exp.rdf.stat.d10_dbdb
Counter for the number of times a tuple has been deleted from the iidbdb catalog
exp.rdf.stat.d16_syn
Counter for the number of times a tuple has been deleted from the iisynonyms catalog
exp.rdf.stat.d17_comment
Counter for the number of times a tuple has been deleted from the iicomment catalog
exp.rdf.stat.d21_seqs
 
exp.rdf.stat.d2_permit
Counter for the number of times permission info has been deleted from the catalogs
exp.rdf.stat.d3_integ
Counter for the number of times integrity info has been deleted from the catalogs
exp.rdf.stat.d4_view
Counter for the number of times view info has been deleted from the catalogs
exp.rdf.stat.d5_proc
Counter for the number of times procedure info has been deleted from the catalogs
exp.rdf.stat.d6_rule
Counter for the number of times rule info has been deleted from the catalogs
exp.rdf.stat.d7_event
Counter for the number of times event info has been deleted from the catalogs
exp.rdf.stat.d8_alltoall
Counter for the number of times "all to public" permission has been renamed from an object
exp.rdf.stat.d9_rtoall
Counter for the number of times "retrieve to all"/"select to public" permission has been removed from an object
exp.rdf.stat.f0_relation
Counter for the number of times a relation object is fixed in memory
exp.rdf.stat.f1_integrity
Counter for the number of times an integrity object is fixed in memory
exp.rdf.stat.f2_procedure
Counter for the number of times a procedure object is fixed in memory
exp.rdf.stat.f3_protect
Counter for the number of times a protect object is fixed in memory
exp.rdf.stat.f4_rule
Counter for the number of times a rule object is fixed in memory
exp.rdf.stat.i1_obj_invalid
Counter for the number of times a single object in the RDF cache is invalidated.
exp.rdf.stat.i2_p_invalid
Counter for the number of times a procedure object is invalidated from RDF cache
exp.rdf.stat.i3_flushed
Counter for the number of times an object to be invalidated is already flushed off of the cache–indicator of extreme concurrency conditions
exp.rdf.stat.i4_class_invalid
Counter for the number of times all protect or integrity or rule trees of this class have been invalidated
exp.rdf.stat.i5_tree_invalid
Counter for the number of times a protect/integrity/rule tree has been invalidated
exp.rdf.stat.i6_qtcache_invalid
Counter for the number of times the RDF Query Tree cache is invalidated
exp.rdf.stat.i7_cache_invalid
Counter for the number of times the whole RDF cache is invalidated
exp.rdf.stat.i8_cache_invalid
Counter for the number of times the ldbdesc cache is invalidated
exp.rdf.stat.l0_private
Counter for the number of times RDF makes a private RDR_INFO object because another thread has an update lock on the object that this thread wants to update. This is an indicator of RDF concurrency.
exp.rdf.stat.l1_private
Overflow counter for rds_f1_private
exp.rdf.stat.l2_supdate
Counter for the number of times a thread updates a shared RDR_INFO object.
exp.rdf.stat.l3_supdate
Overflow counter for rds_f2_supdate
exp.rdf.stat.m12_itups
Counter for the number of times requested integrity tuples required multiple reads
exp.rdf.stat.m13_etups
Counter for the number of times event permit tuples required multiple RDF calls
exp.rdf.stat.m14_ptups
Counter for the number of times permit tuples required multiple reads
exp.rdf.stat.m15_rtups
Counter for the number of times rule tuples required multiple reads
exp.rdf.stat.m18_pptups
Counter for the number of times procedure parameter tuples required multiple reads
exp.rdf.stat.m19_ktups
Counter for the number of times iikey tuples required multiple reads
exp.rdf.stat.n0_tables
Counter for the number of tables on the cache. This will include multiple instances of the same table. If a table is cleared from cache, then a cache entry for it is rebuilt. It will count twice. Used to calculate the average number of columns
exp.rdf.stat.n10_nomem
Counter for the number of times RDF runs out of memory on the cache and is unable to reclaim it from either the query tree or the relation cache. If this count is non-zero, user MUST tune RDF cache to increase memory size.
exp.rdf.stat.n11_LDBmem_claim
Counter for the number of times RDF runs out of memory on the cache and reclaims it from the LDBdesc cache
exp.rdf.stat.n1_avg_col
 
exp.rdf.stat.n2_avg_idx
 
exp.rdf.stat.n7_exceptions
Counter for the number of exceptions RDF has encountered
exp.rdf.stat.n8_QTmem_claim
Counter for the number of times RDF runs out of memory on the cache and reclaims it from the Query Tree cache
exp.rdf.stat.n9_relmem_claim
Counter for the number of times RDF runs out of memory on the cache and reclaims it from the Relation cache
exp.rdf.stat.o10_dbdb
Counter for the number of times a tuple has been replaced/purged from the iidbdb catalog
exp.rdf.stat.r0_exists
 
exp.rdf.stat.r11_stat
 
exp.rdf.stat.r12_itups
Counter for the number of times integrity tuples were requested
exp.rdf.stat.r13_etups
Counter for the number of times event permit tuples were requested
exp.rdf.stat.r14_ptups
Counter for the number of times permit tuples were requested
exp.rdf.stat.r15_rtups
Counter for the number of times rule tuples were requested
exp.rdf.stat.r16_syn
Counter for the number of times RDF has looked for a synonym
exp.rdf.stat.r18_pptups
Counter for the number of times procedure parameter tuples were requested
exp.rdf.stat.r19_ktups
Counter for the number of times iikey tuples were requested
exp.rdf.stat.r1_core
 
exp.rdf.stat.r21_seqs
 
exp.rdf.stat.r2_permit
Counter for the number of times permission info has been requested from RDF
exp.rdf.stat.r3_integ
Counter for the number of times integrity info has been requested from RDF
exp.rdf.stat.r4_view
Counter for the number of times view info has been requested from RDF
exp.rdf.stat.r5_proc
Counter for the number of times procedure info has been requested from RDF
exp.rdf.stat.r6_rule
Counter for the number of times rule info has been requested from RDF
exp.rdf.stat.r7_event
Counter for the number of times event info has been requested from RDF
exp.rdf.stat.rdf_n12_default_claim
Counter for the number of times RDF runs out of memory on the cache and reclaims it from the defaults cache
exp.rdf.stat.u0_protect
Counter for the number of times a shared protect object is unfixed
exp.rdf.stat.u10_private
Counter for the number of times private RDR_INFO is unfixed
exp.rdf.stat.u11_shared
Counter for the number of times shared RDR_INFO is unfixed
exp.rdf.stat.u1_integrity
Counter for the number of times a shared integrity object is unfixed
exp.rdf.stat.u2_procedure
Counter for the number of times a shared procedure object is unfixed
exp.rdf.stat.u3_rule
Counter for the number of times a shared rule object is unfixed
exp.rdf.stat.u4p_protect
Counter for the number of times a private protect object is unfixed
exp.rdf.stat.u5p_integrity
Counter for the number of times a private integrity object is unfixed
exp.rdf.stat.u6p_procedure
Counter for the number of times a private procedure object is unfixed
exp.rdf.stat.u7p_rule
Counter for the number of times a private rule object is unfixed
exp.rdf.stat.u8_invalid
Counter for the number of times an invalid qrymod object unfix has been requested. This should always be zero in a healthy environment.
exp.rdf.stat.u9_fail
Counter for the number of times a RDR_INFO unfix request failed. This should always be zero in a healthy environment.
exp.rdf.stat.x1_relation
Counter for the number of times a relation infoblk is refreshed on behalf of caller's request
exp.rdf.stat.x2_qtree
Counter for the number of times a qtree cache object is refreshed on behalf of caller's request
exp.rdf.stat.z0_exists
 
exp.rdf.stat.z12_itups
Counter for the number of times requested integrity tuples were not found
exp.rdf.stat.z13_etups
Counter for the number of times requested event permit tuples were not found
exp.rdf.stat.z14_ptups
Counter for the number of times requested permit tuples were not found
exp.rdf.stat.z15_rtups
Counter for the number of times rule tuples not found
exp.rdf.stat.z16_syn
Counter for the number of times RDF looked for a synonym, but none was found
exp.rdf.stat.z18_pptups
Counter for the number of times procedure parameter tuples were not found
exp.rdf.stat.z19_ktups
Counter for the number of times iikey tuples requested were not found
exp.rdf.stat.z1_core
 
exp.scf.scd.acc
Expected average number of active cursors per session
exp.scf.scd.avgrows
Expected average number of rows returned in a select
exp.scf.scd.capabilities_num
Server capabilities–look up ima_server_capabilities in IMA_STATUS_LOOKUP
exp.scf.scd.capabilities_str
Server capabilities as a string
exp.scf.scd.csrflags
Cursor flags–look up ima_cursor_flags in IMA_STATUS_LOOKUP
exp.scf.scd.defcsrflag
 
exp.scf.scd.fastcommit
0 if not using fast commit, non-zero if using fast commit
exp.scf.scd.flatflags
Server flattening options–look up ima_server_flatten_options in IMA_STATUS_LOOKUP
exp.scf.scd.gclisten_fail
Number of consecutive GCA_LISTEN failures; if too many, server closes
exp.scf.scd.irowcount
Number of rows to expect the first time through a select
exp.scf.scd.max_priority
 
exp.scf.scd.min_priority
 
exp.scf.scd.names_reg
0 if not registered with name server, non-zero if registered
exp.scf.scd.no_star_cluster
Zero if cluster optimizations should be done in Star; otherwise do not
exp.scf.scd.norm_priority
 
exp.scf.scd.nostar_recovr
Zero if 2PC recovery should be done
exp.scf.scd.nousers
Maximum number of non-CL threads, including internal DBMS threads
exp.scf.scd.psf_mem
PSF memory pool size
exp.scf.scd.risk_inconsistency
User requested inconsistency risk (Recovery Server and DBMS may have different UDTs)
exp.scf.scd.rule_del_prefetch
 
exp.scf.scd.rule_depth
Rule nesting depth
exp.scf.scd.rule_upd_prefetch
 
exp.scf.scd.selcnt
Number of selects
exp.scf.scd.server.control.close
Control object: Any write causes the server to stop accepting new connections from non-privileged user.
exp.scf.scd.server.control.crash
Control object: Any write causes server to crash, immediately.
exp.scf.scd.server.control.open
Control object: Any write causes server to accept normal connections, and cancels any pending shutdown.
exp.scf.scd.server.control.shut
Control object: Any write causes server to stop accepting new non-privileged connections, and to shut down when the last user session exits.
exp.scf.scd.server.control.start_sampler
 
exp.scf.scd.server.control.stop
Control object: Any write causes the server to shut down immediately no matter what the state of current connections.
exp.scf.scd.server.control.stop_sampler
 
exp.scf.scd.server.current_connections
Number of current user sessions. Server is idle when count is zero.
exp.scf.scd.server.highwater_connections
Highwater count of number of connections for this server
exp.scf.scd.server.listen_mask
Server listen mask–look up ima_server_listen_mask in IMA_STATUS_LOOKUP
exp.scf.scd.server.listen_state
OPEN or CLOSED to non-privileged user connections
exp.scf.scd.server.max_connections
Maximum allowed number of user connections for this server
exp.scf.scd.server.pid
PID of this server as a decimal value
exp.scf.scd.server.reserved_connections
Number beyond max_connections for privileged users to acquire
exp.scf.scd.server.shutdown_state
PENDING shutdown or OPEN
exp.scf.scd.server_name
Server name
exp.scf.scd.soleserver
Non-zero if this is the only server handling the databases in the dblist
exp.scf.scd.start.name
 
exp.scf.scd.startup_time
 
exp.scf.scd.state_num
Server activity–look up ima_server_activity in IMA_STATUS_LOOKUP
exp.scf.scd.state_str
Server activity as a string
exp.scf.scd.writebehind
Number of write behind threads
exp.scf.scs.scb_act_detail
More detailed information about the activity of the session (if known)
exp.scf.scs.scb_activity
The 'major' activity in which the session is engaged (if known)
exp.scf.scs.scb_appl_code
The application code of the session
exp.scf.scs.scb_client_connect
The 'connection string' requested by the client–including vnode, database, and server class information
exp.scf.scs.scb_client_host
Name of the VNODE (if known) on which this client session originated
exp.scf.scs.scb_client_info
The 'client information block'–including all ima_client_info columns and any user specified options
exp.scf.scs.scb_client_pid
PID (if known) of the original client process
exp.scf.scs.scb_client_tty
The terminal (if known) associated with the client process on the originating machine. This value will be the same as exp.scf.scs.scb_terminal for local connections
exp.scf.scs.scb_client_user
Username (if known) associated with the process that originated this connection
exp.scf.scs.scb_connect_limit
 
exp.scf.scs.scb_crash_session
Control object: When written with a string of the decimal value of the session ID, causes the session to crash. This is dangerous, and may corrupt the server.
exp.scf.scs.scb_database
Database associated with the specified session
exp.scf.scs.scb_dblockmode
"Exclusive" or "shared"–the database locking mode for the session
exp.scf.scs.scb_dbowner
The owner of the database the session is using, empty if the session is in no database
exp.scf.scs.scb_description
 
exp.scf.scs.scb_euser
The current effective user ID of the session
exp.scf.scs.scb_facility_index
The current facility for the session, as a number–look up ima_facility_index in IMA_STATUS_LOOKUP
exp.scf.scs.scb_facility_name
The current server facility as a string
exp.scf.scs.scb_gca_assoc_id
The GCA association ID for the session, plus 1 so assoc 0 is not used
exp.scf.scs.scb_group
Current effective group ID for the session
exp.scf.scs.scb_idle_limit
 
exp.scf.scs.scb_index
The session ID for the session in a DBMS server–as a string representing a decimal value. This value is not represented as an integer because of overflow problems on 64-bit machines. To cross reference to the errlog.log, and so on, convert to hex
exp.scf.scs.scb_initial_connect_limit
 
exp.scf.scs.scb_initial_idle_limit
 
exp.scf.scs.scb_lastquery
 
exp.scf.scs.scb_pid
The operating system PID of the server containing this session as a decimal value
exp.scf.scs.scb_priority
 
exp.scf.scs.scb_priority_limit
 
exp.scf.scs.scb_ptr
 
exp.scf.scs.scb_query
The query being executed–this query consists of the query text passed down from the GCA message, and so will not have parameters 'in place'
exp.scf.scs.scb_remove_session
Control object: Writing with a string of the session ID causes the session to be terminated as if the client application had exited. This is the safe and preferred way to make a session go away.
exp.scf.scs.scb_role
Current effective role for the session
exp.scf.scs.scb_ruser
The operating system user that invoked the session
exp.scf.scs.scb_s_name
Our idea of the user who started the session
exp.scf.scs.scb_self
 
exp.scf.scs.scb_terminal
Name of the terminal associated with this session in an operating system specific format. This value is valid for local connections only and will appear as 'batch' for Net connections–see ima_client info for the original user terminal.
exp.sxf.audit.audit_wakeup
 
exp.sxf.audit.close_count
 
exp.sxf.audit.create_count
 
exp.sxf.audit.extend_count
 
exp.sxf.audit.flush_count
 
exp.sxf.audit.flush_empty
 
exp.sxf.audit.flush_predone
 
exp.sxf.audit.logswitch_count
 
exp.sxf.audit.open_read
 
exp.sxf.audit.open_write
 
exp.sxf.audit.read_buffered
 
exp.sxf.audit.read_direct
 
exp.sxf.audit.write_buffered
 
exp.sxf.audit.write_direct
 
exp.sxf.audit.write_full
 
exp.sxf.audit_writer_wakeup
 
exp.sxf.db_build
 
exp.sxf.db_purge
 
exp.sxf.db_purge_all
 
exp.sxf.mem_at_startup
 
exp.sxf.queue_flush
 
exp.sxf.queue_flush_all
 
exp.sxf.queue_flush_empty
 
exp.sxf.queue_flush_full
 
exp.sxf.queue_write
 
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
 
 
Last modified date: 04/03/2024