【正文】 db2inst1，實例名為 DB2INST1， 4. 在 /etc/service 中加入： db2inst1 50000/tcp DB2_db2inst1 60000/tcp DB2_db2inst1_1 60001/tcp DB2_db2inst1_2 60002/tcp DB2_db2inst1_END 60003/tcp 以上操作是將 DB2 實例 DB2INST1 的服務(wù)名以及服務(wù)端口加到系統(tǒng)的服務(wù)中。 2 卸載 DB2 由于某種原因，要卸載 DB2 再重新安裝的話，一定要正確的卸載 DB2，否則不能執(zhí)行重新安裝或安裝的 DB2 不可用。 DB2 實例。 下面按照卸載 DB2 的一般過程說明具體卸載過程。 停止 DB2 實例：必須要停止 DB2 實例才能在 linux 上卸載 DB2。 (linux 默認(rèn)第一個實例的用戶為db2inst1)。 。 除去 DB2 實例：可以除去系統(tǒng)上的實例，一旦除去實例，實例擁有的所有 DB2數(shù)據(jù)庫都將不可用?？梢允褂?db2 list tables for all 命令看到表的表模式。 管理服務(wù)器 檢查管理服務(wù)器是否啟動 用 ps 命令查看是否有 dasusr1 后臺進程 ps ef | dasusr1 可以使用如下命令查看管理服務(wù)器的名稱 cd $DB2_HOME/instance ($DB2_HOME 為 db2 數(shù)據(jù)庫的安裝目錄 ) ./daslist dasusr1 管理服務(wù)器的啟動和停止 使用管理服務(wù)器用戶 (UNIX 默認(rèn)是 DASUSR1)啟動和停止管理服務(wù)器。 操作如下： cd DB2_HOME/instance 創(chuàng)建管理服務(wù)器 dasusr1 ./dascrt dasusr1 刪除管理服務(wù)器 dasusr1 ./dasdrop dasusr1 數(shù)據(jù)庫實例 檢查 DB2 實例是否已經(jīng)啟動 用 ps 命令查看是否有 db2sysc 后臺進程 ＃ ps ef | db2sysc 可以使用如下命令查看實例的名稱 cd $DB2_HOME/instance ($DB2_HOME 為 db2 數(shù)據(jù)庫的安裝目錄 ) ./db2ilist db2inst1 實例的啟動和停止 使用 實例 用戶 (UNIX 默認(rèn)是 DB2INST1)啟動和停止 實例 。 使用如下命令查看代碼頁設(shè)置： $ db2set DB2CODEPAGE=1386 上述信息顯示代碼頁的設(shè)置為 是 在中國區(qū)域使用的代碼頁 。 $db2 create db KMS1 using codeset gbk territory DB20200I The CREATE DATABASE mand pleted successfully. 19 指定數(shù)據(jù)庫存儲在 /data 目錄下 $db2 create db KMS1 on /data DB20200I The CREATE DATABASE mand pleted successfully. 執(zhí)行數(shù)據(jù)存儲在 /data 目錄下，字符集為 gbk，代碼頁 為 1386（ 是指中國區(qū)域） 。 $ db2 list application SQL1611W No data was returned by Database System Monitor. SQLSTATE=00000 3. 斷開存在的數(shù)據(jù)庫連接 $ db2 force application(5) DB20200I The FORCE APPLICATION mand pleted successfully. 20 DB21024I This mand is asynchronous and may not be effective immediately. application(5)中的 5 是連接的句柄 ApplHandle。 有關(guān)如何配置遠(yuǎn)端數(shù)據(jù)庫德映射請見《 配置助手》 db2 connect to KMS1user username using userpw 斷開 connect 工具發(fā)出的數(shù)據(jù)庫連接 。 db2 get db cfg for kms1 Database Configuration for Database kms1 Database configuration release level = 0x0a00 Database release level = 0x0a00 Database territory = Database code page = 1386 Database code set = gbk Database country/region code = 86 Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE 21 Discovery support for this database (DISCOVER_DB) = ENABLE Default query optimization class (DFT_QUERYOPT) = 5 Degree of parallelism (DFT_DEGREE) = 1 Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO Default refresh age (DFT_REFRESH_AGE) = 0 Number of frequent values retained (NUM_FREQVALUES) = 10 Number of quantiles retained (NUM_QUANTILES) = 20 Backup pending = NO Database is consistent = YES Rollforward pending = NO Restore pending = NO Multipage file allocation enabled = NO Log retain for recovery status = NO User exit for logging status = NO Data Links Token Expiry Interval (sec) (DL_EXPINT) = 60 Data Links Write Token Init Expiry Intvl(DL_WT_IEXPINT) = 60 Data Links Number of Copies (DL_NUM_COPIES) = 1 Data Links Time after Drop (days) (DL_TIME_DROP) = 1 Data Links Token in Uppercase (DL_UPPER) = NO Data Links Token Algorithm (DL_TOKEN) = MAC0 Database heap (4KB) (DBHEAP) = 1200 Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC Catalog cache size (4KB) (CATALOGCACHE_SZ) = (MAXAPPLS*4) Log buffer size (4KB) (LOGBUFSZ) = 8 Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000 Buffer pool size (pages) (BUFFPAGE) = 1000 Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000 Number of extended storage segments (NUM_ESTORE_SEGS) = 0 Max storage for lock list (4KB) (LOCKLIST) = 100 Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 30000 Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70 Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 128 Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = (SHEAPTHRES) Sort list heap (4KB) (SORTHEAP) = 256 SQL statement heap (4KB) (STMTHEAP) = 2048 Default application heap (4KB) (APPLHEAPSZ) = 256 Package cache size (4KB) (PCKCACHESZ) = (MAXAPPLS*8) Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384 Interval for checking deadlock (ms) (DLCHKTIME) = 10000 Percent. of lock lists per application (MAXLOCKS) = 10 Lock timeout (sec) (LOCKTIMEOUT) = 1 Changed pages threshold (CHNGPGS_THRESH) = 60 Number of asynchronous page cleaners (NUM_IOCLEANERS) = 1 Number of I/O servers (NUM_IOSERVERS) = 3 22 Index sort flag (INDEXSORT) = YES Sequential detect flag (SEQDETECT) = YES Default prefetch size (pages) (DFT_PREFETCH_SZ) = 32 Track modified pages (TRACKMOD) = OFF Default number of containers = 1 Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32 Max number of active applications (MAXAPPLS) = AUTOMATIC Average number of active applications (AVG_APPLS) = 1 Max DB files open per application (MAXFILOP) = 64 Log file size (4KB) (LOGFILSIZ) = 1000 Number of primary lo