Home | Previous Page | Next Page

Contents

About This Manual

Software Dependencies

Assumptions About Your Locale

Demonstration Databases

Documentation Conventions

Typographical Conventions

Feature, Product, and Platform

Syntax Diagrams

Example Code Conventions

Additional Documentation

Installation Guides

Informix Error Messages

Compliance with Industry Standards

IBM Welcomes Your Comments

Database Reference

Configuration Parameters

ONCONFIG File Conventions

Format of ONCONFIG File

ONCONFIG File Templates

ONCONFIG Parameters

Summary of Configuration Parameters

Parameter Attributes

Using a Utility to Change a Parameter Value

BUFFERS and Read-Ahead

System Page Size

Datagram Configuration Parameters

DBS_USED_THRESHOLD

DBSERVERALIASES

DEADLOCK_TIMEOUT

DS_TOTAL_MEMORY

Algorithm for DS_TOTAL_MEMORY

IDX_RA_THRESHOLD

ISM_DATA_POOL and ISM_LOG_POOL

ISOLATION_LOCKS

LOG_BACKUP_MODE

System Page Size

LOGSIZE for Extended Parallel Server

MAX_PDQPRIORITY

Setting Permissions

Number of Poll Threads

Number of Connections

Class of Virtual Processor

OFF_RECVRY_THREADS

ON_RECVRY_THREADS

ON-Bar Parameters

System Page Size

PLAN_MONITORING

SYSALARMPROGRAM

XMF Configuration Parameters

The sysmaster Database

The sysmaster Database

The buildsmi Script

The bldutil.sh Script

The System-Monitoring Interface

Understanding the SMI Tables

Accessing SMI Tables

The System-Monitoring Interface Tables

The sysutils Tables

Backup Scheduler Tables

syscogroupmembers

The SMI Tables Map

Information from onstat in the SMI Tables

Message-Log Messages

How the Messages Are Ordered in This Chapter

How to View These Messages

Message Categories

Messages: D-E-F

Messages: G-H-I

Messages: J-K-L-M

Messages: N-O-P

Messages: Q-R-S

Messages: T-U-V

Messages: W-X-Y-Z

Messages: Symbols

Violations Table Messages

Truncate Table Messages

Interpreting Logical-Log Records

About Logical-Log Records

Transactions That Drop a Table or Index

Transactions That Are Rolled Back

Checkpoints with Active Transactions

Distributed Transactions

Logical-Log Record Structure

Logical-Log Record Header

Logical-Log Record Types and Additional Columns

Disk Structures and Storage

Dbspace Structure and Storage

Structure of the Root Dbspace

Structure of a Regular Dbspace

Structure of a Mirror Chunk

Structure of the Chunk Free-List Page

Structure of the Tblspace Tblspace

Structure of the Database Tblspace

Structure and Allocation of an Extent

Structure and Storage of a Dbspace Page

Structure of Fragmented Tables

Structure of B-Tree Index Pages

Structure of Bitmap Indexes

Storage of Simple Large Objects

Structure of a Dbspace Blobpage

Simple-Large-Object Storage and the Descriptor

Database and Table Creation: What Happens on Disk

Database Creation

Utility Reference

ondblog: Change Logging Mode

oninit: Initialize the Database Server

Initialize Shared Memory Only

Initialize Disk Space and Shared Memory

onlog: Display Logical-Log Contents

Log-Record Read Filters

Log-Record Display Filters

onmode: Change Mode and Shared Memory

Change Database Server Mode

Force a Checkpoint

Switch the Logical-Log File

Kill a Database Server Session

Kill a Distributed Transaction

Determining the Global Transaction Id

Add a Shared-Memory Segment

Add or Remove Virtual Processors

Regenerate .infos or .infxdirs File

Change Decision-Support Parameters

Free Unused Memory Segments

Override ONDBSPACEDOWN WAIT Mode

Setting the Mutability Property in an Active Session

onstat: Monitor Database Server Operations

Onstat Output Header

Logs Full Subheader

The onstat -- Option

The onstat -a Option

The onstat -b Option

The onstat -c Options

The onstat -d Option

The onstat -D Option

The onstat -f Option

The onstat -F Option

The onstat -g Monitoring Options

onstat -g afr pool name | session name

onstat -g bus_sm

onstat -g dic table

onstat -g ffr pool name | session id

onstat -g ioq queue name

onstat -g mem pool name | session id

onstat -g mut session id

onstat -g nsc client_id

onstat -g nss session id

onstat -g ppf partition number | 0

onstat -g ses session id

onstat -g sql session id

onstat -g stk tid

onstat -g xmp [query_id]

onstat -g xqs query_id

The onstat -G Option

The onstat -i Option

The onstat -k Option

The onstat -K Option

The onstat -l Option

The onstat -m Option

The onstat -p Option

The onstat -P Option

The onstat -R Option

The onstat -s Option

The onstat -t Option

The onstat -u Option

The onstat -x Option

The onstat -X Option

The onstat -z Option

onutil: Check, Define, and Modify Storage Objects

Overview of onutil Commands

How to Invoke onutil

Displaying Usage for Specific Keywords

Using the onutil CHECK Options

Using the onutil ALTER, CREATE, and DROP Commands

Identifiers in onutil Commands

ALTER DBSLICE ADD DBSPACE

Change Status of a Mirrored Chunk

Change Dbspace Status

Toggling The Read Mode of a dbspace

Start Mirroring

Change the Dbspace Usage Threshold

ALTER LOGSLICE ADD LOGS

CHECK INDEX KEYS WITH DATA

CREATE LOGICAL LOG

CREATE LOGICAL LOGSLICE

DROP LOGICAL LOG

Thread Suspension

xctl: Execute Utilities Across Coservers

Appendix A. Files That the Database Server Uses

Appendix B. Trapping Errors

Appendix C. Event Alarms

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]