DB2-WINDOWS測試新建例項資料庫配置管理

oracle_db發表於2012-05-16

測試:

命令視窗新建例項

C:\Program Files\IBM\SQLLIB\BIN>db2icrt newinst
DB20000I  DB2ICRT命令成功完成。

在新例項中建立新資料庫

C:\Program Files\IBM\SQLLIB\BIN>set db2instance=newinst

C:\Program Files\IBM\SQLLIB\BIN>db2start
ADM12026W  DB2 伺服器檢測到尚未註冊產品 "DB2 Enterprise Server Edition" 的有效許
可證。
SQL1063N  DB2START 處理成功。

C:\Program Files\IBM\SQLLIB\BIN>db2 create database newdb
DB20000I  CREATE DATABASE命令成功完成。

列出伺服器上的所有例項

C:\Program Files\IBM\SQLLIB\BIN>db2ilist
NEWINST
DB2

C:\Program Files\IBM\SQLLIB\BIN>

把dbm cfg 的FEDERATED 引數值由NO 改為YES 並驗證修改的結果

C:\Program Files\IBM\SQLLIB\BIN>db2 update dbm cfg using FEDERATED YES
DB20000I  UPDATE DATABASE MANAGER CONFIGURATION命令成功完成。
SQL1362W  未動態更改為立即修改而提交的一個或多個引數。直到下次啟動應用程式或發出

TERMINATE 命令之後,客戶機更改才會生效。直到下一條 DB2START
命令之後,伺服器更改才會生效。

C:\Program Files\IBM\SQLLIB\BIN>db2 force applications all
DB20000I  FORCE APPLICATION命令成功完成。
DB21024I  此命令為非同步的,可能未能立即生效。


C:\Program Files\IBM\SQLLIB\BIN>db2 terminate
DB20000I  TERMINATE命令成功完成。

 

C:\Program Files\IBM\SQLLIB\BIN>db2stop
SQL1064N  DB2STOP 處理成功。

C:\Program Files\IBM\SQLLIB\BIN>db2start
ADM12026W  DB2 伺服器檢測到尚未註冊產品 "DB2 Enterprise Server Edition" 的有效許
可證。
SQL1063N  DB2START 處理成功。

C:\Program Files\IBM\SQLLIB\BIN>

 

C:\Program Files\IBM\SQLLIB\BIN>db2 get dbm cfg

          資料庫管理器配置

     節點型別                                            = 帶有本地和遠端
的資料庫伺服器

 資料庫管理器配置發行版級別                              = 0x0c00

 最大開啟檔案數                            (MAXTOTFILOP) = 16000
 CPU 速度(毫秒/指令)                       (CPUSPEED) = 2.361721e-007

 最大併發活動資料庫數                            (NUMDB) = 8
 聯合資料庫系統支援                          (FEDERATED) = YES
 事務處理器監視器名                        (TP_MON_NAME) =

 預設對方付費帳戶                      (DFT_ACCOUNT_STR) =

 Java Development Kit 安裝路徑(JDK_PATH)               = C:\PROGRA~1\IB
B\java\jdk

 診斷錯誤捕獲級別                            (DIAGLEVEL) = 3
 通知級別                                  (NOTIFYLEVEL) = 3
 診斷資料目錄路徑                             (DIAGPATH) =

 預設資料庫監視開關
   緩衝池                              (DFT_MON_BUFPOOL) = OFF
   鎖定                                   (DFT_MON_LOCK) = OFF
   排序                                   (DFT_MON_SORT) = OFF
   語句                                   (DFT_MON_STMT) = OFF
   表                                    (DFT_MON_TABLE) = OFF
   時間戳記                          (DFT_MON_TIMESTAMP) = ON
   工作單元                                (DFT_MON_UOW) = OFF
 監視例項和資料庫的執行狀況                 (HEALTH_MON) = ON

 SYSADM 組名                              (SYSADM_GROUP) =
 SYSCTRL 組名                            (SYSCTRL_GROUP) =
 SYSMAINT 組名                          (SYSMAINT_GROUP) =
 SYSMON 組名                              (SYSMON_GROUP) =

 客戶機使用者標識-密碼外掛                (CLNT_PW_PLUGIN) =
 客戶機 Kerberos 外掛                  (CLNT_KRB_PLUGIN) = IBMkrb5
 組外掛                                   (GROUP_PLUGIN) =
 本地授權的 GSS 外掛                   (LOCAL_GSSPLUGIN) =
 伺服器外掛方式                        (SRV_PLUGIN_MODE) = UNFENCED
 GSS 外掛的伺服器列表            (SRVCON_GSSPLUGIN_LIST) =
 伺服器使用者標識-密碼外掛              (SRVCON_PW_PLUGIN) =
 伺服器連線認證                            (SRVCON_AUTH) = NOT_SPECIFIED
 叢集管理器                                (CLUSTER_MGR) =

 資料庫管理器認證                       (AUTHENTICATION) = SERVER
 沒有許可權就允許編目                     (CATALOG_NOAUTH) = NO
 信賴所有客戶機                         (TRUST_ALLCLNTS) = YES
 可信的客戶機認證                       (TRUST_CLNTAUTH) = CLIENT
 繞過聯合認證                               (FED_NOAUTH) = NO

 預設資料庫路徑                              (DFTDBPATH) = C:

 資料庫監視器堆大小(4KB)                 (MON_HEAP_SZ) = AUTOMATIC
 “Java 虛擬機器”堆大小(4KB)             (JAVA_HEAP_SZ) = 2048
 審計緩衝區大小(4KB)                    (AUDIT_BUF_SZ) = 0
 例項共享記憶體(4KB)的大小             (INSTANCE_MEMORY) = AUTOMATIC
 備份緩衝區預設大小(4KB)                   (BACKBUFSZ) = 1024
 復原緩衝區預設大小(4KB)                   (RESTBUFSZ) = 1024

 代理程式的堆疊大小                     (AGENT_STACK_SZ) = 16
 最小已落實專用記憶體(4KB)                (MIN_PRIV_MEM) = 32
 專用記憶體閾值(4KB)                   (PRIV_MEM_THRESH) = 20000

 排序堆閾值(4KB)                          (SHEAPTHRES) = 0

 目錄快取記憶體支援                            (DIR_CACHE) = YES

 應用程式支援層堆大小(4KB)                 (ASLHEAPSZ) = 15
 最大請求者 I/O 塊大小(以位元組計)            (RQRIOBLK) = 32767
 查詢堆大小(4KB)                       (QUERY_HEAP_SZ) = 1000

 已調速實用程式對工作負載的影響        (UTIL_IMPACT_LIM) = 10

 代理程式的優先順序                             (AGENTPRI) = SYSTEM
 代理程式池大小                         (NUM_POOLAGENTS) = AUTOMATIC
 池中的初始代理程式數                   (NUM_INITAGENTS) = 0
 最大協調代理程式數                    (MAX_COORDAGENTS) = AUTOMATIC
 最大客戶機連線數                      (MAX_CONNECTIONS) = AUTOMATIC

 保留受防護的程式                           (KEEPFENCED) = YES
 合用受防護的程式的數目                    (FENCED_POOL) = AUTOMATIC
 受防護的程式的初始數目                 (NUM_INITFENCED) = 0

 索引重新建立時間和重做索引構建               (INDEXREC) = RESTART

 事務管理器資料庫名稱                      (TM_DATABASE) = 1ST_CONN
 事務再同步時間間隔(秒)              (RESYNC_INTERVAL) = 180

 SPM 名稱                                     (SPM_NAME) = PC__2011
 SPM 日誌大小                          (SPM_LOG_FILE_SZ) = 256
 SPM 再同步代理程式限制                 (SPM_MAX_RESYNC) = 20
 SPM 日誌路徑                             (SPM_LOG_PATH) =

 NetBIOS 工作站名                                (NNAME) =

 TCP/IP 服務名稱                              (SVCENAME) =
 發現方式                                     (DISCOVER) = SEARCH
 發現伺服器例項                          (DISCOVER_INST) = ENABLE

 最大查詢並行度                        (MAX_QUERYDEGREE) = ANY
 啟用分割槽內並行性                       (INTRA_PARALLEL) = NO

 內部通訊緩衝區數(4KB)               (FCM_NUM_BUFFERS) = AUTOMATIC
 內部通訊通道數                       (FCM_NUM_CHANNELS) = AUTOMATIC
 db2start/db2stop 超時(分鐘)         (START_STOP_TIME) = 10


C:\Program Files\IBM\SQLLIB\BIN>

l連線到DB2

C:\Program Files\IBM\SQLLIB\BIN>db2 connect to sample

   資料庫連線資訊

 資料庫伺服器         = DB2/NT 9.5.0
 SQL 授權標識         = DB2ADMIN
 本地資料庫別名       = SAMPLE


C:\Program Files\IBM\SQLLIB\BIN>

 

檢視當前例項上有多少應用程式在執行

C:\Program Files\IBM\SQLLIB\BIN>db2 list applications show detail

CONNECT 授權標識               應用程式名           應用程式   應用程式標識
             代理程式的   協調資料庫          協調程式          狀態
             狀態更改時間               節點    資料庫名稱   資料庫路徑

                                                                      控制程式碼
                                     序號     分割槽號           程式標識/執行緒
--------------------------------------------------------------------------------
------------------------------------------------ -------------------- ----------
 -------------------------------------------------------------- ----- ----------
 ---------------- --------------- ------------------------------ ---------------
----------- -------- -------- --------------------
DB2ADMIN
                                                 db2stmm              5551
 *LOCAL.DB2.120516161024                                        00001 1
 0                3936            連線已完成                     2012-05-17 00:1
0:25.672059 PC--2012 SAMPLE   Z:\DB2\NODE0000\SQL00001\
DB2ADMIN
                                                 db2wlmd              5563
 *LOCAL.DB2.120516161026                                        00001 1
 0                3020            連線已完成                     2012-05-17 00:1
0:25.753774 PC--2012 SAMPLE   Z:\DB2\NODE0000\SQL00001\
DB2ADMIN
                                                 db2taskd             5562
 *LOCAL.DB2.120516161025                                        00001 1
 0                2228            連線已完成                     2012-05-17 00:1
0:25.867209 PC--2012 SAMPLE   Z:\DB2\NODE0000\SQL00001\
DB2ADMIN
                                                 db2bp.exe            5311
 *LOCAL.DB2.120516161021                                        00001 1
 0                1296            連線已完成                     2012-05-17 00:1
0:25.859563 PC--2012 SAMPLE   Z:\DB2\NODE0000\SQL00001\
ADMINISTRATOR
                                                 db2evmg_DB2DETAILDEA 5567
 *LOCAL.DB2.120516161027                                        00001 1
 0                4084            連線已完成                     2012-05-17 00:1
0:26.122562 PC--2012 SAMPLE   Z:\DB2\NODE0000\SQL00001\


C:\Program Files\IBM\SQLLIB\BIN>

刪除DB2例項

C:\Program Files\IBM\SQLLIB\BIN>db2stop
SQL1064N  DB2STOP 處理成功。

C:\Program Files\IBM\SQLLIB\BIN>db2idrop newinst
DB20000I  DB2IDROP命令成功完成。

C:\Program Files\IBM\SQLLIB\BIN>

刪除並重新建立啟動DAS

C:\Program Files\IBM\SQLLIB\BIN>db2stop
SQL1064N  DB2STOP 處理成功。

C:\Program Files\IBM\SQLLIB\BIN>db2idrop newinst
DB20000I  DB2IDROP命令成功完成。

C:\Program Files\IBM\SQLLIB\BIN>db2admin stop
SQL4407W  已成功停止“DB2管理伺服器”。

C:\Program Files\IBM\SQLLIB\BIN>db2admin drop
SQL4402W  DB2ADMIN 命令成功。

C:\Program Files\IBM\SQLLIB\BIN>db2admin create
SQL4402W  DB2ADMIN 命令成功。

C:\Program Files\IBM\SQLLIB\BIN>db2admin start
SQL4406W  已成功啟動 DB2 管理伺服器。

C:\Program Files\IBM\SQLLIB\BIN>

在您的例項中設定DB2 註冊變數DB2COMM,使其值為tcpip,npipe。

C:\Program Files\IBM\SQLLIB\BIN>db2set db2comm=tcpip,npipe

C:\Program Files\IBM\SQLLIB\BIN>db2stop
2012-05-17 00:20:22     0   0   SQL1064N  DB2STOP 處理成功。
SQL1064N  DB2STOP 處理成功。

C:\Program Files\IBM\SQLLIB\BIN>db2start
2012-05-17 00:20:28     0   0   SQL1063N  DB2START 處理成功。
SQL1063N  DB2START 處理成功。

C:\Program Files\IBM\SQLLIB\BIN>

置空DB2COMM 註冊變數

C:\Program Files\IBM\SQLLIB\BIN>db2set db2comm=

C:\Program Files\IBM\SQLLIB\BIN>db2stop
2012-05-17 00:21:49     0   0   SQL1064N  DB2STOP 處理成功。
SQL1064N  DB2STOP 處理成功。

C:\Program Files\IBM\SQLLIB\BIN>db2start
2012-05-17 00:21:54     0   0   SQL1063N  DB2START 處理成功。
SQL1063N  DB2START 處理成功。

C:\Program Files\IBM\SQLLIB\BIN>

檢查當前db cfg 的LOGSECOND 引數,然後將其值設定成5 並驗證新值

 

C:\Program Files\IBM\SQLLIB\BIN>db2 connect to sample

   資料庫連線資訊

 資料庫伺服器         = DB2/NT 9.5.0
 SQL 授權標識         = DB2ADMIN
 本地資料庫別名       = SAMPLE


C:\Program Files\IBM\SQLLIB\BIN>db2 get db cfg

       資料庫  的資料庫配置

 資料庫配置發行版級別                                    = 0x0c00
 資料庫發行版級別                                        = 0x0c00

 資料庫地域                                              = CN
 資料庫內碼表                                            = 1208
 資料庫程式碼集                                            = UTF-8
 資料庫國家/地區程式碼                                    = 86
 資料庫整理順序                                          = IDENTITY
 備用整理順序                              (ALT_COLLATE) =
 數字相容性                                              = OFF
 Varchar2 相容性                                         = OFF
 資料庫頁大小                                            = 8192

 動態 SQL 查詢管理                      (DYN_QUERY_MGMT) = DISABLE

 對此資料庫的發現支援                      (DISCOVER_DB) = ENABLE

 限制訪問                                                = NO
 預設查詢優化類                           (DFT_QUERYOPT) = 5
 並行度                                     (DFT_DEGREE) = 1
 在算術異常時繼續                      (DFT_SQLMATHWARN) = NO
 預設重新整理有效期                        (DFT_REFRESH_AGE) = 0
 預設維護的選項(DFT_MTTB_TYPES)的表型別                = SYSTEM
 保留的高頻值的數目                     (NUM_FREQVALUES) = 10
 保留的分位點數目                        (NUM_QUANTILES) = 20

 十進位制浮點舍入方式                    (DECFLT_ROUNDING) = ROUND_HALF_EVEN

 備份暫掛                                                = NO

 資料庫是一致的                                          = YES
 前滾暫掛                                                = NO
 復原暫掛                                                = NO

 啟用的多頁檔案分配                                      = YES

 恢復狀態的日誌保留                                      = NO
 日誌記錄狀態的使用者出口                                  = NO

 自調整記憶體                            (SELF_TUNING_MEM) = OFF
 資料庫共享記憶體大小(4KB)             (DATABASE_MEMORY) = AUTOMATIC
 資料庫記憶體閾值                          (DB_MEM_THRESH) = 10
 鎖定列表的最大儲存量(4KB)                   (LOCKLIST) = 50
 每個應用程式的鎖定百分比列表                 (MAXLOCKS) = 22
 程式包快取記憶體大小(4KB)                  (PCKCACHESZ) = (MAXAPPLS*8)
 共享排序的排序堆域值(4KB)            (SHEAPTHRES_SHR) = 5000
 排序列表堆(4KB)                            (SORTHEAP) = 256

 資料庫堆(4KB)                                (DBHEAP) = AUTOMATIC
 目錄快取記憶體大小(4KB)               (CATALOGCACHE_SZ) = (MAXAPPLS*4)
 日誌緩衝區大小(4KB)                         (LOGBUFSZ) = 8
 實用程式堆大小(4KB)                    (UTIL_HEAP_SZ) = 5000
 緩衝池大小(頁)                             (BUFFPAGE) = 250
 SQL 語句堆(4KB)                            (STMTHEAP) = AUTOMATIC
 預設應用程式堆(4KB)                      (APPLHEAPSZ) = AUTOMATIC
 應用程式記憶體大小(4KB)                (APPL_MEMORY) = AUTOMATIC
 統計資訊堆大小(4KB)                    (STAT_HEAP_SZ) = AUTOMATIC

 檢查死鎖的時間間隔(毫秒)                  (DLCHKTIME) = 10000
 鎖定超時(秒)                             (LOCKTIMEOUT) = -1

 更改的頁閾值                           (CHNGPGS_THRESH) = 60
 非同步頁清除程式的數目                   (NUM_IOCLEANERS) = AUTOMATIC
 I/O 伺服器的數目                        (NUM_IOSERVERS) = AUTOMATIC
 索引排序標誌                                 (INDEXSORT) = YES
 順序檢測標誌                                (SEQDETECT) = YES
 預設預取大小(頁)                    (DFT_PREFETCH_SZ) = AUTOMATIC

 跟蹤修改的頁數                               (TRACKMOD) = OFF

 容器的預設數目                                          = 1
 預設表空間擴充套件資料塊大小(頁)            (DFT_EXTENT_SZ) = 32

 最大活動應用程式數                           (MAXAPPLS) = AUTOMATIC
 活動應用程式的平均數目       (AVG_APPLS) = AUTOMATIC
 每個應用程式的最大開啟資料庫檔案數           (MAXFILOP) = 32768

 日誌檔案大小(4KB)                         (LOGFILSIZ) = 1000
 主日誌檔案的數目                           (LOGPRIMARY) = 3
 輔助日誌檔案的數目                          (LOGSECOND) = 2
 已更改的至日誌檔案的路徑                   (NEWLOGPATH) =
 日誌檔案路徑                                            = Z:\DB2\NODE0000\SQL
001\SQLOGDIR\
 溢位日誌路徑                          (OVERFLOWLOGPATH) =
 映象日誌路徑                            (MIRRORLOGPATH) =
 首個活動日誌檔案                                        =
 磁碟上已滿的塊日誌                    (BLK_LOG_DSK_FUL) = NO
 事務使用的最大主日誌空間的百分比        (MAX_LOG)= 0
 1 個活動 UOW 的活動日誌檔案的數目        (NUM_LOG_SPAN) = 0

 組落實計數                                  (MINCOMMIT) = 1
 軟檢查點前回收的日誌檔案的百分比              (SOFTMAX) = 100
 啟用的恢復的日誌保留                        (LOGRETAIN) = OFF
 啟用的日誌記錄的使用者出口                     (USEREXIT) = OFF

 HADR 資料庫角色                                          = STANDARD
 HADR 本地主機名                        (HADR_LOCAL_HOST) =
 HADR 本地服務名稱                       (HADR_LOCAL_SVC) =
 HADR 遠端主機名                       (HADR_REMOTE_HOST) =
 HADR 遠端服務名稱                      (HADR_REMOTE_SVC) =
 遠端伺服器的 HADR 例項名              (HADR_REMOTE_INST) =
 HADR 超時值                               (HADR_TIMEOUT) = 120
 HADR 日誌寫同步方式                      (HADR_SYNCMODE) = NEARSYNC
 HADR 對等視窗持續時間(秒)       (HADR_PEER_WINDOW) = 0

 第一個日誌歸檔方法                        (LOGARCHMETH1) = OFF
 logarchmeth1 的選項                        (LOGARCHOPT1) =
 第二個日誌歸檔方法                        (LOGARCHMETH2) = OFF
 logarchmeth2 的選項                        (LOGARCHOPT2) =
 故障轉移日誌歸檔路徑                     (FAILARCHPATH) =
 錯誤時重試日誌歸檔次數                   (NUMARCHRETRY) = 5
 日誌歸檔重試延遲(秒)                 (ARCHRETRYDELAY) = 20
 供應商選項                                  (VENDOROPT) =

 啟用的自動重新啟動                        (AUTORESTART) = ON
 索引重新建立時間和重做索引構建               (INDEXREC) = SYSTEM (RESTART)
 在索引構建期間記錄頁                    (LOGINDEXBUILD) = OFF
 loadrec 會話的預設數目                (DFT_LOADREC_SES) = 1
 要保留的資料庫備份的數目               (NUM_DB_BACKUPS) = 12
 恢復歷史記錄保留時間(天數)          (REC_HIS_RETENTN) = 366
 自動刪除恢復物件                     (AUTO_DEL_REC_OBJ) = OFF

 TSM 管理類                              (TSM_MGMTCLASS) =
 TSM 節點名                               (TSM_NODENAME) =
 TSM 所有者                                  (TSM_OWNER) =
 TSM 密碼                                 (TSM_PASSWORD) =

 自動維護                                   (AUTO_MAINT) = ON
   自動資料庫備份                       (AUTO_DB_BACKUP) = OFF
   自動錶維護                           (AUTO_TBL_MAINT) = ON
     自動 runstats                       (AUTO_RUNSTATS) = ON
       自動語句統計資訊                  (AUTO_STMT_STATS) = OFF
     自動統計資訊概要分析              (AUTO_STATS_PROF) = OFF
       自動概要檔案更新                  (AUTO_PROF_UPD) = OFF
     自動重組                       (AUTO_REORG) = OFF

 啟用 XML 字元操作                      (ENABLE_XMLCHAR) = YES
 WLM 收集時間間隔(分鐘)              (WLM_COLLECT_INT) = 0

C:\Program Files\IBM\SQLLIB\BIN>db2 update db cfg using LOGSECOND 5
DB20000I  UPDATE DATABASE CONFIGURATION命令成功完成。

C:\Program Files\IBM\SQLLIB\BIN>

C:\Program Files\IBM\SQLLIB\BIN>db2 get db cfg

       資料庫  的資料庫配置

 資料庫配置發行版級別                                    = 0x0c00
 資料庫發行版級別                                        = 0x0c00

 資料庫地域                                              = CN
 資料庫內碼表                                            = 1208
 資料庫程式碼集                                            = UTF-8
 資料庫國家/地區程式碼                                    = 86
 資料庫整理順序                                          = IDENTITY
 備用整理順序                              (ALT_COLLATE) =
 數字相容性                                              = OFF
 Varchar2 相容性                                         = OFF
 資料庫頁大小                                            = 8192

 動態 SQL 查詢管理                      (DYN_QUERY_MGMT) = DISABLE

 對此資料庫的發現支援                      (DISCOVER_DB) = ENABLE

 限制訪問                                                = NO
 預設查詢優化類                           (DFT_QUERYOPT) = 5
 並行度                                     (DFT_DEGREE) = 1
 在算術異常時繼續                      (DFT_SQLMATHWARN) = NO
 預設重新整理有效期                        (DFT_REFRESH_AGE) = 0
 預設維護的選項(DFT_MTTB_TYPES)的表型別                = SYSTEM
 保留的高頻值的數目                     (NUM_FREQVALUES) = 10
 保留的分位點數目                        (NUM_QUANTILES) = 20

 十進位制浮點舍入方式                    (DECFLT_ROUNDING) = ROUND_HALF_EVEN

 備份暫掛                                                = NO

 資料庫是一致的                                          = YES
 前滾暫掛                                                = NO
 復原暫掛                                                = NO

 啟用的多頁檔案分配                                      = YES

 恢復狀態的日誌保留                                      = NO
 日誌記錄狀態的使用者出口                                  = NO

 自調整記憶體                            (SELF_TUNING_MEM) = OFF
 資料庫共享記憶體大小(4KB)             (DATABASE_MEMORY) = AUTOMATIC
 資料庫記憶體閾值                          (DB_MEM_THRESH) = 10
 鎖定列表的最大儲存量(4KB)                   (LOCKLIST) = 50
 每個應用程式的鎖定百分比列表                 (MAXLOCKS) = 22
 程式包快取記憶體大小(4KB)                  (PCKCACHESZ) = (MAXAPPLS*8)
 共享排序的排序堆域值(4KB)            (SHEAPTHRES_SHR) = 5000
 排序列表堆(4KB)                            (SORTHEAP) = 256

 資料庫堆(4KB)                                (DBHEAP) = AUTOMATIC
 目錄快取記憶體大小(4KB)               (CATALOGCACHE_SZ) = (MAXAPPLS*4)
 日誌緩衝區大小(4KB)                         (LOGBUFSZ) = 8
 實用程式堆大小(4KB)                    (UTIL_HEAP_SZ) = 5000
 緩衝池大小(頁)                             (BUFFPAGE) = 250
 SQL 語句堆(4KB)                            (STMTHEAP) = AUTOMATIC
 預設應用程式堆(4KB)                      (APPLHEAPSZ) = AUTOMATIC
 應用程式記憶體大小(4KB)                (APPL_MEMORY) = AUTOMATIC
 統計資訊堆大小(4KB)                    (STAT_HEAP_SZ) = AUTOMATIC

 檢查死鎖的時間間隔(毫秒)                  (DLCHKTIME) = 10000
 鎖定超時(秒)                             (LOCKTIMEOUT) = -1

 更改的頁閾值                           (CHNGPGS_THRESH) = 60
 非同步頁清除程式的數目                   (NUM_IOCLEANERS) = AUTOMATIC
 I/O 伺服器的數目                        (NUM_IOSERVERS) = AUTOMATIC
 索引排序標誌                                 (INDEXSORT) = YES
 順序檢測標誌                                (SEQDETECT) = YES
 預設預取大小(頁)                    (DFT_PREFETCH_SZ) = AUTOMATIC

 跟蹤修改的頁數                               (TRACKMOD) = OFF

 容器的預設數目                                          = 1
 預設表空間擴充套件資料塊大小(頁)            (DFT_EXTENT_SZ) = 32

 最大活動應用程式數                           (MAXAPPLS) = AUTOMATIC
 活動應用程式的平均數目       (AVG_APPLS) = AUTOMATIC
 每個應用程式的最大開啟資料庫檔案數           (MAXFILOP) = 32768

 日誌檔案大小(4KB)                         (LOGFILSIZ) = 1000
 主日誌檔案的數目                           (LOGPRIMARY) = 3
 輔助日誌檔案的數目                          (LOGSECOND) = 5
 已更改的至日誌檔案的路徑                   (NEWLOGPATH) =
 。。。
C:\Program Files\IBM\SQLLIB\BIN>


 

 

 

 

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15720542/viewspace-729974/,如需轉載,請註明出處,否則將追究法律責任。

相關文章