Home
|
Previous Page
|
Next Page
Contents
Introduction
In This Introduction
About This Manual
Types of Users
Software Dependencies
Assumptions About Your Locale
Demonstration Database
New Features in Dynamic Server, Version 10.0
Features From Previous Versions
Features From Dynamic Server, Version 9.4
Features From Dynamic Server, Version 9.3
Features From Dynamic Server, Version 9.21
Documentation Conventions
Typographical Conventions
Feature, Product, and Platform Markup
Syntax Diagrams
Example Code Conventions
Additional Documentation
IBM Informix Information Center
Installation Guides
Online Notes
Informix Error Messages
Manuals
Online Help
Accessibility
IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set
Compliance with Industry Standards
IBM Welcomes Your Comments
Configuring and Monitoring Dynamic Server
Configuration Parameters
In This Chapter
ONCONFIG File Conventions
Format of ONCONFIG File
ONCONFIG File Templates
Printing the onconfig.std File
Specifying Hidden Configuration Parameters
Displaying ONCONFIG Settings
Summary of Configuration Parameters
Parameter Attributes
Using a Utility to Change a Parameter Value
Environment Variables
Archecker Configuration Parameters
ADTERR, ADTMODE, ADTPATH, and ADTSIZE (UNIX)
ALARMPROGRAM
ALLOW_NEWLINE
ALRM_ALL_EVENTS
BLOCKTIMEOUT
BTSCANNER
BUFFERPOOL
The lrus Field
The buffers Field
The lru_min_dirty Field
The lru_max_dirty Field
The size Field
System Page Size
CKPTINTVL
CLEANERS
CONSOLE
DATASKIP
4
4
DBCREATE_PERMISSION
4
4
DB_LIBRARY_PATH
DBSERVERALIASES
DBSERVERNAME
DBSPACETEMP
Using Hash Join Overflow and DBSPACETEMP
DD_HASHMAX
DD_HASHSIZE
DEADLOCK_TIMEOUT
DEF_TABLE_LOCKMODE
DIRECTIVES
DISABLE_B162428_XA_FIX
DRIDXAUTO
DRAUTO
DRINTERVAL
DRLOSTFOUND
DRTIMEOUT
DS_HASHSIZE
DS_MAX_QUERIES
DS_MAX_SCANS
DS_NONPDQ_QUERY_MEM
DS_POOLSIZE
DS_TOTAL_MEMORY
Algorithm for DS_TOTAL_MEMORY
DUMPCNT (UNIX)
DUMPCORE (UNIX)
DUMPDIR
DUMPGCORE (UNIX)
DUMPSHMEM (UNIX)
DYNAMIC_LOGS
Enterprise Replication Configuration Parameters
EXT_DIRECTIVES
EXTSHMADD
FAST_RESTART_CKPT_FUZZYLOG
FAST_RESTART_PHYSLOG
FILLFACTOR
HETERO_COMMIT
IFX_EXTEND_ROLE
ISM_DATA_POOL and ISM_LOG_POOL
Java Configuration Parameters
LISTEN_TIMEOUT
LOCKS
LOGBUFF
LOGFILES
LOGSIZE
LOGSIZE for Smart Large Objects
LTAPEBLK
LTAPEDEV
LTAPESIZE
LTXEHWM
LTXHWM
MAX_INCOMPLETE_CONNECTIONS
MAX_PDQPRIORITY
MaxConnect Configuration Parameters
MIRROR
MIRROROFFSET
MIRRORPATH
Setting Permissions (UNIX)
MSGPATH
MULTIPROCESSOR
NETTYPE
Protocol
Number of Poll Threads
Number of Connections
Class of Virtual Processor
Default Values
Multiplexed Connections
IBM Informix MaxConnect
OFF_RECVRY_THREADS
ON_RECVRY_THREADS
ON-Bar Configuration Parameters
ONDBSPACEDOWN
ONLIDX_MAXMEM
OPCACHEMAX (UNIX)
OPTCOMPIND
OPT_GOAL
PC_HASHSIZE
PC_POOLSIZE
PHYSBUFF
PHYSDBS
PHYSFILE
PLOG_OVERFLOW_PATH
RA_PAGES
RA_THRESHOLD
RESIDENT
RESTARTABLE_RESTORE
ROOTNAME
ROOTOFFSET
ROOTPATH
ROOTSIZE
SBSPACENAME
SBSPACETEMP
SECURESTATG
SECURITY_LOCALCONNECTION
SERVERNUM
SHMADD
SHMBASE
SHMTOTAL
SHMVIRTSIZE
SINGLE_CPU_VP
User-Defined VP Classes and SINGLE_CPU_VP
STACKSIZE
STAGEBLOB
STMT_CACHE
STMT_CACHE_HITS
STMT_CACHE_NOLIMIT
STMT_CACHE_NUMPOOL
STMT_CACHE_SIZE
SYSALARMPROGRAM
SYSSBSPACENAME
TAPEBLK
TAPEDEV
Using Symbolic Links and a Remote Device (UNIX)
Rewinding Tape Devices Before Opening and on Closing
TAPESIZE
TBLSPACE_STATS
TBLTBLFIRST
TBLTBLNEXT
TXTIMEOUT
USEOSTIME
VPCLASS
Default Values for the VPCLASS Options
Interaction of VPCLASS with Other Configuration Parameters
VPCLASS Name
Creating a User-Defined Class
Using the noyield Option
Using the num Option
Using the max_VPs Option
Using the affinity Option
The sysmaster Database
In This Chapter
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
sysadtinfo
sysaudit
syschkio
syschunks
sysconfig
sysdatabases
sysdbslocale
sysdbspaces
sysdri
sysextents
sysextspaces
syslocks
syslogs
sysprofile
sysptprof
syssesprof
syssessions
sysseswts
systabnames
sysvpprof
The SMI Tables Map
Information from onstat in the SMI Tables
Disk Structures and Storage
In This Chapter
Dbspace Structure and Storage
Structure of the Root Dbspace
Reserved Pages
Structure of a Regular Dbspace
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 R-Tree Index Pages
Storage of Simple Large Objects
Structure of a Blobspace
Structure of a Dbspace Blobpage
Simple-Large-Object Storage and the Descriptor
Blobspace Page Types
Structure of a Blobspace Blobpage
Sbspace Structure
Structure of the Metadata Area
Sbpage Structure
Multiple Chunk Sbspace
Time Stamps
Database and Table Creation: What Happens on Disk
Database Creation
Table Creation
Interpreting Logical-Log Records
In This Chapter
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
Log Record Types for Smart Large Objects
Administrative Utilities
Overview of Utilities
In This Chapter
Complete List of Utilities
Obtaining Utility Version Information
Multibyte Characters (GLS)
IBM Informix Server Administrator
Server Studio JE
The oncheck Utility
In This Chapter
oncheck Check-and-Repair Options
What Does Each Option Do?
Using the -y Option to Perform Repairs
Repairing Fragmented Tables
Repairing Indexes in Sbspaces and External Spaces
Locking and oncheck
Syntax
Check System Catalog Tables with -cc
Check Pages with -cd and -cD
Check the Chunk Free List with -ce and -pe
Check Index Node Links with -ci and -cI
Check Reserved Pages with -cr and -cR
Check and Display Sbspaces with -cs, -cS, -ps, -pS
Display Blobspace Statistics with -pB
Display Rows in Hexadecimal Format with -pd and -pD
Display Index Information with -pk, -pK, -pl, -pL
Display the Contents of a Logical Page with -pp and -pP
Display Reserved-Page Information with -pr and -pR
Display Tblspaces for a Table or Fragment with -pt and -pT
Turn On Locking with -x
Send Special Arguments to the Access Method with -u
Return Codes on Exit
The ondblog Utility
ondblog: Change Logging Mode
Syntax
The oninit Utility
oninit: Initialize the Database Server
Syntax
Initialize Shared Memory Only
Initialize Disk Space and Shared Memory
Specify the Number of Virtual Processors
The onlog Utility
onlog: Display Logical-Log Contents
Syntax
Log-Record Read Filters
Log-Record Display Filters
Changing Modes and Shared Memory with the onmode Utility
In This Chapter
onmode Syntax
Allow Large Chunk Mode
Change Database Server Mode
Taking the Database Server to Offline Mode with the -k Option
Bringing the Database Server Online with the -m Option
Shutting Down the Database Server Gracefully with the -s Option
Shutting Down the Database Server Immediately with the -u Option
Changing the Mode of the Database Server to Single-user with the -j Option
Changing Database Server Mode with ON-Monitor (UNIX)
Force a Checkpoint
Control the B-tree Scanner
Change Shared-Memory Residency
Switch the Logical-Log File
Kill a Database Server Session
Kill a Distributed Transaction
Set Data-Replication Types
Using the -d standard Option
Using the -d primary dbservername Option
Using the -d secondary dbservername Option
Replicate an Index with Data-Replication
Add a Shared-Memory Segment
Add or Remove Virtual Processors
Adding and Dropping Virtual Processors
Dropping Virtual Processors Automatically
Monitoring Poll Threads with onstat
Regenerate .infos File
Change Decision-Support Parameters
Free Unused Memory Segments
Override ONDBSPACEDOWN WAIT Mode
Change Usage of the SQL Statement Cache
Change Settings for the SQL Statement Cache
SQL Statement Cache Examples
Dynamically Setting of SET EXPLAIN
Dynamically Change Certain Connection, PDQ, and Memory Parameters
The ON-Monitor Utility
Using ON-Monitor (UNIX)
Navigating ON-Monitor and Using Help
Executing Shell Commands Within ON-Monitor
ON-Monitor Screen Options
Setting Configuration Parameters in ON-Monitor
The onparams Utility
In This Chapter
Syntax
Add a Logical-Log File
Drop a Logical-Log File
Change Physical-Log Parameters
Backing Up After You Change the Physical-Log Size or Location
Changing the Size of the Physical Log and Using Non-Default Page Sizes
Using a Text Editor to Change the Physical-Log Size or Location
Add a New Buffer Pool
Examples of onparams Commands
Managing Storage Spaces with the onspaces Utility
In This Chapter
onspaces Syntax
Create a Dbspace or Temporary Dbspace
Creating a Temporary Dbspace with the -t Option
Specifying First and Next Extent Size for the tblspace tblspace
Specifying a Non-Default Page Size with the Same Size as the Buffer Pool
Create a Blobspace
Create an Extspace
Create an Sbspace or Temporary Sbspace
Creating a Temporary Sbspace with the -t Option
Creating an Sbspace with the -Df option
Changing the -Df Settings
Using the onspaces -g Option
Change Sbspace Default Specifications
Clean Up Stray Smart Large Objects in Sbspaces
Drop a Dbspace, Blobspace, Sbspace, or Extspace
Rename a Dbspace, Blobspace, Sbspace, or Extspace
Renaming a Dbspace, Blobspace, Sbspace, or Extspace when Enterprise Replication Is Active
Performing an Archive after Renaming a Space
Add a Chunk to a Dbspace or Blobspace
Add a Chunk to an Sbspace
Drop a Chunk in a Dbspace, Blobspace, or Sbspace
Start Mirroring
Using a File to Specify Chunk-Location Information with the -f Option
End Mirroring
Change Status of a Mirrored Chunk
Specify DATASKIP Parameter
The onstat Utility
In This Chapter
Monitor the Database Server Status
Syntax
Statistics Culled from Source File
Interactive Execution
Continuous onstat Execution
Output Header
Logs Full Subheader
onstat
onstat --
onstat -a
onstat -b
onstat -c
onstat -C
onstat -d
Using onstat -d with Sbspaces
Using onstat -d with Blobspaces
onstat -D
onstat -f
onstat -F
onstat -g Monitoring Options
The onstat -g act Option
The onstat -g afr pool name | session id Option
The onstat -g ath Option
The onstat -g cat Option
The onstat -g con Option
The onstat -g ddr Option
The onstat -g dic table Option
The onstat -g dis Option
The onstat -g dll Option
The onstat -g dri Option
The onstat -g dsc Option
The onstat -g dss Option
The onstat -g dtc Option
The onstat -g env Option
The onstat -g ffr pool name | session id Option
The onstat -g glo Option
The onstat -g grp Option
The onstat -g ioa Option
The onstat -g iob Option
The onstat -g iof Option
The onstat -g iog Option
The onstat -g ioq queue name Option
The onstat -g iov Option
The onstat -g lmx Option
The onstat -g mem pool name | session id Option
The onstat -g mgm Option
The onstat -g nbm Option
The onstat -g nif Option
The onstat -g nsc client_id Option
The onstat -g nsd Option
The onstat -g ntd Option
The onstat -g ntm Option
The onstat -g ntt Option
The onstat -g ntu Option
The onstat -g pos Option
The onstat -g ppf partition number | 0 Option
The onstat -g prc Option
The onstat -g que Option
The onstat -g rbm Option
The onstat -g rcv Option
The onstat -g rea Option
The onstat -g rep Option
The onstat -g rqm Option
The onstat -g rwm Option
The onstat -g sch Option
The onstat -g seg Option
The onstat -g ses Option
The onstat -g sle Option
The onstat -g sql Option
The onstat -g ssc Option
The onstat -g stk tid Option
The onstat -g stm Option
The onstat -g sts Option
4
4
The onstat -g sync Option
The onstat -g tpf tid Option
The onstat -g wmx Option
onstat -G
onstat -i
onstat -j
onstat -k
onstat -l
onstat -m
onstat -O
onstat -p
onstat -P
onstat -R
onstat -s
onstat -t and -T
onstat -u
onstat -x
Determining the Position of a Logical-Log Record
Determining the Mode of a Global Transaction
onstat -X
onstat -z
Return Codes on Exit
The ontape Utility
ontape: Log, Back Up, and Restore
Syntax
Appendixes
Appendix A. Files That the Database Server Uses
Database Server Files
Descriptions of Files
af.xxx
ac_msg.log
ac_config.std
bar_act.log
bldutil.process_id
buildsmi.xxx
concdr.sh
.conf.dbservername
core
Emergency Boot Files for ON-Bar
gcore.xxx (UNIX)
illlsrra.xx
~/.informix
informix.rc (UNIX)
INFORMIXTMP
.inf.servicename
.infos.dbservername
.infxdirs
InstallServer.log (Windows)
ISM Catalog
ISM Logs
ISMversion
JVM_vpid
JVPLOG
.jvpprops
Message Log
onconfig.std
The ONCONFIG File
onconfig
oncfg_servername.servernum
onsnmp.servername
onsrvapd.log
revcdr.sh
shmem.xxx (UNIX)
sm_versions.std
snmpd.log
sqlhosts
VP.servername.nnx
xbsa.messages
Appendix B. Trapping Errors
Collecting Diagnostics using onmode -I
Syntax
Creating Tracepoints
Appendix C. Event Alarms
Using ALARMPROGRAM to Capture Events
Setting ALRM_ALL_EVENTS
Writing Your Own Alarm Script
Customizing the ALARMPROGRAM scripts
Interpreting Error Messages
Event-Alarm Parameters
Event Severity
Event Class ID
Class Message
Specific Messages
See Also Paths
Event Alarms on Dynamic Server
Appendix D. Discontinued Configuration Parameters
AFF_NPROCS
AFF_SPROC
BUFFERS
LBU_PRESERVE
LOGSMAX
LRU_MAX_DIRTY
LRU_MIN_DIRTY
LRUS
NOAGE
NUMAIOVPS
NUMCPUVPS
Appendix E. Error Messages
How the Messages Are Ordered in This Chapter
How to View These Messages
Message Categories
Messages: A-B
Messages: C
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
Conversion/Reversion Messages
Messages: A-C
Messages: D-F
Messages: I-P
Messages: R-W
Conversion and Reversion Messages for Enterprise Replication
Dynamic Log Messages
Sbspace Metadata Messages
Truncate Table Messages
Appendix F. Accessibility
Notices
Index
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]