Index

A

• Abort client meter (all clients)
• absolute time indication
• absolute values, for Server meters
• Add/Drop/Parse Index Details dialog
• address space
  • reservation
  • unassigned
• Allow Shared Communications Server parameter
• Analyzer
  • window
• application objects
  • identifying
• Application Trace Details dialog
• Application Trace Environment dialog
• application tracing
  • automatic stop
  • exporting application trace data
  • getting information on concurrent data access
  • opening and formatting a trace file
• application, changing
• aquisition of locks
• Authentication Required Server parameter
• automatic stop of application tracing
• automatic tracing
  • description

C

• cache hit rate client ratio
• Cache Manager Ping Time In Transaction Server parameter
• Cache Manager Ping Time Server parameter
• cache replacement
  • optimizing
• cache size, managing
• callback immediate page event
• Callback Messages Sent client meter (all clients)
• callback of pages, handling
• callback pending page event
• Callback Sectors client meter (all clients)
• Change Representation Details dialog
• changing the application
• client counters
  • deadlock candidates
  • deadlocks
  • exceptions
  • long page fetches
  • long page upgrades
  • objects allocated
  • objects deleted
  • page relocations
  • pages allocated
  • pages called back
  • pages called back immediately
  • pages called back pending
  • pages committed
  • pages evicted
  • pages fetched
  • pages fetched for read
  • pages fetched for write
  • pages fetched free rider
  • pages flushed
  • pages locked (working set)
  • pages locked for write
  • pages not locked
  • pages refetched
  • pages returned dirty
  • pages upgraded
  • pages upgraded for read (local)
  • pages upgraded for write (local)
  • pages upgraded for write (Server)
  • timeouts
• Client Counters/Ratios diagrams
  • client counters
  • client ratios
  • creating a diagram
  • description
  • displaying counters/ratios
  • selecting client counters/ratios
  • unassigned address space
  • values, as absolute values or rates
• client meters (all clients)
  • Aborts
  • Callback Messages Sent
  • Callback Sectors
  • Commits
  • Deadlocks
  • KB Read
  • KB Written
  • Message Buffer Waits
  • Messages Received
  • Notifies Received
  • Notifies Sent
  • Read-Only Commits
  • Succeeded Sectors
  • Two Phase Aborts
  • Two Phase Commits
• client ratios
  • cache hit rate
  • page refetch rate
  • rate of data pages called back
  • rate of data pages committed
  • rate of data pages evicted
  • rate of data pages fetched
  • rate of data pages locked
  • rate of data pages upgraded
• command line
  • defining the trace file name
  • man osopef command
  • osopes command syntax
  • osopes -help command
• Commits client meter (all clients)
• commits, handling
• Compilation Server parameter
• components of OPE
  • Analyzer
  • Retriever
• concurrent data access
  • hot spots
  • lock acquisition
  • page callbacks
• counters
  • See client counters
• CPU Time (system) general Server meter
• CPU Time (user) general Server meter
• Current Environment dialog
• Current Log Size log meter

D

• data fetches, handling
• data transfer
  • cache size
  • commits
  • fetches
  • Server load
• Database Event Details dialog database, storage object 92,
• database, storage object 92,
• DB Expiration Time Server parameter
• deadlock candidates
  • client counter
• deadlock client counter
• Deadlock Victim Server parameter
• Deadlocks client meter (all clients)
• diagram interval
• diagrams
  • Client Counters/Ratios diagrams
  • ElapsedTime diagram
  • PageState diagram
  • Storage Counters/Ratios diagrams
  • TimeLine diagram
• dialogs
  • Add/Drop/Parse Index Details
  • Application Trace Details
  • Application Trace Environment
  • Change Representation Details
  • Current Environment
  • Database Event Details
  • Environment Event Details
  • Execute/Parse Query Details
  • Find Events Format a Trace File 11,
  • Format a Trace File 11,
  • Formatting Progress
  • Generic Event Details
  • Memory Event Details
  • Open an Application Trace
  • Page Handling Event Details Preferences 68,
  • Preferences 68,
  • Processing Progress
  • Relocation Event Details
  • Select Client Counters
  • Select Client Ratios
  • Select Events
  • Select Server Meters
  • Select Storage Counters
  • Select Storage Ratios
  • Select Trace
  • Shadow Details
  • Specify Sampling Parameters
  • Specify Server Name Specify Threshold 149,
  • Specify Threshold 149,
  • Specify Thresholds
  • Specify Transaction Summary
  • Specify User Exit
  • Storage Details
  • Storage Scale Details
  • Trace Event Details Transaction Details 15,
  • Transaction Details 15,
• Direct To Segment Threshold Server parameter
• dynamic transactions, using

E

• ElapsedTime diagram
  • description
  • diagram area
  • diagram interval line
  • file
  • help
  • options
  • status line
  • windows
• Environment Event Details dialog
• environment variables for the Analyzer
  • OS_OPE_ANALYZER_PROFILE
  • setting a profile name
• environment variables for the Retriever
  • allow automatic tracing
  • OS_ALLOW_OPE_AUTO_START
  • OS_OPE_APPEND_PID
  • OS_OPE_ENV_top_event_name
  • OS_OPE_OBJECT_ALLOCATION
  • OS_OPE_REPORT_QUERY_EVENTS
  • OS_OPE_STOP_TRACING
  • OS_OPE_TRACE_FILE_FLUSH
  • OS_OPE_TRACE_FILE_VERSION
  • process identification number
  • query/index support
• environment variables for the Server Monitor
  • OS_OPE_SERVMON_PROFILE
  • setting a profile name
• ER page state
• ERLR page state
• event lines
  • generic events line
  • miscellaneous events line
  • overview
  • trace and transaction events line
• events
  • disabling generic events
  • enabling generic events
  • environment change events on the PageState diagram
  • generic events on the PageState diagram
• eviction page event
• EW page state
• EWLR page state
• EWLW page state
• exception client counter
• Execute/Parse Query Details dialog
• exit program
  • See user exit

F

• fetch error page event
• fetches, handling
• Find Events dialog
• Flush Data log meter
• Flush Records log meter
• flush, trace file to disk Format a Trace File dialog 11,
• Format a Trace File dialog 11,
• Format option values
• formatting a trace file

G

• general Server meters
  • CPU Time (system)
  • CPU Time (user)
  • Inputs (file system)
  • Involuntary Context Switches
  • Max Resident Set Size
  • Messages Received
  • Messages Sent
  • Outputs (file system)
  • Page Faults
  • Page Reclaims
  • Signals Received
  • Swaps
  • Voluntary Context Switches
• generic event
  • defining
  • raising
• Generic Event Details dialog
• generic event message area

H

• handling exceptions
• hot spots of concurrent data access, finding

I

• identifying application objects 184-??
• incremental selection of the diagram interval (TimeLine diagram)
• Inputs (file system) general Server meter
• Involuntary Context Switches general Server meter

K

• KB Data log meter
• KB Direct log meter
• KB Propagated log meter
• KB Read client meter (all clients)
• KB Records log meter
• KB Written client meter (all clients)

L

• Launch interval
• lock acquisition, handling
• lock upgrade error page event
• locking, two-phase
• Log Data Segment Growth Increment Server parameter
• Log Data Segment Initial Size Server parameter
• log file
  • number of samples
  • viewing
  • writing multiple
• Log File Server parameter
• log meters
  • Current Log Size
  • Flush Data
  • Flush Records
  • KB Data
  • KB Direct
  • KB Propagated
  • KB Records
  • Log Records
  • Propagations
  • Record Segment Switches
• Log Record Segment Buffer Size Server parameter
• Log Record Segment Growth Increment Server parameter
• Log Record Segment Initial Size Server parameter
• Log Records log meter
• logging
  • overview
  • start
  • Start logging window
• long page fetches client counter
• long page upgrades client counter

M

• macros
  • See transactions
• manual tracing
  • description
• Max AIO Threads Server parameter
• Max Connect Memory Usage Server parameter
• Max Data Propagation Per Propagate Server parameter
• Max Data Propagation Threshold Server parameter
• Max Memory Usage Server parameter
• Max Resident Set Size general Server meter
• Max Two Phase Delay Server parameter
• Memory Event Details dialog
• Message Buffer Size Server parameter
• Message Buffer Waits client counter (all clients)
• Message Buffers Server parameter
• Messages
• messages and names area
  • generic event message area
  • transaction names line
• Messages Received client meter (all clients)
• Messages Received general Server meter
• Messages Sent general Server meter
• multiversion concurrency control
• MVCC
  • See multiversion concurrency control

N

• navigation elements
  • of the ElapsedTime diagram
  • of the PageState diagram
  • of the Storage Counters/Ratios diagram
  • of the time axis
  • of the TimeLine diagram
• NE page state
• notification message
  • See user exit
• Notifies Received client meter (all clients)
• Notifies Sent client meter (all clients)
• NotSeen page state

O

• object allocation, statistical information
• objects allocated client counter
• objects deleted client counter
• ObjectStore Release Name Server parameter
• OPE Retriever
  • See Retriever
• OPE Retriever API
  • See Retriever API
• Open an Application Trace dialog
• options for invoking the Server Monitor
  • -f
  • -l
  • -s
• options for trace file formatting
  • -f
  • -lf
  • -lu
  • -pc
  • -ps
  • -q
• OS_ALLOW_OPE_AUTO_START environment variable
• os_ope class
• OS_OPE_ANALYZER_PROFILE environment variable
• OS_OPE_OBJECT_ALLOCATION environment variable
• OS_OPE_SERVMON_PROFILE environment variable
• OS_OPE_STOP_TRACING environment variable
• OS_OPE_TRACE_FILE_BUFFER_SIZE environment variable
• OS_OPE_TRACE_FILE_FLUSH environment variable
• OS_OPE_TRACE_FILE_VERSION environment variable
• osopes
• Outputs (file system) general Server meter

P

• page allocation page event
• page callbacks, handling
• page events
  • callback immediate
  • callback pending
  • eviction
  • fetch error
  • lock upgrade error
  • page allocation
  • relocation
• Page Faults general Server meter
• Page Handling Event Details dialog
• Page Reclaims general Server meter
• page refetch rate client ratio
• page relocations client counter
• page states
  • ER
  • ERLR
  • EW
  • EWLR
  • EWLW
  • NE
  • NotSeen
  • Unknown
  • WF
  • WL
  page, storage object 92,
• page, storage object 92,
• pages allocated client counter
• pages called back client counter
• pages called back immediately client counter
• pages called back pending client counter
• pages committed client counter
• pages evicted client counter
• pages fetched client counter
• pages fetched for read client counter client counter 47,
• pages fetched for write client counter 47,
• pages fetched free rider client counter
• pages flushed client counter
• pages locked (working set) client counter
• pages locked for write client counter
• pages not locked client counter client counter 47,
• pages refetched client counter 47,
• pages returned dirty client counter
• pages upgraded client counter
• pages upgraded for read (local) client counter
• pages upgraded for write (local) client counter
• pages upgraded for write (Server) client counter
• PageState diagram
  • collapsing selected storage objects
  • collapsing single storage objects
  • database as storage object
  • edit
  • event lines

    See also TimeLine diagram, event lines

  • events

    environment change events

    generic events

  • expanding selected storage objects
  • expanding single storage objects
  • file
  • help
  • hiding selected storage objects
  • hiding single storage objects
  • horizontal scroll bar include page state information 29,
  • include page state information 29,
  • options
  • overview
  • page as storage object
  • page events
  • page states
  • pop-up menus refresh while scrolling 99,
  • refresh while scrolling 99,
  • segment as storage object
  • selecting storage objects
  • showing selected storage objects
  • showing single storage objects
  • status line
  • storage area
  • storage objects
  • storage pane
  • storage scale
  • time axis
  • vertical scroll bar
  • vertical zoom box
  • windows
• Parameter File Server parameter
• performance database
  • defining the name including page state information 29,
  • including page state information 29, options 29,
  • options 29, overwriting 29,
  • overwriting 29,
• pop-up menus
  • for Client Counters/Ratios diagrams
  • for Storage Counters/Ratios diagrams
  • for the PageState diagram
  • for the Server Monitor
  • for TimeLine diagram
  • for viewing a log file
  Preferences dialog 68,
• Preferences dialog 68,
• Preferred Network Receive Buffer Size Server parameter
• Preferred Network Send Buffer Size Server parameter Processing Progress dialog 12,
• Processing Progress dialog 12,
• profile for the Analyzer
• profile for the Server Monitor
• profile name for the Analyzer, setting
• profile name for the Server Monitor, setting
• Propagation Buffer Size Server parameter
• Propagation Sleep Time Server parameter
• Propagations log meter

R

• rate of data pages called back client ratio
• rate of data pages committed client ratio
• rate of data pages evicted client ratio
• rate of data pages fetched client ratio
• rate of data pages locked client ratio
• rate of data pages upgraded client ratio
• rates, for Server meters
• ratios
  • See client ratios
• Read-Only Commits client meter (all clients)
• Record Segment Switches log meter refresh while scrolling, PageState diagram 99,
• refresh while scrolling, PageState diagram 99,
• refresh while scrolling, Storage Counters/Ratios diagram
• refresh while scrolling, time axis refresh while scrolling, TimeLine diagram 53,
• refresh while scrolling, TimeLine diagram 53,
• relative time indication
• relocation
  • address space reservation
  • description
  • reasons for
• Relocation Event Details dialog
• relocation page event relocation, handling 181-
• relocation, handling 181-
• resume methods of the Retriever API
• Retriever API
  • classes

    os_ope

    os_ope_generic_event

  • defining a generic event
  • exception handling
  • generic event raise methods
  • methods

    start and stop

    suspend and resume

  • raising a generic event
  • resume methods
  • start methods
  • stop methods
  • suspend methods
• Retriever, overview

S

sampling rate for Server measurements 125,
• sampling rate for Server measurements 125, segment, storage object 92,
• segment, storage object 92,
• Select Client Counters dialog
• Select Client Ratios dialog
• Select Events dialog
• Select Storage Counters dialog
• Select Storage Ratios dialog
• Select Trace dialog
• Server load, managing
• Server Major Version Server parameter
• Server Minor Version Server parameter
• Server Monitor
  • client meters
  • default settings
  • description
  • diagram elements
  • edit
  • file
  • general Server meters invoking 126,
  • invoking 126,
  • log meters
  • menu bar options 142,
  • options 142,
  • osopes command syntax
  • osopes -help command
  • overview
  • pop-up menus

    for diagram cells

    for empty cells

    sampling rate 125,
  • sampling rate 125,
  • Server meters, as absolute values or rates
  • Server parameters
  • status line view interval 125,
  • view interval 125,
  • window
• Server parameters
  • Allow Shared Communications
  • Authentication Required
  • Cache Manager Ping Time
  • Cache Manager Ping Time In Transaction
  • Compilation
  • DB Expiration Time
  • Deadlock Victim
  • Direct To Segment Threshold
  • Log Data Segment Growth Increment
  • Log Data Segment Initial Size
  • Log File
  • Log Record Segment Buffer Size
  • Log Record Segment Growth Increment
  • Log Record Segment Initial Size
  • Max AIO Threads
  • Max Connect Memory Usage
  • Max Data Propagation Per Propagate
  • Max Data Propagation Threshold
  • Max Memory Usage
  • Max Two Phase Delay
  • Message Buffer Size
  • Message Buffers
  • ObjectStore Release Name
  • Parameter File
  • Preferred Network Receive Buffer Size
  • Preferred Network Send Buffer Size
  • Propagation Buffer Size
  • Propagation Sleep Time
  • Server Major Version
  • Server Minor Version
• Shadow Details dialog
• Signals Received general Server meter
• Specify Sampling Parameters dialog
• Specify Server Name dialog Specify Threshold dialog 149,
• Specify Threshold dialog 149,
• Specify Thresholds dialog
• specify transaction summary
• Specify User Exit dialog
• start command for the application, defining
• Start logging window
• start methods of the Retriever API
• stop methods of the Retriever API
• storage counters
  • See client counters
• Storage Counters/Ratios diagram
  • collapsing information for databases and segments
  • diagram pane
  • expanding information for databases and segments
  • file
  • help
  • options
  • overview
  • pop-up menu
  • refresh while scrolling
  • scale adjuster
  • status line
  • storage scale
  • vertical scroll bar
  • windows
• Storage Details dialog
• storage objects
  • collapsing selected
  • collapsing single database 91,
  • database 91,
  • expanding selected
  • expanding single
  • hiding selected
  • hiding single
  • overview page 91,
  • page 91, segment 91,
  • segment 91,
  • selecting
  • showing selected
  • showing single
• Storage Scale Details dialog
• storing of window element settings
  • See profile for the Analyzer
  • See profile for the Server Monitor
• Succeeded Sectors client meter (all clients)
• suspend methods of the Retriever API
• Swaps general Server meter

T

• thresholds
  • activating
• time axis
  • horizontal scroll bar
  • of the PageState diagram
  • of the Server Monitor
  • of the TimeLine diagram
  • refresh while scrolling
  • vertical zoom box
• time scale, of the TimeLine diagram
• TimeLine diagram
  • counters
  • diagram interval
  • diagram interval box
  • edit
  • event lines

    generic events line

    miscellaneous events line

    trace/transaction events line

  • file
  • find box
  • generic event message area
  • help
  • horizontal scroll bar
  • incremental selection of the diagram interval
  • options
  • overview
  • pop-up menu for

    Client Counters/Ratios diagram

    events

    refresh while scrolling 53,
  • refresh while scrolling 53,
  • status line
  • time axis
  • time indication, absolute or relative
  • time scale
  • time selection area
  • transaction names area
  • vertical zoom box
  • windows
• timeout client counter
• Trace Event Details dialog
• trace file
  • cancelling
  • flush to disk
  • opening and formatting ??-
  • version of written trace file
  Transaction Details dialog 15,
• Transaction Details dialog 15,
• transaction names line
• transaction summary
• transactions
  • naming transactions
  • transaction events
  • transaction summary
  • using transaction macros
• tuning hints on
  • concurrent data access
  • data transfer
  • relocation
• Two Phase Aborts client meter (all clients)
• Two Phase Commits client meter (all clients)
• two-phase locking

U

• unassigned address space
• Unknown page state
• user exit
  • overwiew
  • sample exit
  • specifying

V

• version number of written trace file view interval for Server measurements 125,
• view interval for Server measurements 125,
• Viewing a log file
  • file
  • options
  • pop-up menus

    for diagram cells

    for empty cells

  • status line
  • thresholds
  • windows
• Voluntary Context Switches general Server meter

W

• WF page state
• WL page state