【正文】 g files (LOGPRIMARY) = 3 Number of secondary log files (LOGSECOND) = 2 Changed path to log files (NEWLOGPATH) = Path to log files = /home/data/db2inst1/NODE0000/SQL00001/SQLOGDIR/ Overflow log path (OVERFLOWLOGPATH) = Mirror log path (MIRRORLOGPATH) = First active log file = Block log on disk full (BLK_LOG_DSK_FUL) = NO Percent of max active log space by transaction(MAX_LOG) = 0 Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0 Group mit count (MINCOMMIT) = 1 Percent log file reclaimed before soft chckpt (SOFTMAX) = 100 Log retain for recovery enabled (LOGRETAIN) = OFF User exit for logging enabled (USEREXIT) = OFF Auto restart enabled (AUTORESTART) = ON Index recreation time (INDEXREC) = SYSTEM (RESTART) Default number of loadrec sessions (DFT_LOADREC_SES) = 1 Number of database backups to retain (NUM_DB_BACKUPS) = 12 Recovery history retention (days) (REC_HIS_RETENTN) = 366 TSM management class (TSM_MGMTCLASS) = TSM node name (TSM_NODENAME) = TSM owner (TSM_OWNER) = TSM password (TSM_PASSWORD) = 可以使用如下命令更改數(shù)據(jù)庫(kù)的參數(shù)，在更改數(shù)據(jù)庫(kù)參數(shù)之前，首先要斷開(kāi)數(shù)據(jù)庫(kù)的所以連接。所有在失敗前被撤消的操作和失敗時(shí)正在處理的事務(wù)對(duì)數(shù)據(jù)庫(kù)進(jìn)行的更改都被撤消。 $ db2 list tables for all Table/View Schema Type Creation time CA_TAB DB2INST1 T CA_INFO NETWORLD T CHECKS SYSCAT V COLUMNS SYSIBM V COLDIST SYSSTAT V 上述信息中，表 CA_TAB 和表 CA_INFO 為用戶表，表 CHECKS、 COLUMNS和表 COLDIST 為系統(tǒng)表。SYS%39。 $ db2 list tablespaces show detail Tablespaces for Current Database Tablespace ID = 0 //表空間的 ID 號(hào) Name = SYSCATSPACE //表空間的名字 Type = System managed space //表空間的類型 Contents = Any data //可存儲(chǔ)的數(shù)據(jù)庫(kù) State = 0x0000 //表空間的狀態(tài) ? 表空間的狀態(tài)為 0x0000 表示正常。默認(rèn)用戶表空間名為 USERSPACE1，索引也存儲(chǔ)在規(guī)則表空間中，另外系統(tǒng)目錄表也放在規(guī)則表空間中。 用戶臨時(shí)表空間用來(lái)存儲(chǔ)已說(shuō)明全局臨時(shí)表（已說(shuō)明全局臨時(shí)表存儲(chǔ)的是應(yīng)用程序臨時(shí)數(shù)據(jù)）。 DMS 是由數(shù)據(jù)庫(kù)管理的 ,空間大小在創(chuàng)建時(shí)確 定，空間不夠時(shí)要手工添加或刪除部分?jǐn)?shù)據(jù)以釋放空間。39。 例二：刪除例一所創(chuàng)建的 SMS 表空間。path。path。 5000,file 39。 db2 alter tablespace resource add(file 39。 db2 alter tablespace resource resize(file 39。 8000,file 39。 例六：用 EXTEND 子句更改例三所創(chuàng)建的表空間的容器的大小。acc_tbsp39。 例七：刪除例三中創(chuàng)建的 DMS 表空間。tmp_tbsp39。 例 九 ：創(chuàng)建用戶臨時(shí)表空間。usr_tbsp139。 可以將命令執(zhí)行結(jié)果輸出到文件 $db2 get snapshot for all on kms 用 grep 命令查看輸出的文件中是否有死鎖的記錄，比如 grep n Deadlocks detected | grep v = 0 | more 查看緩沖池的命中率 通過(guò)使用 get snapshot for all on dbname，可以為數(shù)據(jù)庫(kù)上的每個(gè)緩沖池生成一個(gè)快照，下 面代碼展示了這樣一個(gè)快照： $db2 get snapshot for all on kms1 Bufferpool Snapshot Bufferpool name = IBMDEFAULTBP Database name = kms1 Database path = C:\DB2\NODE0000\SQL00002\ Input database alias = kms1 Snapshot timestamp = 02202020 06:24: Buffer pool data logical reads = 370 Buffer pool data physical reads = 54 Buffer pool temporary data logical reads = 0 Buffer pool temporary data physical reads = 0 Buffer pool data writes = 3 Buffer pool index logical reads = 221 Buffer pool index physical reads = 94 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Total buffer pool read time (ms) = 287 Total buffer pool write time (ms) = 1 Asynchronous pool data page reads = 9 Asynchronous pool data page writes = 0 28 Buffer pool index writes = 0 Asynchronous pool index page reads = 0 Asynchronous pool index page writes = 0 Total elapsed asynchronous read time = 0 Total elapsed asynchronous write time = 0 Asynchronous data read requests = 3 Asynchronous index read requests = 0 No victim buffers available = 0 Direct reads = 86 Direct writes = 4 Direct read requests = 14 Direct write requests = 2 Direct reads elapsed time (ms) = 247 Direct write elapsed time (ms) = 56 Database files closed = 0 Data pages copied to extended storage = 0 Index pages copied to extended storage = 0 Data pages copied from extended storage = 0 Index pages copied from extended storage = 0 Unread prefetch pages = 0 Vectored IOs = 3 Pages from vectored IOs = 9 Block IOs = 0 Pages from block IOs = 0 Physical page maps = 0 Node number = 0 Tablespaces using bufferpool = 4 Alter bufferpool information: Pages left to remove = 0 Current size = 250 Postalter size = 250 為了判斷一個(gè)緩沖池 的效率，需要計(jì)算它的緩沖池命中率 (BPHR)。 完全備份 這是大多數(shù)人常用的方式，它可以備份整個(gè)數(shù)據(jù)庫(kù)，包含用戶表、系統(tǒng)表、索引、視圖和存儲(chǔ)過(guò)程等所有數(shù)據(jù)庫(kù)對(duì)象。 差異備份 也叫增量備份。推薦每天做一次差異備份。 按照備份時(shí)對(duì) 業(yè)務(wù)的 影響范圍 可以分為離線全備份，在線全備份，離線全備份 。 如果出現(xiàn)以下信息，則說(shuō)明在數(shù)據(jù)庫(kù)上沒(méi)有連接，可以直接 備份