Setting Configuration Parameters in ON-Monitor

Figure 25 shows which ONCONFIG parameters correspond to the Initialization screen.

Figure 25. Initialization Screen with Parameter Names

                                 DISK PARAMETERS
Page Size     [  2] Kbytes                             Mirror {MIRROR}

Tape Dev.     {TAPEDEV}
Block Size    {TAPEBLK}                     Total Tape Size  {TAPESIZE}
Log Tape Dev. {LTAPEDEV}   
Block Size    {LTAPEBLK}                    Total Tape Size {LTAPESIZE}
Stage Blob    {STAGEBLOB}

Root Name     {ROOTNAME}                           Root Size {ROOTSIZE}
Primary Path  {ROOTPATH}       
                                               Root Offset {ROOTOFFSET}
Mirror Path   {MIRRORPATH}
                                           Mirror Offset {MIRROROFFSET}
Phy. Log Size {PHYSFILE}                        Log. Log Size {LOGSIZE}
                                      Number of Logical Logs {LOGFILES}

Figure 26 shows which ONCONFIG parameters correspond to the Shared-Memory screen.

Figure 26. Shared-Memory Screen with Parameter Names

                        SHARED MEMORY PARAMETERS
 Server Number            {SERVERNUM}            Server Name       {DBSERVERNAME}
 Server Aliases           {DBSERVERALIASES} 
 Dbspace Temp             {DBSPACETEMP}
 Deadlock Timeout         {DEADLOCK_TIMEOUT}   Dbspace Down Option   {ONDBSPACEDOWN}
 Forced Residency         {RESIDENCY}           Number of Page Cleaners {CLEANERS
 Non Res. SegSize (K)     {SHMVIRTSIZE}            Stack Size (K)     {STACKSIZE}
 Heterogeneous Commit     {HETERO_COMMIT}   Optical Cache Size (K)   {OPCACHEMAX}
 Physical Log Buffer Size {PHYSBUFF}       Transaction Timeout        {TXTIMEOUT}
 Logical Log Buffer Size  {LOGBUFF}        Index Page Fill Factor    {FILLFACTOR}
 Max # of Locks           {LOCKS}           Add SegSize                  {SHMADD}
 Max # of Buffers         {BUFFERS}         Total Memory               {SHMTOTAL}

Resident Shared Memory size  [     ] Kbytes              Page Size  [   2] Kbytes

Although Dynamic Server can support a shared memory segment that is larger than 4 gigabytes, ON-Monitor does not support a shared memory segment that is larger than 4 gigabytes. Therefore, the ON-Monitor screen cannot hold values that are larger than 4 gigabytes.

Figure 27 shows which ONCONFIG parameters correspond to the Performance Tuning screen.

Figure 27. Performance Screen with Parameter Names

                     PERFORMANCE TUNING PARAMETERS

Multiprocessor Machine   {MULTIPROCESSOR}    LRU Max Dirty       {LRU_MAX_DIRTY}
Num Procs to Affinity    {VPCLASS aff}       LRU Min Dirty       {LRU_MIN_DIRTY}
Proc num to start with   {VPCLASS num}       Checkpoint Interval     {CKPTINTVL}
                                             Num of Read Ahead Pages  {RA_PAGES}
CPU VPs                  {VPCLASS cpu}       Read Ahead Threshold {RA_THRESHOLD}
AIO VPs                  {VPCLASS aio}
Single CPU VP            {SINGLE_CPU_VP}     NETTYPE settings:
Use OS Time              {USE_OS_TIME}        Protocol Threads Users VP-class
Disable Priority Aging   {VPCLASS noage}      [      ] [     ] [   ] [      ]
Offline Recovery Threads {OFF_RECVRY_THREADS}
Online Recovery Threads  {ON_RECVRY_THREADS} 
Num of LRU queues {LRUS}

Figure 28 shows which ONCONFIG parameters correspond to the Data Replication screen.

Figure 28. Data-Replication Screen with Parameter Names

                        DATA REPLICATION PARAMETERS

 Interval       {DRINTERVAL}
 Timeout        {DRTIMEOUT}
 Lost & Found   {DRLOSTFOUND}

Figure 29. Diagnostics Screen with Parameter Names

                        DIAGNOSTIC PARAMETERS

 Message Log              {MSGPATH}
 Console Msgs.            {CONSOLE}    
 Alarm Program            {ALARMPROGRAM}

 Dump Shared Memory       {DUMPSHMEM}
 Dump Gcore               {DUMPGCORE}
 Dump Core                {DUMPCORE}
 Dump Count               {DUMPCNT}
 Dump Directory           {DUMPDIR}

Figure 30. PDQ Screen with Parameter Names

 PARALLEL DATABASE QUERIES PARAMETERS

 Max PDQ Priority                  {MAX_PDQPRIORITY}
 Decision Support Queries          {DS_MAX_QUERIES}
 Decision Support Memory (Kbytes)  {DS_TOTAL_MEMORY}
 Maximum Decision Support Scans    {DS_MAX_SCANS}
 Dataskip                          {DATASKIP}
 Optimizer Hint                    {OPTCOMPIND}
 Non PDQ Memory                    {DS_NONPDQ_QUERY_MEM}

Figure 31. Create Dbspace Screen

                                                       CREATE DBSPACE

 Dbspace Name [                  ]     Mirror [ ]     Temp [ ]
 Page Size [   2] Kbytes
 PRIMARY CHUNK INFORMATION:         
  Full Pathname [                                                 ]    
             Offset [         0] Kbytes        Size [         0] Kbytes    
      MIRROR CHUNK INFORMATION:        
      Full Pathname [                                                 ]     
            Offset [         0] Kbytes

All tables, indexes, and other allocations within the dbspace use pages of the specified page size. The value for Page Size must be a multiple of the page size of the root dbspace.