[ 永遠的UNIX > Informix動態服務器配置--5.數據庫的初始化 ]

[ 永遠的UNIX::UNIX技術資料的寶庫 ] GB | BIG5

首頁 > 數據庫 > Informix > 正文

Informix動態服務器配置--5.數據庫的初始化

本文出自: http://yulu.163.net/ (2001-06-12 20:10:00)

    以用戶informix登錄，通過運行命令onmonitor或使用文本編輯器修改$INFORMIXDIR/etc/$ONCONFIG文件兩種方法來達到初始化數據庫的目的。

    下面只就onmonitor方式進行介紹。

首先，以informix登錄，

    $ onmonitor

       敲“P” 進Parameters子菜單，再敲“I”進入INITALIZATION初始化屏幕，此屏幕的每回操作都會破壞性摧毀指定數據庫中的數據，操作一定要慎重，如下：

INITIALIZATION: Make desired changes and press ESC to record changes.
  Press Interrupt to abort changes.  Press F2 or CTRL-F for field-level help.
                                DISK PARAMETERS
Page Size     [    2] Kbytes                                  Mirror [N]
Tape Dev.     [/dev/null                                               ]
Block Size    [        16] Kbytes           Total Tape Size [     10240] Kbytes
Log Tape Dev. [/dev/null                                               ]
Block Size    [        16] Kbytes           Total Tape Size [     10240] Kbytes
Stage Blob    [                  ]
Root Name     [rootdbs            ]                            Root Size [    200000] Kbytes
Primary Path [/usr/icbdb/rootdbs                                       ]
                                                                              Root Offset [          0] Kbytes
Mirror Path   [                                                         ]
                                                                              Mirror Offset [         0] Kbytes
Phy. Log Size [      3000] Kbytes                         Log. Log Size [      1500] Kbytes
                                                                             Number of Logical Logs [    6]

    確認以上輸入無誤，鍵入ESC鍵，如果指定設備不存在或權限有問題，報錯並會停在相應的位置上。對操作系統文件形式的rootdbs時，如果該文件大小小你設定的值，系統還會對相應文件進行初始化，使之達到所要求的空間。完成上屬操作，系統顯示如下畫面來設置共享內存。共享內存參數的修改可以多次進行，不會毀壞數據庫的內容。

SHARED MEMORY: Make desired changes and press ESC to record changes.
  Press Interrupt to abort changes.  Press F2 or CTRL-F for field-level help.
                        SHARED MEMORY PARAMETERS
Server Number                    [     0]       Server Name [hbsave            ]
Server Aliases [                                                             ]
Dbspace Temp   [                                                             ]
Deadlock Timeout                 [   60] Secs  Number of Page Cleaners   [   1]
Forced Residency                    [N]        Stack Size (K)             [  32]
Non Res. SegSize (K)         [   8000]        Optical Cache Size (K) [       0]

                                              Dbspace Down Option          [2]
                                              Preserve Log For Log Backup  [N]
Heterogeneous Commit                [N]        Transaction Timeout        [ 300]
Physical Log Buffer Size  [        32] K      Long TX HWM                [   50]
Logical Log Buffer Size   [        32] K      Long TX HWM Exclusive     [  60]
Max # of Logical Logs           [   12]        Index Page Fill Factor    [  90]
Max # of Locks             [      50000]       Add SegSize (K)        [    8192]
Max # of Buffers           [       2000]       Total Memory (K)       [       0]

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

鍵入ESC，完成共享內存參數修改，進入性能如下調整菜單，主要針對多CPU的機器設置虛擬機和設置NETTYPE：

PERFORMANCE: Make desired changes and press ESC to record changes.
  Press Interrupt to abort changes.  Press F2 or CTRL-F for field-level help.
                     PERFORMANCE TUNING PARAMETERS

Multiprocessor Machine      [N]     LRU Max Dirty             [ 60]
   Num Procs to Affinity   [  0]     LRU Min Dirty             [ 50]
   Proc num to start with  [  0]     Checkpoint Interval      [ 300]
                                     Num of Read Ahead Pages   [   ]
CPU VPs                   [  1]     Read Ahead Threshold      [   ]
AIO VPs                   [   ]
Single CPU VP               [N]     NETTYPE settings:
Use OS Time                 [N]       Protocol Threads Users VP-class
Disable Priority Aging      [N]       [tlitcp] [  2]   [  5] [CPU]
Off-Line Recovery Threads [ 10]       [      ] [   ]   [   ] [   ]
On-Line Recovery Threads  [  1]       [      ] [   ]   [   ] [   ]
Num of LRUS queues        [  8]       [      ] [   ]   [   ] [   ]

完成鍵入ESC，進入數據復制設置畫面：

DATA REPLICATION: Make desired changes and press ESC to record changes.
  Press Interrupt to abort changes.  Press F2 or CTRL-F for field-level help.
                        DATA REPLICATION PARAMETERS

Interval       [  30]
Timeout        [  30]
Auto           [0]
Lost & Found   [/usr/informix/etc/dr.lostfound                          ]

完成鍵入ESC,顯示如下：

DIAGNOSTICS: Make desired changes and press ESC to record changes.
  Press Interrupt to abort changes.  Press F2 or CTRL-F for field-level help.
                        DIAGNOSTIC PARAMETERS

Message Log   [/usr/informix/online.log                                ]
Console Msgs. [/dev/console                                            ]
Alarm Program [/usr/informix/log_full.sh                               ]

Dump Shared Memory       [Y]
Dump Gcore               [N]
Dump Core                [N]
Dump Count               [   1]
Dump Directory           [/tmp                             ]

進入設置PDQ菜單：

PDQ: Make desired changes and press ESC to record changes.
  Press Interrupt to abort changes.  Press F2 or CTRL-F for field-level help.
                        PARALLEL DATABASE QUERIES PARAMETERS

Max PDQ Priority                  [ 30]
Decision Support Queries          [          ]
Decision Support Memory (Kbytes)  [          ]
Maximum Decision Support Scans    [   1048576]
Dataskip [off                                                             ]
Optimizer Hint                    [2]                                         (http://www.fanqiang.com)     進入【UNIX論壇】

★ 樊強制作歡迎分享 ★