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_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 |