获取DB2数据库参数的方法
来源：互联网 发布：人工智能剧情介绍 编辑：程序博客网 时间：2024/06/16 06:35
共有两种获取DB2数据库参数的方法，
一. 使用现成的工具
一共有以下几个方面的类似工具，使用这些工具的人群一般是DBA，
1. DB2的控制中心，使用db2cc命令打开
2. DB2的db2pd命令
192.168.100.228 [sde ~]$ db2pd -db mydb -dbcfg
Database Partition 0 -- Database MYDB -- Active -- Up 6 days 22:55:35
Database Configuration Settings:Description Memory Value Disk Value
DB configuration release level 0xd00 0xd00Database release level 0xd00 0xd00
Database territory CN CNDatabase code page 1208 1208Database code set UTF-8 UTF-8
Database country/region code 86 86Database collating sequence IDENTITY IDENTITY
ALT_COLLATE NON_UNIQUE NON_UNIQUE
NUMBER_COMPAT ON ON
VARCHAR2_COMPAT ON ON
DATE_COMPAT ON ON
Database page size 4096 4096
DYN_QUERY_MGMT DISABLE DISABLE
Statement concentrator OFF OFF
DISCOVER_DB ENABLE ENABLE
Restrict access NO NO
DFT_QUERYOPT 5 5
DFT_DEGREE 1 1
DFT_SQLMATHWARN NO NO
DFT_REFRESH_AGE 0 0
DFT_MTTB_TYPES SYSTEM SYSTEM
NUM_FREQVALUES 10 10
NUM_QUANTILES 20 20
DECFLT_ROUNDING ROUND_HALF_EVEN ROUND_HALF_EVEN
Backup pending NO NO
Database is consistent NO NO
Rollforward pending NO NO
Restore pending NO NO
Multi-page File alloc enabled YES YESLog retain for recovery status NO NO
User exit for logging status NO NO
SELF_TUNING_MEM ON ON
ENABLE_XMLCHAR YES YES
WLM_COLLECT_INT (mins) 0 0
DATABASE_MEMORY (4KB) 148020 148020
DB_MEM_THRESH 10 10
LOCKLIST (4KB) 4120 4120
MAXLOCKS 97 97
PCKCACHESZ (4KB) 7835 7835
SHEAPTHRES_SHR (4KB) 1286 1286
SORTHEAP (4KB) 257 257
DBHEAP (4KB) 2345 2345
CATALOGCACHE_SZ (4KB) 300 300
LOGBUFSZ (4KB) 256 256
UTIL_HEAP_SZ (4KB) 12862 12862
BUFFPAGE 1000 1000
APPL_MEMORY (4KB) 40016 40000
STMTHEAP (4KB) 6402 4096
APPLHEAPSZ (4KB) 256 256
STAT_HEAP_SZ (4KB) 4384 4384
DLCHKTIME (ms) 10000 10000
LOCKTIMEOUT (secs) -1 -1
CHNGPGS_THRESH 80 80
NUM_IOCLEANERS 1 1
NUM_IOSERVERS 3 3
INDEXSORT YES YES
SEQDETECT YES YES
DFT_PREFETCH_SZ (pages) 32 32
TRACKMOD OFF OFF
Default number of containers 1 1
DFT_EXTENT_SZ (pages) 32 32
MAXAPPLS 40 40
AVG_APPLS 1 1
MAXFILOP 61440 61440
LOGFILSIZ (4KB) 1024 1024
LOGPRIMARY 13 13
LOGSECOND 4 4
NEWLOGPATH (memory)
NEWLOGPATH (disk)Path to log files (memory) /home/db2inst1/db2inst1/NODE0000/SQL00002/SQLOGDIR/
Path to log files (disk)
OVERFLOWLOGPATH (memory)
OVERFLOWLOGPATH (disk)MIRRORLOGPATH (memory)
MIRRORLOGPATH (disk)First active log file S0000010.LOG S0000010.LOG
BLK_LOG_DSK_FUL NO NO
BLOCKNONLOGGED NO NO
MAX_LOG 0 0
NUM_LOG_SPAN 0 0
MINCOMMIT 1 1
SOFTMAX 520 520
LOGRETAIN OFF OFF
USEREXIT OFF OFF
HADR database role STANDARD STANDARD
HADR_LOCAL_HOST
HADR_LOCAL_SVC
HADR_REMOTE_HOST
HADR_REMOTE_SVC
HADR_REMOTE_INST
HADR_TIMEOUT 120 120
HADR_SYNCMODE NEARSYNC NEARSYNC
HADR_PEER_WINDOW (secs) 0 0
LOGARCHMETH1 (memory) OFFLOGARCHMETH1 (disk) OFF
LOGARCHOPT1
LOGARCHMETH2 (memory) OFFLOGARCHMETH2 (disk) OFF
LOGARCHOPT2
FAILARCHPATH (memory)
FAILARCHPATH (disk)NUMARCHRETRY 5 5
ARCHRETRYDELAY (secs) 20 20
VENDOROPT
AUTORESTART ON ON
INDEXREC 0 0
LOGINDEXBUILD 0 0
DFT_LOADREC_SES 1 1
NUM_DB_BACKUPS 12 12
REC_HIS_RETENTN (days) 366 366
TSM_MGMTCLASS
TSM_NODENAME
TSM_OWNER
TSM_PASSWORD
AUTO_MAINT ON ON
AUTO_DB_BACKUP OFF OFF
AUTO_TBL_MAINT ON ON
AUTO_RUNSTATS ON ON
AUTO_STMT_STATS ON ON
AUTO_STATS_PROF OFF OFF
AUTO_PROF_UPD OFF OFF
AUTO_REORG OFF OFF
CUR_COMMIT ON ON
AUTO_REVAL IMMEDIATE IMMEDIATE
DEC_TO_CHAR_FMT NEW NEW
MON_REQ_METRICS BASE BASE
MON_ACT_METRICS BASE BASE
MON_OBJ_METRICS BASE BASE
MON_UOW_DATA NONE NONE
MON_LOCKTIMEOUT NONE NONE
MON_DEADLOCK WITHOUT_HIST WITHOUT_HIST
MON_LOCKWAIT NONE NONE
MON_LW_THRESH 5000000 5000000
SMTP Server (memory)
SMTP Server (disk)MON_PKGLIST_SZ 32 32
MON_LCK_MSG_LVL 1 1
SQL_CCFLAGS (memory)
SQL_CCFLAGS (disk)SECTION_ACTUALS NONE NONE
3. DB2 的CLI (Command Line Interface)
192.168.100.228 [sde ~]$ db2 get db cfgDatabase Configuration for Database
Database configuration release level = 0x0d00
Database release level = 0x0d00
Database territory = CN Database code page = 1208Database code set = UTF-8
Database country/region code = 86Database collating sequence = IDENTITY
Alternate collating sequence (ALT_COLLATE) = Number compatibility = ON Varchar2 compatibility = ONDate compatibility = ON
Database page size = 4096
Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE
Statement concentrator (STMT_CONC) = OFF
Discovery support for this database (DISCOVER_DB) = ENABLE
Restrict access = NO
Default query optimization class (DFT_QUERYOPT) = 5
Degree of parallelism (DFT_DEGREE) = 1Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
Default refresh age (DFT_REFRESH_AGE) = 0Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
Number of frequent values retained (NUM_FREQVALUES) = 10
Number of quantiles retained (NUM_QUANTILES) = 20 Decimal floating point rounding mode (DECFLT_ROUNDING) = ROUND_HALF_EVENBackup pending = NO
All committed transactions have been written to disk = NO
Rollforward pending = NORestore pending = NO
Multi-page file allocation enabled = YESLog retain for recovery status = NO
User exit for logging status = NO
Self tuning memory (SELF_TUNING_MEM) = ONSize of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(148020)
Database memory threshold (DB_MEM_THRESH) = 10Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC(4120)
Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC(97)
Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(7835) Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(1286)Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(257)
Database heap (4KB) (DBHEAP) = AUTOMATIC(2345)Catalog cache size (4KB) (CATALOGCACHE_SZ) = 300
Log buffer size (4KB) (LOGBUFSZ) = 256 Utilities heap size (4KB) (UTIL_HEAP_SZ) = 12862 Buffer pool size (pages) (BUFFPAGE) = 1000SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(4096)
Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(256) Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(40000)Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(4384)
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Lock timeout (sec) (LOCKTIMEOUT) = -1
Changed pages threshold (CHNGPGS_THRESH) = 80
Number of asynchronous page cleaners (NUM_IOCLEANERS) = AUTOMATIC(1) Number of I/O servers (NUM_IOSERVERS) = AUTOMATIC(3) Index sort flag (INDEXSORT) = YESSequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC
Track modified pages (TRACKMOD) = OFFDefault number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32Max number of active applications (MAXAPPLS) = AUTOMATIC(40)
Average number of active applications (AVG_APPLS) = AUTOMATIC(1)Max DB files open per application (MAXFILOP) = 61440
Log file size (4KB) (LOGFILSIZ) = 1024
Number of primary log files (LOGPRIMARY) = 13
Number of secondary log files (LOGSECOND) = 4Changed path to log files (NEWLOGPATH) =
Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00002/SQLOGDIR/
Overflow log path (OVERFLOWLOGPATH) = Mirror log path (MIRRORLOGPATH) =First active log file =
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Block non logged operations (BLOCKNONLOGGED) = NOPercent max primary log space by transaction (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
Group commit count (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 520
Log retain for recovery enabled (LOGRETAIN) = OFF
User exit for logging enabled (USEREXIT) = OFF
HADR database role = STANDARD
HADR local host name (HADR_LOCAL_HOST) =
HADR local service name (HADR_LOCAL_SVC) = HADR remote host name (HADR_REMOTE_HOST) =HADR remote service name (HADR_REMOTE_SVC) =
HADR instance name of remote server (HADR_REMOTE_INST) = HADR timeout value (HADR_TIMEOUT) = 120 HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNCHADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0
First log archive method (LOGARCHMETH1) = OFF
Options for logarchmeth1 (LOGARCHOPT1) =Second log archive method (LOGARCHMETH2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) = Failover log archive path (FAILARCHPATH) =Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
Vendor options (VENDOROPT) =
Auto restart enabled (AUTORESTART) = ONIndex re-creation time and redo index build (INDEXREC) = SYSTEM (RESTART)
Log pages during index build (LOGINDEXBUILD) = OFF
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
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFF
TSM management class (TSM_MGMTCLASS) =TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =
Automatic maintenance (AUTO_MAINT) = ONAutomatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = ON
Automatic runstats (AUTO_RUNSTATS) = ONAutomatic statement statistics (AUTO_STMT_STATS) = ON
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF Automatic reorganization (AUTO_REORG) = OFF Auto-Revalidation (AUTO_REVAL) = DEFERRED Currently Committed (CUR_COMMIT) = ONCHAR output with DECIMAL input (DEC_TO_CHAR_FMT) = NEW
Enable XML Character operations (ENABLE_XMLCHAR) = YES WLM Collection Interval (minutes) (WLM_COLLECT_INT) = 0Monitor Collect Settings
Request metrics (MON_REQ_METRICS) = BASE
Activity metrics (MON_ACT_METRICS) = BASE
Object metrics (MON_OBJ_METRICS) = BASEUnit of work events (MON_UOW_DATA) = NONE
Lock timeout events (MON_LOCKTIMEOUT) = NONEDeadlock events (MON_DEADLOCK) = WITHOUT_HIST
Lock wait events (MON_LOCKWAIT) = NONELock wait event threshold (MON_LW_THRESH) = 5000000
Number of package list entries (MON_PKGLIST_SZ) = 32 Lock event notification level (MON_LCK_MSG_LVL) = 1SMTP Server (SMTP_SERVER) =
SQL conditional compilation flags (SQL_CCFLAGS) =Section actuals setting (SECTION_ACTUALS) = NONE
二：使用程序来获取
主要使用的人群是开发者，以下是使用IBM使用CLI接口缩写的例子程序：
#include <stdio.h>
#include <string.h>#include <stdlib.h>
#include <sqlcli1.h>
#include "utilcli.h" /* Header file for CLI sample code */
int main(int argc, char *argv[])
{SQLRETURN cliRC = SQL_SUCCESS;
int rc = 0, i; SQLHANDLE henv; /* environment handle */ SQLHANDLE hdbc; /* connection handle */ SQLHANDLE hstmt; /* statement handle */char stmt[300]; /* SQL SELECT statement to be executed */
char dbAlias[SQL_MAX_DSN_LENGTH + 1]; char user[MAX_UID_LENGTH + 1]; char pswd[MAX_PWD_LENGTH + 1]; struct {SQLINTEGER ind;
SQLCHAR val[32];
}
name; /* variable to be bound to the NAME column */ struct {SQLINTEGER ind;
SQLCHAR val[1024];
}
value; /* variable to be bound to the VALUE column */
struct {SQLINTEGER ind;
SQLCHAR val[1024];
}
deferred_value; /* variable to be bound to the DEFERRED_VALUE column */ struct {SQLINTEGER ind;
SQLCHAR val[128];
}
datatype; /* variable to be bound to the DATATYPE column */ struct {SQLINTEGER ind;
SQLSMALLINT val;
}
dbpartitionnum; /* variable to be bound to the DBPARTITIONNUM column */ /* initializing the database name */ printf("the value of argc is %d/n",argc); if (argc < 4 ) { printf("/n Usage : getdbcfgparams <dbAlias user password >/n");rc = -1;
return rc;}
strcpy(dbAlias, argv[1]);
strcpy(user, argv[2]);
strcpy(pswd, argv[3]);
printf("/nTHIS SAMPLE SHOWS HOW TO GET DB CFG PARAMETERS "); printf("USING SYSIBMADM.DBCFG/n"); /* initialize the CLI application by calling a helper utility function defined in utilcli.c */rc = CLIAppInit(dbAlias,
user,
pswd,
&henv,
&hdbc,
(SQLPOINTER)SQL_AUTOCOMMIT_ON);
if (rc != 0) { return rc;}
/* SELECT NAME, VALUE, DEFERRED_VALUE, DATATYPE, DBPARTITIONNUM FROM SYSIBMADM.DBCFG WHERE NAME IN ( LIST) */ strcpy(stmt, "SELECT NAME, VALUE, DEFERRED_VALUE, DATATYPE,");strcat(stmt, " DBPARTITIONNUM FROM SYSIBMADM.DBCFG");// WHERE NAME") IN (");
//i = 4; //strcat(stmt, " '"); //strcat(stmt, argv[i]); //strcat(stmt, "' "); // for (i = 5; i < argc; i++) //{ //strcat(stmt, ", '"); //strcat(stmt, argv[i]); //strcat(stmt, "' "); // } //strcat(stmt, " )"); printf("/n-----------------------------------------------------------/n"); printf("/n%s/n", stmt); printf("/n-----------------------------------------------------------"); /* allocate a statement handle */cliRC = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
DBC_HANDLE_CHECK(hdbc, cliRC);
/* execute the statement */cliRC = SQLExecDirect(hstmt, (SQLCHAR *) stmt, SQL_NTS);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);
/* bind parameter name to variable */cliRC = SQLBindCol(hstmt, 1, SQL_C_CHAR, name.val, 32, &name.ind);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);
/* bind parameter value to variable */cliRC = SQLBindCol(hstmt, 2, SQL_C_CHAR, value.val, 1024, &value.ind);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);
/* bind deferred value to variable */cliRC = SQLBindCol(hstmt,
3,
SQL_C_CHAR,
deferred_value.val,
1024,
&deferred_value.ind);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);
/* bind data type to variable */cliRC = SQLBindCol(hstmt,
4,
SQL_C_CHAR,
datatype.val,
128,
&datatype.ind);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);
/* bind dbpartitionnum to variable */cliRC = SQLBindCol(hstmt,
5,
SQL_C_SHORT,
&dbpartitionnum.val,
0,
&dbpartitionnum.ind);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);
/* fetch each row and display */cliRC = SQLFetch(hstmt);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);
if (cliRC == SQL_NO_DATA_FOUND) { printf("/n Data not found./n");}
while (cliRC != SQL_NO_DATA_FOUND) { /* display each row */ printf("/n"); printf("Parameter Name = %s/n", name.val);printf("Parameter Value = %s/n", value.val);
printf("Parameter Deferred Value = %s/n", deferred_value.val); printf("Parameter Data Type = %s/n", datatype.val); printf("Database Partition Number = %d/n", dbpartitionnum.val); /* fetch next row */cliRC = SQLFetch(hstmt);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);
}
/* free the statement handle */cliRC = SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);
/* terminate the CLI application by calling a helper utility function defined in utilcli.c */rc = CLIAppTerm(&henv, &hdbc, dbAlias);
return rc;} /* end of main */运行该程序，其结果如下：
getdbcfgparams mydb sde esrichina
THIS SAMPLE SHOWS HOW TO GET DB CFG PARAMETERS USING SYSIBMADM.DBCFG
Connecting to mydb...
Connected to mydb.
-----------------------------------------------------------
SELECT NAME, VALUE, DEFERRED_VALUE, DATATYPE, DBPARTITIONNUM FROM SYSIBMADM.DBCFG
-----------------------------------------------------------
Parameter Name = app_ctl_heap_sz
Parameter Value = 256
Parameter Deferred Value = 256
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = appgroup_mem_sz
Parameter Value = 30000
Parameter Deferred Value = 30000
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = applheapsz
Parameter Value = 256
Parameter Deferred Value = 256
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = archretrydelay
Parameter Value = 20
Parameter Deferred Value = 20
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = auto_del_rec_obj
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = auto_maint
Parameter Value = ON
Parameter Deferred Value = ON
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = auto_db_backup
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = auto_tbl_maint
Parameter Value = ON
Parameter Deferred Value = ON
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = auto_runstats
Parameter Value = ON
Parameter Deferred Value = ON
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = auto_stmt_stats
Parameter Value = ON
Parameter Deferred Value = ON
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = auto_stats_prof
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = auto_prof_upd
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = auto_reorg
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = autorestart
Parameter Value = ON
Parameter Deferred Value = ON
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = auto_reval
Parameter Value = DEFERRED
Parameter Deferred Value = DEFERRED
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = avg_appls
Parameter Value = 1
Parameter Deferred Value = 1
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = blk_log_dsk_ful
Parameter Value = NO
Parameter Deferred Value = NO
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = blocknonlogged
Parameter Value = NO
Parameter Deferred Value = NO
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = buffpage
Parameter Value = 1000
Parameter Deferred Value = 1000
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = catalogcache_sz
Parameter Value = 300
Parameter Deferred Value = 300
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = chngpgs_thresh
Parameter Value = 80
Parameter Deferred Value = 80
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = database_memory
Parameter Value = 148020
Parameter Deferred Value = 148020
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = dbheap
Parameter Value = 2345
Parameter Deferred Value = 2345
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = dft_degree
Parameter Value = 1
Parameter Deferred Value = 1
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = dft_extent_sz
Parameter Value = 32
Parameter Deferred Value = 32
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = dft_loadrec_ses
Parameter Value = 1
Parameter Deferred Value = 1
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = dft_mttb_types
Parameter Value = SYSTEM
Parameter Deferred Value = SYSTEM
Parameter Data Type = VARCHAR(64)
Database Partition Number = 0
Parameter Name = dft_prefetch_sz
Parameter Value = 32
Parameter Deferred Value = 32
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = dft_queryopt
Parameter Value = 5
Parameter Deferred Value = 5
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = dft_refresh_age
Parameter Value = 0
Parameter Deferred Value = 0
Parameter Data Type = VARCHAR(20)
Database Partition Number = 0
Parameter Name = dft_sqlmathwarn
Parameter Value = NO
Parameter Deferred Value = NO
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = discover_db
Parameter Value = ENABLE
Parameter Deferred Value = ENABLE
Parameter Data Type = VARCHAR(8)
Database Partition Number = 0
Parameter Name = dlchktime
Parameter Value = 10000
Parameter Deferred Value = 10000
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = dyn_query_mgmt
Parameter Value = DISABLE
Parameter Deferred Value = DISABLE
Parameter Data Type = VARCHAR(8)
Database Partition Number = 0
Parameter Name = failarchpath
Parameter Value = DISABLE
Parameter Deferred Value = DISABLE
Parameter Data Type = VARCHAR(242)
Database Partition Number = 0
Parameter Name = groupheap_ratio
Parameter Value = 70
Parameter Deferred Value = 70
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = hadr_local_host
Parameter Value = 70
Parameter Deferred Value = 70
Parameter Data Type = VARCHAR(255)
Database Partition Number = 0
Parameter Name = hadr_local_svc
Parameter Value = 70
Parameter Deferred Value = 70
Parameter Data Type = VARCHAR(40)
Database Partition Number = 0
Parameter Name = hadr_remote_host
Parameter Value = 70
Parameter Deferred Value = 70
Parameter Data Type = VARCHAR(255)
Database Partition Number = 0
Parameter Name = hadr_remote_inst
Parameter Value = 70
Parameter Deferred Value = 70
Parameter Data Type = VARCHAR(8)
Database Partition Number = 0
Parameter Name = hadr_remote_svc
Parameter Value = 70
Parameter Deferred Value = 70
Parameter Data Type = VARCHAR(40)
Database Partition Number = 0
Parameter Name = hadr_syncmode
Parameter Value = NEARSYNC
Parameter Deferred Value = NEARSYNC
Parameter Data Type = VARCHAR(16)
Database Partition Number = 0
Parameter Name = hadr_timeout
Parameter Value = 120
Parameter Deferred Value = 120
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = hadr_peer_window
Parameter Value = 0
Parameter Deferred Value = 0
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = indexrec
Parameter Value = SYSTEM
Parameter Deferred Value = SYSTEM
Parameter Data Type = VARCHAR(32)
Database Partition Number = 0
Parameter Name = indexsort
Parameter Value = YES
Parameter Deferred Value = YES
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = locklist
Parameter Value = 4120
Parameter Deferred Value = 4120
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = locktimeout
Parameter Value = -1
Parameter Deferred Value = -1
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = logarchmeth1
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(251)
Database Partition Number = 0
Parameter Name = logarchmeth2
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(251)
Database Partition Number = 0
Parameter Name = logarchopt1
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(242)
Database Partition Number = 0
Parameter Name = logarchopt2
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(242)
Database Partition Number = 0
Parameter Name = logbufsz
Parameter Value = 256
Parameter Deferred Value = 256
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = logfilsiz
Parameter Value = 1024
Parameter Deferred Value = 1024
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = alt_collate
Parameter Value = 1024
Parameter Deferred Value = 1024
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = logindexbuild
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = logprimary
Parameter Value = 13
Parameter Deferred Value = 13
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = logretain
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(16)
Database Partition Number = 0
Parameter Name = logsecond
Parameter Value = 4
Parameter Deferred Value = 4
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = max_log
Parameter Value = 0
Parameter Deferred Value = 0
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = maxappls
Parameter Value = 40
Parameter Deferred Value = 40
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = maxfilop
Parameter Value = 61440
Parameter Deferred Value = 61440
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = maxlocks
Parameter Value = 97
Parameter Deferred Value = 97
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = min_dec_div_3
Parameter Value = NO
Parameter Deferred Value = NO
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = mincommit
Parameter Value = 1
Parameter Deferred Value = 1
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = mirrorlogpath
Parameter Value = 1
Parameter Deferred Value = 1
Parameter Data Type = VARCHAR(242)
Database Partition Number = 0
Parameter Name = newlogpath
Parameter Value = 1
Parameter Deferred Value = 1
Parameter Data Type = VARCHAR(1023)
Database Partition Number = 0
Parameter Name = num_db_backups
Parameter Value = 12
Parameter Deferred Value = 12
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = num_freqvalues
Parameter Value = 10
Parameter Deferred Value = 10
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = num_iocleaners
Parameter Value = 1
Parameter Deferred Value = 1
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = num_ioservers
Parameter Value = 3
Parameter Deferred Value = 3
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = num_log_span
Parameter Value = 0
Parameter Deferred Value = 0
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = num_quantiles
Parameter Value = 20
Parameter Deferred Value = 20
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = numarchretry
Parameter Value = 5
Parameter Deferred Value = 5
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = overflowlogpath
Parameter Value = 5
Parameter Deferred Value = 5
Parameter Data Type = VARCHAR(242)
Database Partition Number = 0
Parameter Name = pckcachesz
Parameter Value = 7835
Parameter Deferred Value = 7835
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = rec_his_retentn
Parameter Value = 366
Parameter Deferred Value = 366
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = self_tuning_mem
Parameter Value = ON (Active)
Parameter Deferred Value = ON
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = seqdetect
Parameter Value = YES
Parameter Deferred Value = YES
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = sheapthres_shr
Parameter Value = 1286
Parameter Deferred Value = 1286
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = softmax
Parameter Value = 520
Parameter Deferred Value = 520
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = sortheap
Parameter Value = 257
Parameter Deferred Value = 257
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = stat_heap_sz
Parameter Value = 4384
Parameter Deferred Value = 4384
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = stmtheap
Parameter Value = 6402
Parameter Deferred Value = 4096
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = trackmod
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = tsm_mgmtclass
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(30)
Database Partition Number = 0
Parameter Name = tsm_nodename
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(64)
Database Partition Number = 0
Parameter Name = tsm_owner
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(64)
Database Partition Number = 0
Parameter Name = tsm_password
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(64)
Database Partition Number = 0
Parameter Name = userexit
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = util_heap_sz
Parameter Value = 12862
Parameter Deferred Value = 12862
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = vendoropt
Parameter Value = 12862
Parameter Deferred Value = 12862
Parameter Data Type = VARCHAR(242)
Database Partition Number = 0
Parameter Name = backup_pending
Parameter Value = NO
Parameter Deferred Value = NO
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = codepage
Parameter Value = 1208
Parameter Deferred Value = 1208
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = codeset
Parameter Value = UTF-8
Parameter Deferred Value = UTF-8
Parameter Data Type = VARCHAR(17)
Database Partition Number = 0
Parameter Name = collate_info
Parameter Value = UTF-8
Parameter Deferred Value = UTF-8
Parameter Data Type = VARCHAR(260)
Database Partition Number = 0
Parameter Name = country
Parameter Value = 86
Parameter Deferred Value = 86
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = database_consistent
Parameter Value = NO
Parameter Deferred Value = NO
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = database_level
Parameter Value = 0x0d00
Parameter Deferred Value = 0x0d00
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = hadr_db_role
Parameter Value = STANDARD
Parameter Deferred Value = STANDARD
Parameter Data Type = VARCHAR(16)
Database Partition Number = 0
Parameter Name = log_retain_status
Parameter Value = NO
Parameter Deferred Value = NO
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = loghead
Parameter Value = NO
Parameter Deferred Value = NO
Parameter Data Type = VARCHAR(1023)
Database Partition Number = 0
Parameter Name = logpath
Parameter Value = /home/db2inst1/db2inst1/NODE0000/SQL00002/SQLOGDIR/
Parameter Deferred Value = /home/db2inst1/db2inst1/NODE0000/SQL00002/SQLOGDIR/
Parameter Data Type = VARCHAR(1023)
Database Partition Number = 0
Parameter Name = multipage_alloc
Parameter Value = YES
Parameter Deferred Value = YES
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = numsegs
Parameter Value = 1
Parameter Deferred Value = 1
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = pagesize
Parameter Value = 4096
Parameter Deferred Value = 4096
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = release
Parameter Value = 0x0d00
Parameter Deferred Value = 0x0d00
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = restore_pending
Parameter Value = NO
Parameter Deferred Value = NO
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = rollfwd_pending
Parameter Value = NO
Parameter Deferred Value = NO
Parameter Data Type = VARCHAR(16)
Database Partition Number = 0
Parameter Name = territory
Parameter Value = CN
Parameter Deferred Value = CN
Parameter Data Type = VARCHAR(33)
Database Partition Number = 0
Parameter Name = user_exit_status
Parameter Value = NO
Parameter Deferred Value = NO
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = db_mem_thresh
Parameter Value = 10
Parameter Deferred Value = 10
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = db_collname
Parameter Value = IDENTITY
Parameter Deferred Value = IDENTITY
Parameter Data Type = VARCHAR(128)
Database Partition Number = 0
Parameter Name = enable_xmlchar
Parameter Value = YES
Parameter Deferred Value = YES
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = restrict_access
Parameter Value = NO
Parameter Deferred Value = NO
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = appl_memory
Parameter Value = 40016
Parameter Deferred Value = 40000
Parameter Data Type = BIGINT
Database Partition Number = 0
Parameter Name = wlm_collect_int
Parameter Value = 0
Parameter Deferred Value = 0
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = decflt_rounding
Parameter Value = ROUND_HALF_EVEN
Parameter Deferred Value = ROUND_HALF_EVEN
Parameter Data Type = VARCHAR(16)
Database Partition Number = 0
Parameter Name = number_compat
Parameter Value = ON
Parameter Deferred Value = ON
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = varchar2_compat
Parameter Value = ON
Parameter Deferred Value = ON
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = date_compat
Parameter Value = ON
Parameter Deferred Value = ON
Parameter Data Type = VARCHAR(3)
Database Partition Number = 0
Parameter Name = cur_commit
Parameter Value = ON
Parameter Deferred Value = ON
Parameter Data Type = VARCHAR(16)
Database Partition Number = 0
Parameter Name = smtp_server
Parameter Value = ON
Parameter Deferred Value = ON
Parameter Data Type = VARCHAR(255)
Database Partition Number = 0
Parameter Name = mon_req_metrics
Parameter Value = BASE
Parameter Deferred Value = BASE
Parameter Data Type = VARCHAR(8)
Database Partition Number = 0
Parameter Name = mon_act_metrics
Parameter Value = BASE
Parameter Deferred Value = BASE
Parameter Data Type = VARCHAR(8)
Database Partition Number = 0
Parameter Name = mon_obj_metrics
Parameter Value = BASE
Parameter Deferred Value = BASE
Parameter Data Type = VARCHAR(8)
Database Partition Number = 0
Parameter Name = mon_uow_data
Parameter Value = NONE
Parameter Deferred Value = NONE
Parameter Data Type = VARCHAR(8)
Database Partition Number = 0
Parameter Name = mon_locktimeout
Parameter Value = NONE
Parameter Deferred Value = NONE
Parameter Data Type = VARCHAR(16)
Database Partition Number = 0
Parameter Name = mon_deadlock
Parameter Value = WITHOUT_HIST
Parameter Deferred Value = WITHOUT_HIST
Parameter Data Type = VARCHAR(16)
Database Partition Number = 0
Parameter Name = mon_lockwait
Parameter Value = NONE
Parameter Deferred Value = NONE
Parameter Data Type = VARCHAR(16)
Database Partition Number = 0
Parameter Name = mon_lw_thresh
Parameter Value = 5000000
Parameter Deferred Value = 5000000
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = mon_pkglist_sz
Parameter Value = 32
Parameter Deferred Value = 32
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = mon_lck_msg_lvl
Parameter Value = 1
Parameter Deferred Value = 1
Parameter Data Type = INTEGER
Database Partition Number = 0
Parameter Name = sql_ccflags
Parameter Value = 1
Parameter Deferred Value = 1
Parameter Data Type = VARCHAR(1023)
Database Partition Number = 0
Parameter Name = stmt_conc
Parameter Value = OFF
Parameter Deferred Value = OFF
Parameter Data Type = VARCHAR(8)
Database Partition Number = 0
Parameter Name = section_actuals
Parameter Value = NONE
Parameter Deferred Value = NONE
Parameter Data Type = VARCHAR(8)
Database Partition Number = 0
Disconnecting from mydb...
Disconnected from mydb.
- 获取DB2数据库参数的方法
- DB2 数据库获取日期方法
- DB2学习笔记 --- python连接db2的connection方法参数
- DB2 数据库系统配置参数
- 获取方法的参数
- DB2跨数据库访问表的方法
- DB2跨数据库访问表的方法
- DB2跨数据库访问表的方法
- DB2停止单个数据库的方法
- JAVA连接DB2数据库的方法
- db2数据库跟踪方法
- 获取db2数据库得大小
- db2如何获取当前连接的数据库信息
- db2 参数的配置
- PHP 获取参数的方法
- 时间的获取方法参数
- 获取url参数的方法
- struts2获取参数的方法
- java 线程Thread.Sleep详解(转)
- 检测网站seo做得如何？
- 希望自己的积分很多。
- 上传单个附件，修改，删除
- Linux 中 怎么配置开机启动的服务？
- 获取DB2数据库参数的方法
- javascript获取高度
- USACO算法系列四十三——theme
- 正则表达式语法
- LINQ TO SQLite实践指南
- 哪里有从零开始的vb教程 最好打成包可以下载的
- Symbian手机 如何取消桌面壁纸？
- HTTP是怎样工作的
- Commend word
