Index

• /etc/hosts file
• /etc/services file
  • multiple residency
• .informix file
  • multiple residency
• $INFORMIXDIR/etc/sqlhosts.
  • See also sqlhosts file.
• .netrc file
  • sqlhosts security options
• .rhosts file

• 64-bit addressing
  • and buffer pool
  • chunk size (1), (2)
  • description

• Accessibility
• Adding end-of-line character
• Adding listen threads
• Adding virtual processors
• ADM (administration) virtual processor
• Administering the database server
• Administrative tasks
  • configuration tasks
  • consistency checking
  • controlling location of storage
  • cron jobs
  • initial tasks
  • list of tasks
  • of database administrator
  • of database server administrator
  • of database server operator
  • planning
  • routine tasks
  • startup and shutdown scripts
  • types of
• AFF_NPROCS parameter
  • description of
  • purpose of
• AFF_SPROC parameter (1), (2)
• Aggregate, parallel processing of
• AIO virtual processors
  • how many
  • NUMAIOVPS parameter
• ALARMPROGRAM parameter
• Aliases.
  • See also DBSERVERALIASES parameter.
• ALL keyword, with DATASKIP
• Allocating
  • cooked file space
• Allocating disk space
  • extent
  • for mirrored data
  • procedure
• Allocating disks
• ALTER DBSLICE, onutil
• ALTER DBSPACE, onutil (1), (2)
• ALTER FRAGMENT statement
  • ATTACH clause
  • Attaching fragments
  • refragmenting tables and dbslices
• ALTER LOGSLICE, onutil
• ALTER TABLE statement
  • mentioned
  • switching table types
• ANSI-compliant transaction logging.
  • See also Logging.
• Application, client.
  • See also Client application.
• Application developer, role of
• Applications, types of
• archecker utility
  • See also Backup and Restore Guide.
  • description
• Archive
  • preparing environment in multiple-residency setting
  • with multiple residency
• ASF.
  • See also Connectivity.
• Assertion failure
  • and data corruption
  • description of
  • determining cause of
  • during consistency checking
  • during processing of user request
  • form in message log
• Assertion failure file
  • af.xxx
  • gcore.xxx
  • list of
  • shmem.xxx
• Asterisk, as wildcard in hostname field
• Asynchronous I/O
  • description of
  • kernel (KAIO)
  • write requests for mirrored data
• ASYNCRQT configuration parameter
• Attaching fragments
• Attaching to shared memory
  • database server utilities
  • description
  • virtual processors
  • virtual processors and key value
• Authentication
  • default policy
  • description of
• Availability
  • and critical data
  • as goal in efficient disk layout
  • improving with fragmentation
  • sample disk layout

• B-tree
  • cleaner thread
• B-tree index.
  • See also Performance Guide.
• Backing up
  • chunks
  • converting table type
  • dbslices (1), (2), (3)
  • dbspaces (1), (2)
  • log files
  • physical log
• Backup
  • active users, and
  • and checkpoints
  • and fragmentation
  • dbspace backup, mentioned
  • description of
  • external
  • reducing size of
  • strategy
  • transaction records
  • verification with archecker
  • verifying
  • with multiple residency
• Bad-sector mapping, absence of (1), (2)
• BAR_DBS_COSVR configuration parameter
• BAR_IDLE_TIMEOUT configuration parameter
• BAR_LOG_COSVR configuration parameter
• BAR_SM configuration parameter
• BAR_SM_NAME configuration parameter
• BAR_WORKER_COSVR configuration parameter
• BAR_WORKER_MAX configuration parameter
• Before-image
  • contents (1), (2)
  • described
  • flushing of
  • in physical log buffer
  • journal.
    • See also Physical log.
  • role in buffer modification
• Big buffers,description of
• Binding CPU virtual processors
  • benefit of
  • parameters
• Bit-map page
  • component of a index tblspace
  • component of a tblspace
• Blobpage
  • free-map page
    • role in tracking blobpages (1), (2)
  • writes, bypassing shared memory
• Blobspace
  • names
• Block device
• Boldface type
• Boot file.
  • See also Startup script.
• Buffer
  • big buffers
  • concurrent access
  • current lock-access level for
  • dirty
  • exclusive mode
  • flushing
  • how a thread accesses a buffer page
  • how a user thread acquires
  • how thread releases after modification
  • least-recently used
  • lock-access level of
  • lock types
  • logical-log buffer (1), (2)
  • monitoring statistics and use of
  • most-recently used
  • not dirty
  • physical-log buffer (1), (2)
  • reading from disk
  • releasing if no thread waiting
  • releasing if thread waiting
  • releasing when modified
  • releasing when not modified
  • share lock
  • status
  • synchronizing flushing
  • threads waiting for
  • what occurs when modified
  • write types during flushing
• Buffer flushing
  • description of
  • how synchronized
• Buffer pool
  • 64-bit addressing
  • bypassed by blobpage data
  • contents of
  • description of
  • flushing
  • full checkpoint
  • fuzzy checkpoint (1), (2)
  • LRU queues management
  • minimum requirement
  • monitoring activity
  • read-ahead
  • size of buffer
  • synchronizing buffer flushing
• Buffer-size option, in options field
• Buffer table
  • contents of
  • description of
  • LRU queues
• Buffered logging, when flushed
• Buffered transaction logging.
  • See also Logging.
• BUFFERS parameter
  • 64-bit addressing
  • description
• BUFFSIZE.
  • See also Page size.
• Built-in data types
  • mentioned
• BYTE data type
  • See also TEXT and BYTE data; Simple large object.

• Cache
  • coordinated data-dictionary
  • shared-memory buffer
    • monitoring
  • SPL routine cache hash size (1), (2)
  • SPL routine cache size
  • SPL routine cachesize
• Calculating size
  • root dbspace
• CAPABILITIES configuration parameter (1), (2)
• Cascading deletes
• Changing the physical schema
• Character-special devices
• Check constraints and reject file (1), (2)
• CHECK RESERVED, onutil
• CHECK SPACE, onutil (1), (2)
• CHECK TABLE ALLOCATION INFO, onutil
• CHECK TABLE INFO, onutil
• Checkpoint
  • and chunk writes
  • and flushing of regular buffers
  • and logical-log buffer
  • and logical-log file
  • and physical-log buffer (1), (2), (3)
  • backup considerations
  • description of (1), (2)
  • events that initiate
  • full (1), (2)
  • fuzzy
  • how it works (1), (2)
  • mentioned
  • monitoring activity
  • role in fast recovery (1), (2)
  • step in shared-memory initialization
• Chunk
  • activity during mirror recovery
  • adding to a dbspace (1), (2)
  • adding with onutil
  • and associated partitions
  • backing up
  • changing mirror chunk status
  • checking status (1), (2), (3)
  • concepts
  • creating a link to the pathname (1), (2), (3), (4)
  • general disk layout guidelines
  • I/O errors during processing
  • limits on size and number
  • maximum number
  • maximum size
  • monitoring (1), (2), (3)
  • multiple residency
  • name, when allocated as raw device
  • recovering a down chunk
  • relation to extent
• Chunk size
  • 64-bit addressing (1), (2)
• Chunk table
  • and mirroring
  • contents of
  • description of
• Chunk write
  • checkpoints
  • monitoring
• CKPTINTVL configuration parameter
• CKPTINTVL parameter
  • description of
  • initiating checkpoints
• Classes of virtual processor
• CLEANERS configuration parameter
• CLEANERS parameter
  • description of
  • purpose of
• Client
  • description of
  • enabling communication
  • finding and connecting to a host
  • loopback connection
  • remote (1), (2)
  • security requirements
  • specifying a dbservername
• Client application
  • testing
  • wildcard addressing
• Client/server architecture, description of
• Client/server configuration
  • example
    • local loopback
    • multiple connection types
    • multiple database servers
    • multiple residency
    • network connection
    • shared memory
    • using IPX/SPX
  • listen and poll threads
  • local loopback
  • shared memory
• Client/server operations, description of
• Code, sample, conventions for
• Code set, ISO 8859-1
• CODESET EBCDIC
• Cogroup
  • changing coservers in
  • defining a new
  • description of
  • modifying
  • system-defined
• cogroup_all
• Cogroups
  • creating user-defined
  • defining
  • using default
• Command-line conventions
  • how to read
  • sample diagram
• COMMIT statement, unbuffered logging
• Communication, client to database server. (1), (2)
  • See also Connectivity., Connectivity.
• Communication configuration file.
  • See also ONCONFIG configuration file.
• Communication support module
  • password encryption (1), (2)
  • sqlhosts option field (1), (2)
• Communication Support Modules
• Communication support services
  • description of
  • message confidentiality
  • message integrity
• Communications portion of shared memory
  • contents of
  • description of
  • how client attaches
  • size of
• Compliance
  • with industry standards
• concsm.cfg file
  • configuring communication support module
  • entry for password encryption
  • format of entries
  • location of
• Concurrency
  • improving with fragmentation
• Concurrency control
• Confidentiality, of communication messages
• CONFIGSIZE configuration parameter
  • and the safewrite area
  • description of
• Configuration
  • coserver-specific parameters (1), (2)
  • dbspaces
  • defining storage managers
  • estimating required disk space
  • global parameters
  • monitoring
  • multiple coservers
  • multiple coservers on a single node
  • multiple coservers on multiple nodes
  • planning for the database server
  • single coserver on a single node
  • single coserver on multiple nodes
  • storage devices
  • UNIX parameters (1), (2)
• Configuration file
  • and multiple residency (1), (2)
  • connectivity
  • onconfig.std
  • warning about not modifying onconfig.std
• Configuration parameter
  • See also AdministratorÕs Reference; Configuration parameter use; and individual parameter names.
  • AFF_NPROCS (1), (2)
  • AFF_SPROC
  • ALARMPROGRAM
  • ASYNCRQT
  • BAR_DBS_COSVR
  • BAR_IDLE_TIMEOUT
  • BAR_LOG_COSVR
  • BAR_SM
  • BAR_SM_NAME
  • BAR_WORKER_COSVR
  • BAR_WORKER_MAX
  • BUFFERS
  • CKPTINTVL (1), (2)
  • CLEANERS
  • CONFIGSIZE (1), (2), (3)
  • COSERVER (1), (2)
  • DATASKIP (1), (2), (3)
  • DBSERVERALIASES
  • DBSERVERNAME (1), (2), (3), (4)
  • DBSPACETEMP (1), (2), (3), (4), (5)
  • DGINFO
  • DUMPCNT
  • DUMPCORE
  • DUMPDIR (1), (2)
  • DUMPGCORE (1), (2)
  • DUMPSHMEM (1), (2)
  • DYNAMIC_LOGS
  • END
  • HADDR
  • IDX_RA_PAGES
  • LADDR
  • LOG_BACKUP_MODE
  • LOGBUFF
  • LRU_MAX_DIRTY
  • LRUS
  • LTXHWM
  • MAX_CHUNKS (1), (2)
  • MAX_DBSLICES (1), (2)
  • MAX_DBSPACES (1), (2)
  • MIRROROFFSET
  • NETTYPE (1), (2)
  • NODE
  • NUMFIFOVPS (1), (2)
  • OFF_RECOVERY_THREADS
  • ON_RECOVERY_THREADS
  • OPTCOMPIND
  • PAGESIZE (1), (2)
  • PC_HASHSIZE (1), (2)
  • PC_POOLSIZE (1), (2)
  • PHYSSLICE
  • RA_PAGES
  • RA_THRESHOLD (1), (2)
  • RESIDENT
  • ROOTOFFSET
  • ROOTSLICE
  • SADDR
  • SENDEPDS
  • SERVERNUM (1), (2)
  • SHMADD (1), (2)
  • SHMBASE (1), (2), (3), (4)
  • SHMTOTAL (1), (2)
  • SHMVIRTSIZE (1), (2)
  • STACKSIZE
• Configuration parameter use
  • and initial chunk of root dbspace
  • for diagnostic information
  • for multiple residency
  • shared memory
• Configuration parameters
  • CAPABILITIES (1), (2)
• Configuring multiple ports
• Configuring the database server
• CONNECT statement
  • example
  • mentioned
• Connecting
  • and multiple residency
  • description of
  • methods
  • to multiple database servers
  • to multiple servers
• Connection
  • database versus network
  • IPX/SPX
  • local loopback, definition of
  • local loopback, example
  • multiple connection types
    • example
  • multiple residency, example
  • multiplexed
  • network, example
  • security restrictions
  • shared memory, description of
  • TCP/IP
• Connection coserver
  • description of
  • for client
• Connection-redirection option
• Connectivity
  • ASF
  • configuration file
  • configuration parameters
• Connectivity file
  • sqlhosts
• Consistency checking
  • corruption of data
  • data and overhead
  • index corruption
  • monitoring for data inconsistency
  • overview
  • periodic tasks
• Console messages (1), (2)
• CONSOLE parameter
  • changing (1), (2)
• Constraint, deferred checking
• Contact information
• Contention.
  • See also Disk contention.
• Context switching
  • description of
  • how functions when OS controls
  • OS versus multithreaded
• Contiguous space for physical log
• Control structures
  • description of
  • queues
  • session control block
  • stacks
  • thread control block
• Conventions
  • documentation
  • syntax diagrams
  • syntax notation
• Conversion
  • data-format
  • during initialization
  • errors during a load (1), (2)
  • optimizing
• Converter threads
• Cooked file space
  • allocating
  • and buffering
  • compared with raw space (1), (2)
  • contiguity of space
  • database server management of
  • description of
  • for static data
  • rationale for using
  • reliability
  • warning
• Cooked files
• Coordinated data-dictionary cache
• Core dump
  • See also DUMPCNT; DUMPDIR; DUMPGCORE; DUMPSHMEM.
  • contents of gcore.xxx
  • when useful
• Corruption
  • corrective actions
  • determining if exists
  • I/O errors from a chunk
  • symptoms of
• Coserver
  • configuring multiple
  • description of
  • monitoring activities
• Coserver configuration
  • multiple coservers on a single node
  • multiple coservers on multiple nodes
  • single coserver on a single node
  • single coserver on multiple nodes
• Coserver group.
  • See also Cogroup.
• Coserver name
• Coserver number
  • part of coserver name
  • prefix in message log
• COSERVER parameter (1), (2)
• Coserver-specific configuration parameters
  • defined
  • examples
• Coservers
  • balancing the load process
  • CAPABILITIES configuration parameter (1), (2)
  • customizing coserver definition
  • defined in ONCONFIG file
  • managing
  • removing specific-purpose
  • specific-purpose
    • disabling
    • enabling
    • removing
    • storage spaces on
  • specifying capabilities (1), (2)
• CPU
  • binding to virtual processor
  • relationship to virtual processor
• CPU virtual processor
  • adding and dropping in online mode
  • AFF_NPROCS parameter
  • AFF_SPROC parameter
  • and poll threads (1), (2), (3)
  • description of
  • how many
  • NUMCPUVPS parameter
  • on a multiprocessor computer
  • on a single-processor computer (1), (2), (3)
  • preventing priority aging
  • types of threads run by
• CREATE DATABASE statement
  • IN dbspace option
• CREATE DBSLICE, onutil
• CREATE DBSPACE, onutil
• CREATE EXTERNAL TABLE statement
  • adding a newline
  • adding an end-of-line character
  • delimited format example (1), (2)
  • deluxe load example
  • EBCDIC format example
  • fixed format example (1), (2)
  • Informix internal format example
  • loading from another database server
  • loading simple large objects
  • mapping columns
  • named-pipes example (1), (2)
  • refreshing a data warehouse table
• CREATE TABLE statement
  • example, defining a fragmented table in a dbslice
  • FRAGMENT BY clause
  • IN dbspace option
  • mentioned
  • newline example
  • row-locking example
  • simple large objects
  • specifying dbslices
  • TEMP
• CREATE TEMP DBSPACE, onutil
• Creating
  • dbspaces
  • fragmented tables
  • temporary dbspaces
• Critical dbspaces
  • mirroring
  • storage of
• Critical media
  • mirroring
• Critical section of code
  • and checkpoints
  • and filling of physical-log buffer
  • description of
• cron jobs, warning about
• CSM

• Data, estimating disk space for
• Data block.
  • See also Page.
• Data consistency
  • fast recovery
  • how achieved
  • monitoring for
  • symptoms of corruption
  • time stamps
  • verifying consistency
• Data definition statements, when logged
• Data dictionary
• Data file, formats (1), (2)
• Data files.
  • See also Logging.
• Data-flow manager
• Data-format conversion
• Data management
• Data manipulation statements, when logged
• Data mart (1), (2)
• Data-recovery mechanisms
  • fast recovery
  • mirroring
• Data replication
  • read-only mode
• Data storage
  • See also Disk space.
  • concepts
  • control of
• Data Type segment
  • See also Disk space.
• Data types
  • built-in, mentioned
• Data warehouse
• Data warehouse tables
  • initial load
  • loading from other database servers
  • refreshing tables
    • continually
    • periodically
• Database
  • description of
  • estimating size of
  • fragmentation
  • location of
  • migration.
    • See also IBM Informix Migration Guide.
  • monitoring (1), (2)
  • purpose of
  • recovery.
    • See also Recovery.
  • size limits (1), (2)
  • tuning.
    • See also Performance tuning.
• Database administrator
  • See also Administrative tasks.
  • role of
• Database I/O
• Database logging status
  • ANSI-compliant, description
  • buffered, description
  • canceling logging
    • using ondblog
  • changes, general info
  • changes permitted
  • changing buffering status
    • using ondblog
  • description of
  • making ANSI-compliant
    • using ondblog
  • modifying
    • using ondblog
  • setting
  • unbuffered, description
  • who can change
• Database schema.
  • See also IBM Informix Migration Guide.
• Database server
  • client/server architecture
  • connecting to multiple (1), (2)
  • fault-tolerant features
  • high performance of
  • maximum number of dbspaces, chunks, or dbslices
  • multiple instances
  • multithreaded (1), (2)
  • remote
  • scalability of
  • security
  • upgrading
• Database server administrator
• Database server name.
  • See also dbservername.
• DATABASE statement, mentioned
• DATAFILES clause
• DATASKIP parameter
  • using (1), (2)
  • with ALL keyword
• DATE and DATETIME values
• DB-Access utility
• DBCENTURY environment variable
• DBEXPORT.
  • See also IBM Informix Migration Guide.
• DBIMPORT.
  • See also IBM Informix Migration Guide.
• DBPATH environment variable
  • and dbserver group
• DBSCHEMA.
  • See also IBM Informix Migration Guide.
• Dbserver group
  • purpose of
• DBSERVERALIAS, TCP/IP connection in (1), (2)
• DBSERVERALIASES parameter
  • and multiple residency
  • description of
  • example
  • in sqlhosts file
  • multiple connection types example
• dbservername
  • field
  • part of coserver name
• DBSERVERNAME, TCP/IP connection in (1), (2)
• DBSERVERNAME configuration parameter
  • coserver name in
  • defining a cogroup
• DBSERVERNAME parameter
  • and multiple residency
  • associated protocol
  • database server ID
  • description of
  • in sqlhosts file
  • multiple residency
  • syntax rules
  • virtual processor for poll thread
• Dbslices
  • advantages of
  • backing up (1), (2), (3)
  • creating
  • creating with onutil
  • description of (1), (2), (3)
  • dropping
  • names
  • onutil utility
  • specifying in DBSPACETEMP parameter
  • temporary
  • temporary dbspaces
• dbspace
  • forcing off-line
  • forcing on-line
• Dbspace
  • adding a chunk
  • as link between logical and physical units of storage
  • backing up (1), (2), (3)
  • configuration
  • creating
  • creating a temporary
  • creating during initial configuration
  • description of
  • dropping a chunk from
  • dropping using onutil
  • initial dbspace
  • mirroring if logical-log files included
  • monitoring simple large objects
  • multiple residency
  • names
  • purpose of
  • role in fragmentation
  • root dbspace defined
  • shared-memory table
  • specific-purpose coservers, required for
  • temporary
• Dbspace table
  • contents of
  • description of
• DBSPACETEMP environment variable (1), (2)
• DBSPACETEMP parameter
  • and load balancing
  • and PSORT_DBTEMP
  • if not set
  • load staging from pipes
  • query threads
  • relationship to DBSPACETEMP environment variable
  • temporary spaces for pipes
• Decision-support application
  • characteristics (1), (2)
  • compared to OLTP
  • definition of
  • uses of (1), (2)
• Decision-support query
  • See also PDQ.
  • DS_MAX_QUERIES parameter
• Default configuration file (1), (2)
• DEFAULT keyword, with SET DATASKIP
• Deferred checking of constraints
• Defining cogroups
• Defining storage managers
• Deleting all the rows in a table
• Delimited format
  • description
  • external column types
  • loading
  • loading simple large objects
  • unloading
  • when to use
• Deluxe-mode load
  • definition of
  • procedure
• Deluxe-mode loads
• Demonstration databases
• Dependencies, software
• Detached index
• Device (1), (2)
  • when offsets are needed
• DGINFO configuration parameter
• Diagnostic information
  • and disk space restraints
  • collecting
  • parameters to set
• Diagnostic messages.
  • See also Message log.
• Dictionary cache
• Dirty buffer, description of
• Disabling I/O error
  • circumstances under which they occur
  • defined
  • destructive versus nondestructive
  • monitoring with event alarms
  • monitoring with message log
• Disk allocation
• Disk configuration
• Disk contention
  • and high-use tables
  • of critical media
  • reducing
• Disk failure
• Disk I/O
  • errors during processing
  • kernel asynchronous I/O
  • logical log
  • operating system I/O
  • physical log
  • priorities
  • queues
  • raw I/O
  • reads from mirror chunks
  • role of shared memory in reducing
  • virtualprocessor classes
  • writes to mirror chunks
• Disk layout
  • and archiving (1), (2)
  • and logical volume managers
  • and mirroring
  • and table isolation
  • for optimum performance (1), (2)
  • sample disk layouts
  • trade-offs
• Disk management
• Disk page
  • before-images in physical log
  • function of time-stamp pairs
  • read ahead
• Disk space
  • allocating cooked file space
  • allocating raw disk space
    • on UNIX
  • caution with multiple residency
  • configuring for multiple residency
  • creating a link to chunk pathname (1), (2), (3)
  • description of
  • estimating size of
  • initialization
    • definition of (1), (2)
    • with new database server
  • layout guidelines
  • limits on due to maximum chunk size (1), (2)
  • multiple residency
  • offsets for chunk pathnames
  • optimizing temporary space layout
  • performance considerations (1), (2)
  • requirements
  • temporary.
    • See also Temporary disk space.
  • tracking usage by tblspace
• Distributed queries
  • shared-memory connection type
• Distribution scheme
• Documentation, types of
  • machine notes
• Documentation Notes
• DROP DBSLICE, onutil
• DROP DBSPACE, onutil
• Dropping
  • dbslices
• DS_MAX_QUERIES parameter
  • description of
• DS_TOTAL_MEMORY parameter
  • description of
• DSA.
  • See also Dynamic Scalable Architecture.
• DSS application.
  • See also Decision-support application.
• DUMPCNT parameter
• DUMPCORE parameter
• DUMPDIR parameter (1), (2)
• DUMPGCORE parameter (1), (2)
• DUMPSHMEM parameter (1), (2)
• DYNAMIC_LOGS configuration parameter
• Dynamic Scalable Architecture
  • advantages
  • description of

• EBCDIC format
  • FORMAT clause
  • loading
  • unloading
• en_us.8859-1 locale
• Encryption, of password
• END parameter
• Environment variable
  • DBCENTURY
  • DBSPACETEMP
  • for users of client applications
  • INFORMIXCONCSMCFG
  • INFORMIXDIR
  • INFORMIXSHMBASE
  • INFORMIXSQLHOSTS
  • ONCONFIG
  • PATH
• Environment variables
  • affecting I/O
  • DBSPACETEMP
  • PSORT_DBTEMP
• Error messages
  • I/O errors on a chunk
• Errors
  • load and unload
  • reject files (1), (2)
  • violations table
• Event alarm
  • description
• Example
  • /etc/services file entry
  • DBSERVERALIASES and sqlhosts file
  • DBSERVERALIASES parameter
  • how page cleaning begins
  • IPX/SPX connection
  • local-loopback connection
  • multiple connection types
  • shared-memory connection
  • TCP/IP connection
• Exchange
• Exclusive lock (buffer), description of
• Explicit temporary table
• Express-mode load
  • definition of
  • procedure
• Express-mode loads
• Expression-based fragmentation scheme
• Extent
  • description
  • how database server allocates (1), (2)
  • initial size
  • key concepts concerning
  • monitoring
  • next-extent size
  • purpose of
  • relationship to chunk
  • structure
• External backup and restore
• External backup and restore.
  • See also Backup and Restore Guide and AdministratorÕs Reference.
• External space.
  • See also Extspace.
• External tables
  • adding end-of-line character
  • adding newline character
  • conceptual diagram
  • data-format conversion
  • description of (1), (2)
  • diagram of load process
  • high-performance loading of data
  • loading
    • from a delimited file
    • from a named pipe
    • simple large objects (1), (2)
    • tables with the same schema
    • to a fixed-ASCII file
    • to an EBCDIC file
  • mapping columns
  • pipe staging
  • temporary table restriction
  • unloading
    • from a named pipe
    • to a delimited file (1), (2)
    • to a fixed-ASCII file
    • to Informix internal format (1), (2)

• Fast recovery
  • description of (1), (2), (3)
  • details of process (1), (2)
  • effects of buffered logging
  • how database server detects need for
  • mentioned (1), (2), (3)
  • no logging
  • purpose of
  • when needed
  • when occurs
• Fast recovery of table types
• Fault tolerance
  • backup verification
  • backups, and
  • fast recovery (1), (2)
  • mirroring
• Features of this product, new
• FIFO (1), (2)
• File
  • configuration
  • connectivity configuration
  • cooked
  • first-in-first-out
  • hosts.equiv
  • network security
  • oncfg_servername.servernum
  • onconfig, during initialization (1), (2)
  • onconfig.std
    • during initialization
  • permissions
  • sqlhosts
• File I/O.
  • See also Disk I/O.
• First-in-first-out
  • virtual processor, FIF
• First-in-first-out data file
• Fixed and Known Defects File
• Fixed-ASCII files
  • adding end-of-line character
  • unloading (1), (2)
• Flex temporary table, description of
• FLRU queues
  • See also LRU queues.
  • and reading a page from disk
  • and releasing buffer
  • description of
• Flushing
  • buffers
  • of before-images
• Forced residency
  • initialization
• Forcing a checkpoint.
  • See also Checkpoint.
• Foreground write
  • and before-image
  • description of
  • monitoring (1), (2)
• Format, definition of
• FORMAT clause
• Formula
  • size of physical log
• Formula, temporary space for pipe staging
• Fragment
  • See also Fragmentation.
  • attaching (1), (2)
  • creating fragmented tables
  • description of
  • monitoring disk usage (1), (2)
  • monitoring I/O requests for
  • skipping
    • selected fragments
    • unavailable fragments
• Fragmentation (1), (2)
  • See also Fragment.
  • and dbslices
  • and mirroring
  • description of
  • distribution schemes for
  • for improved concurrency
  • goals of (1), (2)
  • of temporary tables
  • skipping inaccessible fragments
  • strategy
  • with PDQ
• Full checkpoint
  • description
  • emptying the physical log
  • events that initiate
  • flushing buffer pool (1), (2)
  • forcing
  • last available log
  • oldest update
• Fuzzy checkpoint
  • and logical-log buffer
  • and physical-log buffer
  • definition of
  • description
  • emptying the physical log
  • fast recovery (1), (2)
  • flushing buffer pool (1), (2)
  • flushing buffers
  • flushing the logical-log buffer
  • forcing
  • how it works (1), (2)
  • oldest update
  • physical logging (1), (2)
• Fuzzy operations
  • buffer pool
  • description
  • physical log

• gcore
  • file
• Global configuration parameters (1), (2)
  • defined
• Global Language Support (GLS) (1), (2)
• Global pool, description of
• Group, parallel processing of

• HADDR configuration parameter
• Hash table
  • to buffer table
• Heaps
• Help
• HEX external type
  • definition of
  • SQL example
• Host name, specifying in NODE parameter
• hostname field
  • multiple network interface cards
  • syntax rules
  • using IP addresses
  • wildcard addressing
  • with IPX/SPX
  • with shared memory (1), (2)
• hosts.equiv file
• hosts file
  • multiple residency
  • on UNIX
• Hot site backup.
  • See also Data replication.
• Hybrid distribution scheme
  • definition

• I/O.
  • See also Disk I/O.
• IBM Informix Storage Manager (ISM)
• IDX_RA_PAGES parameter
  • description of
  • purpose of
• Impersonate, client
• Inconsistency information
  • how to detect
• Incremental backup
  • description of
• Index
  • parallel building of
  • tblspace
• Industry standards, compliance with
• Informix internal format
  • and simple large objects
  • description of
  • unloading
• informix.rc environment file
  • multiple residency
• INFORMIXCONCSMCFG environment variable
• INFORMIXDIR
  • directory, number of copies
  • environment variable
    • in shutdown script
    • in startup script
    • multiple residency startup script
• INFORMIXDIR/bin directory
• INFORMIXSERVER environment variable
  • and dbserver group
  • multiple residency startup script
  • multiple versions of the database server
  • with multiple residency
• INFORMIXSHMBASE environment variable (1), (2)
• INFORMIXSQLHOSTS environment variable
• INFORMIXSTACKSIZE environment variable
• Initial configuration
  • creating storage spaces
  • disk layout
  • guidelines for root dbspace
• Initial-extent size
• Initialization
  • checkpoint
  • configuration changes
  • configuration files
  • control returned to user
  • conversion of internal files
  • disk space (1), (2), (3), (4)
    • for multiple residency
  • fast recovery
  • forced residency
  • message log
  • oncfg_servername.servernum file
  • onconfig file
  • onconfig.std file
  • shared memory
  • SMI tables
  • steps in
  • temporary tablespaces
  • virtual processors
• INSERT cursor
• Installation, definition of
• Installation Guides
• Integrity, data.
  • See also Consistency checking.
• Integrity, of communication messages
• Internal format
  • load file type (1), (2)
  • when to use
• Interprocess communications
  • in nettype field
  • shared memory for
• IP address
  • how to find
  • use in hostname field
• IPC.
  • See also Interprocess communications.
• ipcshm protocol and communications portion (shared memory)
• IPX/SPX
  • in hostname field
  • in servicename field
  • multiple residency
  • service, definition of
  • sqlhosts entry
• ISO 8859-1 code set

• Join, parallel processing of

• KAIO thread (1), (2)
• Keep-alive option, in options field
• Kernel asynchronous I/O
  • description of
  • nonlogging disk I/O
• Key value
  • for shared memory
• Keywords
  • in syntax diagrams

• LADDR configuration parameter
• Large objects
  • storage, mentioned
• Latch
  • See also mutex.
  • and wait queue
  • monitoring statistics and use
  • mutex
• Level-0 backup
  • use in consistency checking
• Levels, backup
  • description of
• Light append in flex temporary table
• Light scans
  • mentioned
• Lightweight processes
• Limits
  • chunk size
  • number of chunks (1), (2)
• Links, creating
• LIO virtual processors
  • description of
  • how many
• Listen threads
  • and multiple interface cards
  • description of (1), (2)
• Load balancing
  • as performance goal
  • done by virtual processors
  • of critical media
  • through use of DBSPACETEMP
• Load converter
• Loader threads
• Loading data
  • from external tables
  • methods
• Loading data with external tables
  • balancing the load process across multiple coservers
  • data warehouse table
    • initial load
    • refreshing continually
    • refreshing periodically
  • definition of
  • deluxe-mode procedure
  • diagram
  • express-mode procedure
  • file types and formats
  • from a delimited file
  • from an EBCDIC file
  • from other database servers
  • loading modes
  • monitoring time for
  • named pipes
  • reject file
  • serial columns
  • tables with the same schema
  • to a delimited file
  • to a fixed-ASCII file
  • to an Informix file
  • violations table
• Loading modes
• Local data
• Local index
• Local loopback
  • connection (1), (2)
  • example
  • restriction
• Local table
• Locale
  • en_us.8859-1
• Lock
  • and wait queue
  • description of
  • types
• Lock-access level, of a buffer
• Lock table
  • configuration
  • contents of
  • description
• Locking
  • when occurs
  • when released
• LOG_BACKUP_MODE configuration parameter
• LOGBUFF parameter
  • and logical log buffers
• LOGFILES parameter
  • changing
  • use in logical-log size determination
• Logging
  • See also Database-logging status.
  • activity that is always logged
  • database server processes requiring
  • definition of transaction logging
  • effect of buffering on logical log fill rate
  • monitoring activity
  • physical logging
    • description of
    • process of
    • purpose of
    • sizing guidelines for
    • suppression in temporary dbspaces
  • process for dbspace data
  • suppression for implicit tables
  • table types
  • when to buffer transaction logging
  • when to use logging tables
• Logging table
  • characteristics of
  • types of
• Logical consistency, description of (1), (2)
• Logical log
  • See also Logical-log buffer; Logical-log file.
  • configuration parameters
  • configuring to avoid long transaction hangs
  • description of (1), (2), (3)
  • determining disk space allocated
  • dynamically allocating
  • monitoring for fullness using onstat
  • optimal storage of (1), (2)
  • purpose of
  • setting high-water marks
  • size, guidelines
  • size, performance considerations
  • skipping replay
  • types of records
• Logical-log backup
  • and checkpoints
  • description of
• Logical-log buffer
  • and checkpoints
  • and logical-log records
  • description
  • description of
  • flushing
  • flushing for nonlogging databases
  • flushing when a checkpoint occurs
  • flushing when no before-image
  • flushing with unbuffered logging
  • fuzzy checkpoints
  • monitoring
  • synchronizing flushing
  • when flushed to disk (1), (2)
  • when it becomes full
• Logical-log file
  • See also Logical log.
  • allocating disk space for
  • backing up
  • backup
    • effect on performance
    • goals of
  • changing the size of
  • consequences of not freeing
  • description of (1), (2)
  • file status
  • how to switch
  • I/O to
  • location
  • logid number
  • mirroring a dbspace that contains a file
  • moving to another dbspace
  • number of files
  • rate at which files fill
  • relationship between unique ID and logid
  • role in fast recovery (1), (2), (3), (4), (5)
  • size
  • status flags
  • unique ID number
  • when database server tries to free files
  • when freed for reuse
• Logical-log I/O virtual processors
• Logical-log record
  • database server processes requiring
  • SQL statements that generate
  • when written to logical-log buffer
• Logical units of storage
  • description
  • list of
• Logical volume manager (LVM)
  • description of
  • mirroring alternative
• lognum
• LOGSIZE parameter
  • changing
  • use in logical-log size determination
• Logslice
• Long transaction
  • consequences of
  • description of
  • preventing development of
• LRU_MAX_DIRTY parameter
  • and LRU_MIN_DIRTY parameter
  • description
  • example of use
  • how to calculate value
  • role in buffer-pool management
• LRU_MIN_DIRTY parameter
  • and LRU_MAX_DIRTY parameter
  • default value
  • example of use
  • how to calculate value
  • role in buffer pool management
  • when tested
• LRU queues
  • and buffer pool management
  • components
  • composition of
  • description of
  • FLRU queues (1), (2)
  • how database server selects
  • MLRU queues (1), (2)
  • ordering of
  • rationale for ordering
  • reason for multiple
• LRU write
  • description of
  • monitoring
  • triggering of
  • who performs
• LRUS parameter
  • configuration
  • description of
• LTXEHWM parameter
  • and physical log
  • role in preventing long transactions
• LTXHWM parameter
  • flushing of logical-log buffer
  • role in preventing long transactions

• Machine notes
• Main_loop() thread
• Management of data
• Mapping, bad sector
• Mapping columns in a load
• MAX_CHUNKS configuration parameter
  • description of
• MAX_DBSLICES configuration parameter
  • description of
• MAX_DBSPACES configuration parameter
  • description of
• Maximum size and number of chunks
• Media failure
  • detecting
  • recovering from
  • restoring data
• Memory
  • 64-bit addressing
  • adding a segment
• Memory.
  • See also Shared memory.
• Message log
  • and data corruption
  • description of
  • during initialization
• Migration.
  • See also IBM Informix Migration Guide.
• Mirror chunk
  • changing status of
  • creating
  • disk reads from
  • disk writes to
  • recovering (1), (2)
  • structure
• Mirror dbspace
  • root dbspace
• MIRROR parameter
  • changing
  • description of
  • initial configuration value
• Mirroring
  • activity during processing
  • alternatives
  • and chunk table
  • and multiple residency
  • asynchronous write requests
  • benefits of
  • changing chunk status
  • costs of
  • creating mirror chunks
  • description of (1), (2), (3)
  • detecting media failures
  • during system initialization
  • enabling
  • ending (1), (2)
  • if the dbspace holds logical-log files
  • network restriction
  • recommended disk layout
  • recovering a chunk
  • recovery activity
  • split reads
  • starting (1), (2)
  • status flags
  • steps required
  • what happens during processing
  • when mirroring begins
  • when mirroring ends
• MIRROROFFSET parameter
  • root dbspace
  • when needed
• MIRRORPATH parameter
  • and multiple residency
  • mentioned
  • multiple residency
  • pathname-format
• Miscellaneous (MSC) virtual processor
• mknod UNIX command
• MLRU queues
  • See also LRU queues.
  • and flushing of regular buffers
  • and LRU_MIN_DIRTY parameter
  • description of
  • end of cleaning
  • how buffer is placed
  • how to end page-cleaning
  • limiting number of pages
  • role in buffer modification (1), (2)
• Mode
  • description of
  • graceful shutdown
  • immediate shutdown
  • offline from any mode
  • offline to online
  • offline to quiescent
  • online to quiescent, gracefully
  • online to quiescent, immediately
  • quiescent to online
  • reinitializing shared memory
  • taking offline
• MODE ANSI keywords, and database logging status
• Modifying cogroups
• Monitoring
  • FIFO queues
  • loads and unloads (1), (2)
  • memory size
  • pipe staging
  • SET EXPLAIN ON
• Monitoring database server
  • backup status of logs
  • buffer-pool activity
  • buffers
  • checkpoints
  • chunks
  • configuration parameter values
  • coservers
  • databases (1), (2)
  • disk I/O queues
  • extents
  • fragment load
  • fragmentation disk use (1), (2)
  • latches (1), (2)
  • length of disk I/O queues
  • logging status
  • logical-log buffers
  • logical-log files
  • logs
  • physical-log buffer (1), (2)
  • physical-log file
  • profile of activity
  • shared memory (1), (2)
  • shared-memory segments
  • simple large objects in dbspaces
  • sources of information
  • user threads
  • using onstat
  • using SMI tables
  • virtual processors
• MSGPATH parameter
  • and multiple residency (1), (2)
• Multibyte characters
• Multiple concurrent threads (MCT)
• Multiple connection types
  • See also Connection.
  • example
  • in sqlhosts
• Multiple instances of database server on same computer
• Multiple network interface cards
• Multiple residency
  • and chunk assignment
  • and dbspaces
  • and multiple binaries, warning
  • archiving
  • backups
  • benefits of
  • configuration file
  • configuration parameters
  • DBSERVERNAME parameter
  • definition of (1), (2), (3), (4)
  • editing the ONCONFIG file
  • example (1), (2)
  • hosts and services files
  • how it functions
  • informix.rc & .informix files
  • INFORMIXSERVER environment variable
  • initializing disk space
  • IPX/SPX
  • MIRRORPATH parameter
  • MSGPATH parameter
  • ONCONFIG environment variable
  • planning for
  • requirements
  • ROOTNAME parameter
  • ROOTPATH parameter
  • SERVERNUM parameter
  • sqlhosts
  • startup script
  • to isolate applications
  • use for testing
• Multiplexed connection
  • description of
• Multiprocessor computer
  • advantages on
  • AFF_SPROC parameter (1), (2)
  • MULTIPROCESSOR parameter
  • processor affinity
• MULTIPROCESSOR parameter
  • description of
  • for single-processor computer (1), (2)
• Multithreaded database server.
  • See also Dynamic Scalable Architecture.
• Multithreaded processes, description of (1), (2)
• Multithreading, use of OS resources
• Mutex
  • description of (1), (2)
  • on buffer-table hash table
  • synchronization
  • when used

• Named pipes
  • anonymity of
  • creating with mknod
  • definition of
  • loading
  • unloading
• Names, storage spaces (1), (2)
• nettype field
  • format of
  • summary of values
  • syntax of
  • use of interface type
• NETTYPE parameter
  • and multiple network addresses
  • for multiplexed connection
  • mentioned
  • poll threads
  • purpose of
  • role in specifying a protocol
  • vp class entry
• NetWare file server
• Network communication
  • using IPX/SPX (1), (2), (3)
  • using TCP/IP (1), (2)
• Network connection
  • how implemented
  • types of
• Network Information Service
• Network interface cards
  • and listen threads
  • sqlhosts file
  • using multiple
• Network protocols, specifying
• Network security
  • .netrc file
  • files
  • hosts.equiv
• Network virtual processors
  • and poll threads
  • description of
  • how many
• New features of this product
• Newline character
  • adding
  • delimiter usage
• Next-extent size
• NIS servers, effect on /etc/hosts and /etc/services
• NOAGE parameter
  • purpose of
• Node, description of (1), (2)
• NODE parameter
  • description of
  • obtaining values from the hosts file
  • specifying host name
• Nonfuzzy operations
  • description
  • flushing buffer pool
  • flushing buffers (1), (2), (3)
  • physical log
• Nonlogging table (1), (2)
• NUMAIOVPS parameter
  • purpose of
• NUMCPUVPS parameter
  • and poll threads
  • purpose of
• NUMFIFOVPS parameter
  • description of

• OFF_RECOVERY_THREADS configuration parameter
• Offset
  • definition of
  • purpose of
  • use in prevention of overwriting partition information
  • use in subdividing partitions
  • when needed
• Oldest update, freeing logical-log file (1), (2)
• OLTP application
  • characteristics of (1), (2)
  • definition of
  • uses of (1), (2)
• OLTP applications
  • See also PDQ (parallel database query).
• ON-Bar
  • storage-manager parameters
• ON_RECOVERY_THREADS configuration parameter
• oncfg_servername.servernum file (1), (2)
• ONCONFIG configuration file
  • adding coservers
  • coserver names in
  • during initialization (1), (2)
  • editing to change cogroups
  • editing with multiple residency
  • mentioned
  • multiple residency (1), (2)
  • parameters
• ONCONFIG environment variable
  • changes for multiple residency
  • multiple database servers
  • multiple residency startup script
  • use with multiple residency
• ONCONFIG file parameters.
  • See also Configuration parameter.
• ONCONFIG parameter, and multiple residency
• onconfig.std file
  • during initialization
• ondblog utility
  • modifying database logging status
• oninit utility
  • -p option (1), (2)
  • temporary tables
• Online help
• Online manuals
• Online notes
• Online Notes
• Online transaction processing.
  • See also OLTP applications.
• onload utility.
  • See also IBM Informix Migration Guide.
• onmode utility
  • -a option
  • -O option
  • adding a segment
  • changing shared-memory residency
  • forcing a full checkpoint
  • forcing a fuzzy checkpoint
  • switching logical-log files
  • user thread servicing requests from
• onsmsync utility.
  • See also Backup and Restore Guide.
• onstat utility
  • -g seg option
  • and CPU virtual processors
  • list of configuration parameters
  • monitoring buffer-pool (1), (2), (3)
  • monitoring buffer use (1), (2), (3), (4)
  • monitoring checkpoints
  • monitoring chunk status
  • monitoring configuration
  • monitoring database server profile (1), (2)
  • monitoring fragment load
  • monitoring latches (1), (2)
  • monitoring log buffers
  • monitoring logical-log files (1), (2)
  • monitoring physical log
  • monitoring shared memory (1), (2)
  • monitoring virtual processors
  • options
    • -g ioq (1), (2)
    • -g sql
    • -g xmp
    • -g xqs (1), (2)
• onunload utility.
  • See also IBM Informix Migration Guide.
• onutil
  • CREATE LOG INLINE
  • obtaining fragmentation information
  • setting resident shared-memory parameters
  • setting virtual shared-memory parameters
  • tuning parameters for shared-memory performance
• onutil utility
  • ALTER DBSLICE
  • ALTER DBSPACE (1), (2)
  • ALTER DBSPACE OFFLINE
  • ALTER DBSPACE ONLINE
  • ALTER LOGSLICE
  • changing cogroup with
  • CHECK RESERVED (1), (2)
  • CHECK RESERVED DISPLAY
  • CHECK SPACE (1), (2)
  • CHECK TABLE ALLOCATION INFO
  • CHECK TABLE INFO
  • CREATE COGROUP
  • CREATE DBSLICE (1), (2)
  • CREATE DBSPACE
  • CREATE TEMP DBSPACE
  • description of
  • DROP COGROUP
  • DROP DBSLICE
  • DROP DBSPACE
  • ending mirroring
  • SET DATASKIP ON
  • use in consistency checking
• Operating system, scheduled jobs
• Operating-system files.
  • See also Cooked file space.
• Operating-system parameters
  • description of
• OPERATIONAL table
  • express-mode loads (1), (2), (3)
  • recovery of
• Operational tables
  • altering
  • description of
• OPTCOMPIND
  • description
• OPTCOMPIND environment variable
  • See also OPTCOMPIND parameter.
• Optimizing
  • load performance
• options field
  • buffer-size option
  • keep-alive option
  • security option
  • syntax rules

• Page
  • description
  • least-recently used
  • locating in shared memory
  • most-recently used
  • relationship to chunk
• Page-cleaner table
  • description of
  • number of entries
• Page-cleaner threads
  • alerted during foreground write
  • description of
  • flushing buffer pool
  • flushing of regular buffers
  • monitoring
  • role in chunk write
  • sleeping forever
• PAGE_CONFIG reserved page
  • mentioned (1), (2)
• PAGE_PZERO reserved page
  • mentioned
• Page size
  • configurable
• PAGESIZE configuration parameter
  • description of (1), (2), (3)
• Parallel database query.
  • See also PDQ.
• Parallel processing
  • mentioned (1), (2)
  • virtual processors
• Parallel-processing platform (1), (2)
• Parallelism
  • degree of, definition
  • factors that affect (1), (2)
  • on single coserver
  • when not used
• Parameters
  • used with PDQ
• parameters,setting
  • with a text editor
  • with onutil (1), (2), (3)
• Password encryption (1), (2)
• PATH environment variable
  • in shutdown script
  • in startup script
  • multiple residency startup script
• Pathname-format
  • specifying in MIRRORPATH
  • specifying in ROOTPATH
• PC_HASHSIZE configuration parameter (1), (2)
• PC_POOLSIZE configuration parameter (1), (2)
• PDQ (parallel database query)
  • degree of parallelism
  • description of
  • DS_TOTAL_MEMORY parameter
  • effect of table fragmentation
  • mentioned
  • parameters used to control
  • priority
  • resource allocation
  • scalability
  • used with fragmentation
  • uses of
  • when to use (1), (2)
• PDQ (Parallel Database Query)
  • configuring page size
• Performance (1), (2)
  • See also Performance Guide.
  • and resident shared-memory
  • and shared memory
  • and yielding functions
  • effect of read-ahead
  • effects of VP-controlled context switching
  • how frequently buffers are flushed
  • of CPU virtual processors
  • shared-memory connection
• Performance tuning
  • and extent size
  • and foreground writes
  • and logical volume managers
  • disk-layout guidelines
  • logical-log size
  • LRU write
  • mechanisms
  • minimizing disk-head movement
  • moving the physical log
  • sample disk layout for optimal performance
  • spreading data across multiple disks
  • tuning amount of data logged
• Permissions, file
• PHYSBUFF parameter
  • and physical-log buffers
• PHYSDBS parameter
  • changing size and location
  • where located
• PHYSFILE parameter
  • changing size and location
• Physical consistency
  • description of
  • during fast recover
• Physical consistency, description of
• Physical log
  • and virtual processors
  • backing up
  • becoming full
  • before-image contents
  • buffer
  • changing size and location
    • possible methods
    • rationale (1), (2)
    • restrictions
    • using a text editor
  • contiguous space
  • description of
  • ensuring does not become full
  • flushing of buffer
  • how emptied
  • I/O, virtual processors
  • managing
  • monitoring
  • optimal storage of (1), (2)
  • reinitialize shared memory
  • role in fast recovery (1), (2), (3), (4), (5)
  • scenario for filling
  • sizing guidelines (1), (2)
  • where located
• Physical-log buffer
  • amount written
  • and checkpoints (1), (2)
  • description of
  • events that prompt flushing
  • flushing of (1), (2)
  • mentioned
  • monitoring
  • number of
  • PHYSBUFF parameter
  • role in dbspace logging (1), (2)
  • when it becomes full
• Physical logging
  • activity logged
  • and backups
  • and data buffer
  • and fast recovery
  • description of
  • details of logging process
  • fuzzy checkpoints (1), (2)
  • purpose of
• Physical units of storage, list of (1), (2)
• PHYSSLICE parameter
  • description of
• PIO virtual processors
  • description of
  • how many
• Pipe staging
  • and simple large objects
  • definition
  • illustration
  • using temporary dbspaces
  • xlread operators
• Planning for resources
• Platform, parallel-processing (1), (2)
• Platform-specific configuration parameters (1), (2)
• Point-in-time recovery.
  • See also Backup and Restore Guide.
• Poll threads
  • and message queues
  • DBSERVERNAME parameter
  • description of
  • how many
  • multiple for a protocol
  • nettype entry
  • on CPU or network virtual processors
• Printed manuals
• Priorities for disk I/O
• Priority aging
  • description of
  • preventing
• Privileges
  • on databases and tables
• Processes
  • attaching to shared memory
  • comparison to threads
  • DSA versus dual process architecture
• Processor affinity
  • and AFF_SPROC parameter
  • description of
  • using
• Profile statistics
• Program counter and thread data
• Protocol, specifying
• PSORT_DBTEMP environment variable
• PSWDCSM.
  • See also Password encryption.

• Query plan, XMP section
• Queues
  • description of
  • disk I/O
  • ready
  • sleep
  • wait

• RA_PAGES parameter
  • description of
  • purpose of
  • reading a page from disk
• RA_THRESHOLD parameter
  • description of (1), (2)
• RAID.
  • See also Redundant array of inexpensive disks.
• Raw device
  • and character-special interface
  • definition of
• Raw disk space
  • comparison to cooked space
  • how to allocate, UNIX
  • rationale for using
  • steps for allocating
• RAW table
  • express-mode loads (1), (2), (3)
  • loading from another database server
  • recovery of
• Raw tables
  • altering
  • altering to
  • definition f
• RDBMS.
  • See also Relational database management system.
• Read-ahead
  • description of
  • IDX_RA_PAGES parameter
  • RA_PAGES parameter
  • RA_THRESHOLD parameter (1), (2)
  • when it occurs
  • when used
• Read-only mode, description of
• Ready queue
  • description of
  • moving a thread to (1), (2)
• Recommendations
  • on allocation of disk space
  • on consistency checking
  • on mirroring the physical log
• RECORDEND keyword
• Recovery
  • fast, description of
  • from media failure
  • parallel processing of
• Recovery mode, description of
• Redundant array of inexpensive disks (RAID), mirroring alternative
• Referential constraints
• Referential constraints and violations table
• Refragmenting tables
• Regular buffers
  • events that prompt flushing
  • monitoring status of
• Reject files (1), (2)
• REJECTFILE keyword
• Relational database management system (RDBMS) (1), (2), (3)
• Release Notes
• Remote client (1), (2)
• Remote hosts
• Reserved pages
  • estimating disk space for
  • optimal storage
• Residency.
  • See also Multiple residency.
• RESIDENT parameter
  • during initialization
  • mentioned
• Resident shared memory (1), (2)
  • conditions for
  • contents of
  • description (1), (2)
  • internal tables
• Resource allocation
  • effects of PDQ
• Resource planning
• Restore
  • data
  • external
• RGM (Resource Grant Manager)
  • described
• Roll back
  • in fast recovery (1), (2)
  • mentioned
• Roll forward
  • in fast recovery (1), (2)
  • mentioned
• Root dbspace
  • calculating size of
  • default location
  • description of
  • location of logical-log files
  • mirroring
• ROOTNAME parameter
  • mentioned
  • multiple residency
• ROOTOFFSET parameter
  • mentioned
  • multiple residency
  • when needed
• ROOTPATH parameter
  • and multiple residency
  • mentioned
  • multiple residency
• Rootslice
  • description of
• ROOTSLICE parameter
  • description of
• Round-robin fragmentation
  • distribution scheme

• SADDR configuration parameter
• Safewrite area
  • configuring
• sales_demo database
• Sample-code conventions
• Sbspace
  • names
• Scalability
• Scalability of database server
• Scans
  • of indexes
  • of sequential tables
  • parallel processing of
• Scheduled system jobs
• Scratch tables
  • creating
• Security
  • database server (1), (2)
  • how enforced
  • isolating applications
  • risks with shared-memory communications
• Security option, in options field
• Security options, sqlhosts
• Segment.
  • See also Chunk.
• Segment identifier (shared-memory)
• SENDEPDS configuration parameter
• Serial columns, loading
• SERVERNUM parameter
  • and multiple database servers
  • and multiple residency (1), (2), (3)
  • description of (1), (2)
  • how used
• Servers, database, communicating with other servers (1), (2)
• Service, in IPX/SPX
• servicename
  • syntax rules
• servicename field in sqlhosts file
  • choosing an appropriate name
  • with IPX/SPX
  • with shared memory
  • with stream pipes
• services file
  • multiple residency
• Session
  • and active tblspace
  • and dictionary cache
  • and locks
  • and shared memory
  • and SPL routine cache
  • control block
  • description of
  • primary thread
  • shared-memory pool (1), (2)
  • sqlexec threads
  • threads
• Session control block
  • description of
  • shared memory
• SET DATASKIP ON, onutil
• SET DATASKIP statement (1), (2)
• SET EXPLAIN ON example
• Setting the year
• Share lock (buffer), description of
• Shared data
• Shared memory
  • allocating
  • and blobpages
  • and critical sections
  • and SERVERNUM parameter
  • and SHMBASE parameter
  • attaching additional segments (1), (2)
  • attaching to
  • buffer allocation
  • buffer hash table
  • buffer locks
  • buffer pool (1), (2)
  • buffer table
  • changing residency with onmode
  • checkpoint
  • chunk table
  • communication (1), (2)
  • communications portion
  • configuration (1), (2), (3)
  • configuring for multiple residency
  • contents
  • copying to a file
  • dbspace table
  • description
  • dictionary cache (1), (2)
  • dynamic management of (1), (2)
  • effect of operating-system parameters
  • first segment
  • for interprocess communication
  • global pool
  • header (1), (2)
  • heaps
  • how utilities attach
  • identifier
  • initializing
  • initializing structures
  • internal tables
  • key value (1), (2)
  • locating a page
  • logical-log buffer
  • lower-boundary address problem
  • mirror chunk table
  • monitoring
  • mutex
  • operating-system segments
  • page-cleaner table
  • parameters
  • performance considerations
  • physical-log buffer
  • pools
  • portions
  • purposes of
  • reinitializing
  • resident portion, mentioned
  • segment identifier
  • session control block
  • session data
  • SHMADD parameter
  • SHMTOTAL parameter (1), (2)
  • SHMVIRTSIZE parameter (1), (2)
  • size, displayed by onstat
  • size of virtual portion
  • sorting
  • SPL routine cache
  • stacks
  • STACKSIZE parameter
  • synchronizing buffer flushing
  • tables
  • tblspace table
  • the resident portion
  • thread control block
  • thread data
  • thread isolation and buffer locks
  • transaction table
  • user table
  • virtual portion (1), (2), (3)
• Shared-memory connection
  • example
  • how a client attaches
  • in servicename field
  • message
  • message buffers
  • virtual processor
• SHMADD parameter (1), (2)
• SHMBASE parameter
  • attaching first shared-memory segment (1), (2)
  • description of (1), (2)
  • setting higher
  • warning
• shmem file
  • and assertion failures
• shmkey
  • attaching additional segments
  • description of
• SHMTOTAL parameter (1), (2)
• SHMVIRTSIZE parameter (1), (2)
• Shutdown
  • graceful
  • immediate
  • mode, description of
  • taking offline
• Shutdown script
  • multiple residency
  • steps to perform
• Simple large object
  • See also TEXT and BYTE data.
• Simple large objects
  • loading with external tables (1), (2)
  • pipe staging
• SINGLE_CPU_VP parameter
  • and single processor computer (1), (2), (3)
• Single processor computer
• Sizing guidelines
  • logical log
  • physical log (1), (2)
• Skipping fragments
  • all fragments
  • all unavailable (1), (2)
  • effect on transactions
  • selected fragments
  • when to use feature
• Sleep queues, description of
• Sleeping threads
  • forever
  • types of
• SMI table
  • See also AdministratorÕs Reference; System-monitoring interface.
  • aborted table build
  • during initialization
  • monitoring buffer-pool
  • monitoring buffer use
  • monitoring checkpoints
  • monitoring chunks
  • monitoring databases (1), (2)
  • monitoring fragmentation
  • monitoring latches
  • monitoring log buffer use
  • monitoring logical-log files
  • monitoring shared memory
  • monitoring virtual processors
  • preparation during initialization
• Sockets
  • in nettype field
• Software dependencies
• Sorting
  • and shared memory
  • as parallel process
• SPL routine
  • PC_POOLSIZE parameter
• SPL routine cache
  • specifying hash size (1), (2)
  • specifying size (1), (2)
• Split read
• SQL code
• SQL operator
  • description of
  • scan (1), (2)
• SQL statements
  • ALTER FRAGMENT
  • CREATE DBSPACE
  • CREATE TABLE (1), (2)
  • using temporary disk space
• sqlexec thread
  • and client application
  • as user thread
  • role in client/server connection
• sqlhosts
  • and multiplexed connection
  • CSM option
  • dbservername field
  • keep alive option
  • local-loopback example
  • multiple connection types, example
  • multiple residency
  • network connection example
  • security options
  • shared-memory example
• sqlhosts file
  • adding coservers
  • communication support module option
  • defining multiple network addresses
  • description of
  • end of group option
  • entries for multiple interface cards
  • for initialization
  • group option
  • identifier option
  • mentioned
  • number of copies
  • specifying network poll threads
• Stack
  • and thread control block
  • description of
  • INFORMIXSTACKSIZE environment variable
  • pointer
  • size of
  • STACKSIZE parameter
  • thread
• STACKSIZE parameter
  • changing the stack size
  • description
• STANDARD table
  • deluxe-mode load (1), (2)
  • recovery of
• Standard tables
  • altering
  • altering to
  • description of
• Starting the database server
  • and initializing disk space
• Startup script
  • multiple residency
  • multiple versions of the database server
• STATIC table
  • loading data (1), (2)
  • recovery of
• Static tables
  • altering
  • description of
• Statistics.
  • See also onstat utility.
• Storage devices, setup
• Storage manager
  • ISM
  • parameters
  • role in ON-Bar system
• Stored procedure.
  • See also SPL routine.
• stores_demo database
• Stream-pipe connection
  • in servicename field
• Structured Query Language (1), (2)
  • See also SQL statement.
  • INSERT statement
• Swapping memory
• Switching between threads
• Sync checkpoint.
  • See also Checkpoint.
• Syntax diagrams
  • conventions for
  • keywords in
  • variables in
• Syntax segment
• sysmaster database
  • See also SMI table; System-monitoring interface.
• sysmaster database.
  • See also SMI table.
• System catalog tables
  • and dictionary cache
  • location of
  • optimal storage of
  • sysfragments table
• System-defined hash distribution scheme
  • definition (1), (2), (3), (4)
• System failure, defined
• System-monitoring interface (SMI)
  • See also SMI table.
  • using to monitor database server
• System requirements
  • database
  • software
• System startup script, multiple residency
• System timer

• Table
  • creating temporary
  • description of
  • disk-layout guidelines
  • high-use
  • isolating
  • migration.
    • See also IBM Informix Migration Guide.
  • recommendations for storage
  • relationship to extent
  • storage considerations
  • storage on middle partition of disk (1), (2)
  • temporary
    • cleanup during shared-memory initialization
    • estimating disk space for
    • storage of explicit
    • storage of implicit
• Table fragmentation
• table types
• Table types
  • backing up before converting
• Tables
  • external
  • fast recovery
  • operational (1), (2)
  • raw (1), (2)
  • scratch (1), (2)
  • standard (1), (2)
  • static
  • temp (1), (2)
• Tblspace
  • description of (1), (2)
  • temporary tblspace during initialization
  • types of pages contained in
• Tblspace table
  • contents of
  • description of
• TCP/IP communication protocol
  • in hostname field
  • in servicename field
  • listen port number
  • using (1), (2)
  • using a wildcard
  • using the internet IP address
  • using the TCP listen port number
• TEMP TABLE clause, of CREATE TABLE
• Temp tables
  • creating
• Temporary dbspace
  • and DBSPACETEMP
  • creating
  • description
  • staging of simple large objects
  • temporary dbslices
• Temporary disk space
  • amount required for temporary tables
  • operations requiring
• Temporary table
  • and fragmentation
  • during initialization
  • explicit
  • flexible
  • scratch
  • where stored
• Testing environment
• TEXT and BYTE data
  • See also Simple large object.
  • absence of compression (1), (2)
  • descriptor
  • entering
  • illustration of object storage
  • inserting
  • monitoring in a dbspace
  • writing to a blobpage
  • writing to disk
• TEXT data type
  • See also TEXT and BYTE data.
• Text editor
  • setting performance configuration parameters
  • setting shared-memory parameters (1), (2)
  • setting virtual-processor parameters
• TEXT external type
  • definition of
  • SQL example
• Thread
  • access to resources
  • accessing shared buffers
  • and heaps
  • and stacks
  • concurrency control
  • context of
  • control block (1), (2)
  • coserver
  • description of
  • dynamic allocation of
  • for client applications
  • for primary session
  • for recovery (1), (2)
  • how virtual processors service
  • internal (1), (2)
  • kernel asynchronous I/O
  • main_loop()
  • migrating
  • mirroring
  • multiple concurrent
  • page cleaner (1), (2), (3)
  • relationship to a process (1), (2), (3)
  • scheduling and synchronizing
  • session (1), (2)
  • sleeping (1), (2)
  • switching between
  • user
  • waking up
  • yielding
• Thread control block
  • creation of
  • role in context switching
• Time stamp
  • description of
  • mentioned
  • page-header and page-ending pair
  • role in
    • data consistency
    • flushing physical-log buffer
• TLI.
  • See also Transport-layer interface.
• TOC Notes
• Transaction
  • factors which prevent closure
• Transaction loggin
  • avoiding long transaction hangs
• Transaction logging
  • See also Logging.
  • buffered
  • definition of
  • unbuffered
  • when to use
• Transaction table
  • description of
  • tracking with onstat
• Transport-layer interface
  • in nettype field
• TRUNCATE statement
• Truncating a table
• Types of applications
• Types of buffer writes

• Unbuffered disk access
  • compared to buffered
  • improved I/O
  • raw disk devices
• Unbuffered disk space
  • in data storage
• Unbuffered logging
  • flushing the logical-log buffer
• Unbuffered transaction logging.
  • See also Logging.
• Unique constraints and violations table
• Unique ID
• Units of storage
• UNIX devices
  • creating a link to a pathname
  • displaying links to a pathname (1), (2)
  • ownership, permissions on character-special
• UNIX files
  • ownership, permissions on cooked files
• UNIX operating system
  • default locale for
  • link command (1), (2)
  • shutdown script
• Unloading data
  • from a fixed-ASCII file
  • from Informix internal format
  • named pipes
  • to a delimited file (1), (2)
  • to an Informix file
• Upgrading the database server
• User-defined routines
  • shared-memory location
• User impersonation
• User table
  • description of
  • maximum number of entries
• User thread
  • acquiring a buffer
  • description of
  • in critical sections
  • monitoring
  • tracking
• Users, types of
• Utilities
  • onmode
    • -a option
    • adding a segment
  • onstat
    • -g seg option
• Utility
  • See also AdministratorÕs Reference.
  • attaching to shared-memory

• Variables, in syntax diagrams
• Violations table
  • deferred constraints
  • description of
  • errors
  • referential or unique constraints (1), (2)
• Virtual portion (shared memory)
  • adding a segment
  • configuration
  • contents of (1), (2)
  • global pool
  • SHMVIRTSIZE parameter (1), (2)
  • SPL routine cache
  • stacks
• Virtual processing
  • sharing processing
• Virtual processor
  • access to shared memory
  • adding and dropping
  • ADM class (1), (2)
  • advantages
  • AIO, how many
  • AIO class
  • and context switching
  • and ready queue
  • as multithreaded process (1), (2)
  • attaching to shared memory (1), (2)
  • binding to CPUs
  • classes of (1), (2)
  • coordination of access to resources
  • CPU class
  • description of
  • disk I/O
  • during initialization
  • FIF (first-in-first-out) class
  • how threads serviced
  • LIO, how many
  • LIO class
  • logical-log I/O
  • monitoring
  • moving a thread
  • MSC (miscellaneous) class
  • network (1), (2)
  • number in
    • FIF class
  • number in FIF class (1), (2)
  • parallel processing
  • physical log I/O
  • PIO, how many
  • PIO class
  • setting configuration parameters
  • sharing processing
  • use of stack
• VP class in NETTYPE parameter

• Wait queue
  • and buffer locks
  • description of
• Waking up threads
• Warning
  • files on NIS systems
  • interpreting after running onutil CHECK CATALOG
• Wildcard addressing
  • by a client application
  • example
  • in hostname field
• Write types
  • chunk write
  • foreground write
  • LRU write

• xctl utility
  • description of
  • monitoring logs
• xlc (xload load converter)
• xlcnv (load converter)
• xlr (xload load reader)
• xlread instance
  • and pipe staging (1), (2)
  • coservers
• XMP query plan

• Year 2000 compliance
• Year values
• Yielding threads
  • and ready queue
  • at predetermined point
  • description of
  • on some condition
  • switching between
• ypcat hosts command
• ypcat services command