获取DB2数据库参数的方法

0
分享 2015-12-18
共有两种获取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 0xd00
Database
release level
0xd00 0xd00
Database
territory CN CN
Database
code page 1208 1208
Database
code set
UTF-8 UTF-8
Database
country/region code 86 86
Database
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 YES
Log 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) OFF

LOGARCHMETH1 (disk
) OFF

LOGARCHOPT1
LOGARCHMETH2 (memory) OFF

LOGARCHMETH2 (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 cfg

Database
Configuration for
Database


Database
configuration release level
= 0x0d00
Database
release level
= 0x0d00

Database
territory = CN
Database
code page = 1208
Database
code set
= UTF-8
Database
country/region code = 86
Database
collating sequence
= IDENTITY

Alternate collating sequence
(ALT_COLLATE) =
Number compatibility = ON

Varchar2 compatibility = ON

Date
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) = 1
Continue
upon arithmetic exceptions (DFT_SQLMATHWARN) = NO

Default
refresh age (DFT_REFRESH_AGE) = 0
Default
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_EVEN

Backup
pending = NO


All
committed transactions have been written to
disk
= NO

Rollforward pending = NO

Restore
pending = NO


Multi-page file
allocation enabled = YES

Log retain for
recovery status = NO

User
exit
for
logging status = NO


Self tuning memory (SELF_TUNING_MEM) = ON

Size
of
database
shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(148020)
Database
memory threshold (DB_MEM_THRESH) = 10
Max
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) = 1000
SQL
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) = YES
Sequential detect flag (SEQDETECT) = YES
Default
prefetch size
(pages) (DFT_PREFETCH_SZ) = AUTOMATIC

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(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) = 4
Changed 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) = NO

Percent
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) = NEARSYNC
HADR 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) = ON

Index
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) = ON

Automatic database
backup
(AUTO_DB_BACKUP) = OFF

Automatic table
maintenance (AUTO_TBL_MAINT) = ON

Automatic runstats (AUTO_RUNSTATS) = ON

Automatic 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) = ON

CHAR
output
with
DECIMAL
input
(DEC_TO_CHAR_FMT) = NEW

Enable XML Character
operations (ENABLE_XMLCHAR) = YES
WLM Collection Interval
(minutes) (WLM_COLLECT_INT) = 0
Monitor Collect Settings
Request metrics (MON_REQ_METRICS) = BASE
Activity metrics (MON_ACT_METRICS) = BASE
Object
metrics (MON_OBJ_METRICS) = BASE
Unit of
work
events (MON_UOW_DATA) = NONE

Lock timeout events (MON_LOCKTIMEOUT) = NONE

Deadlock events (MON_DEADLOCK) = WITHOUT_HIST
Lock wait events (MON_LOCKWAIT) = NONE

Lock wait event threshold (MON_LW_THRESH) = 5000000
Number of
package list entries (MON_PKGLIST_SZ) = 32
Lock event notification level
(MON_LCK_MSG_LVL) = 1

SMTP 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,
&amp;henv,
&amp;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, &amp;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, &amp;name.ind);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);

/* bind parameter value to variable */

cliRC = SQLBindCol(hstmt, 2, SQL_C_CHAR, value
.val, 1024, &amp;value
.ind);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);

/* bind deferred value to variable */

cliRC = SQLBindCol(hstmt,
3,
SQL_C_CHAR,
deferred_value.val,
1024,
&amp;deferred_value.ind);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);

/* bind data type to variable */

cliRC = SQLBindCol(hstmt,
4,
SQL_C_CHAR,
datatype.val,
128,
&amp;datatype.ind);
STMT_HANDLE_CHECK(hstmt, hdbc, cliRC);

/* bind dbpartitionnum to variable */

cliRC = SQLBindCol(hstmt,
5,
SQL_C_SHORT,
&amp;dbpartitionnum.val,
0,
&amp;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(&amp;henv, &amp;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)
Databas

0 个评论

要回复文章请先登录注册