关闭

获取DB2数据库参数的方法

标签: db2数据库databasesqlapplicationstatistics
2516人阅读 评论(0) 收藏 举报
分类:

共有两种获取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,
                  &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.

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:389352次
    • 积分:4972
    • 等级:
    • 排名:第5679名
    • 原创:120篇
    • 转载:2篇
    • 译文:0篇
    • 评论:35条
    最新评论