db2数据库维护手册

db2数据库维护手册内容摘要：

n Id DB of Name Handle Name Agents DB2INST1 db2bp 5 * KMS1 1 以上信息显示 KMS1 数据库有一个连接，连接句柄为 5。 如果出现以下信息，则说明在数据库上没有连接，可以直接删除数据库。 $ db2 list application SQL1611W No data was returned by Database System Monitor. SQLSTATE=00000 3. 断开存在的数据库连接 $ 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。 如果要断开 实例下所有数据库的连接，可以使用如下命令： db2 force applications all 4. 删除数据库 $db2 drop db KMS1 连接数据库 使用 connect 工具连接数据库。 使用当前用户连接数据库 db2 connect to KMS1 Database Connection Information Database server = DB2/LINUX SQL authorization ID = DB2INST1 Local database alias = KMS1 使用指定用户连接数据库 ， username 是指用户名， userpw 指用户密码。 如果是向远端数据库在本地的映射发出 connect 指令，是要显示的给出用户名和密码的。 有关如何配置远端数据库德映射请见《 配置助手》 db2 connect to KMS1user username using userpw 断开 connect 工具发出的数据库连接。 当前已经对一个数据库发出了 connect连接，当需要在连接另外一个数据库时，首先要断开当前的 connect 连接。 db2 connect reset 数据库参数 数据库创建好之后，可以使用如下命令查看数据的各项参数。 下面是一个数据库的参数配置实例。 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 log 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_。