Introduction

Configuring and Monitoring Dynamic Server

Configuration Parameters

In This Chapter

ONCONFIG File Conventions

Summary of Configuration Parameters

Archecker Configuration Parameters

ADTERR, ADTMODE, ADTPATH, and ADTSIZE (UNIX)

ALARMPROGRAM

ALLOW_NEWLINE

ALRM_ALL_EVENTS

BLOCKTIMEOUT

BTSCANNER

BUFFERPOOL

CKPTINTVL

CLEANERS

CONSOLE

DATASKIP

DBCREATE_PERMISSION

DB_LIBRARY_PATH

DBSERVERALIASES

DBSERVERNAME

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

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

LTAPEBLK

LTAPEDEV

LTAPESIZE

LTXEHWM

LTXHWM

MAX_INCOMPLETE_CONNECTIONS

MAX_PDQPRIORITY

MaxConnect Configuration Parameters

MIRROR

MIRROROFFSET

MIRRORPATH

MSGPATH

MULTIPROCESSOR

NETTYPE

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

STACKSIZE

STAGEBLOB

STMT_CACHE

STMT_CACHE_HITS

STMT_CACHE_NOLIMIT

STMT_CACHE_NUMPOOL

STMT_CACHE_SIZE

SYSALARMPROGRAM

SYSSBSPACENAME

TAPEBLK

TAPEDEV

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

Disk Structures and Storage

Interpreting Logical-Log Records

Administrative Utilities

Overview of Utilities

The oncheck Utility

The ondblog Utility

The oninit Utility

The onlog Utility

Changing Modes and Shared Memory with the onmode Utility

The ON-Monitor Utility

The onparams Utility

Managing Storage Spaces with the onspaces Utility

The onstat Utility

The ontape Utility

Appendixes

Appendix A. Files That the Database Server Uses

Appendix B. Trapping Errors

Appendix C. Event Alarms

Appendix D. Discontinued Configuration Parameters

Appendix E. Error Messages

Appendix F. Accessibility

Notices

Index