Home | Previous Page | Next Page Administrative Utilities >

Changing Modes and Shared Memory with the onmode Utility

In This Chapter

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

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