获取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                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.

原创粉丝点击
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防,我是瞎子 电力专用光缆撞了怎么办 国防电缆挖断了怎么办 国防光缆挖断了怎么办 房门前乱挂光纤线影响住户怎么办 挂断低于限高的光缆怎么办 开大车挂住光缆怎么办 风把树枝挂断压到车该怎么办 货车柴油冻住了怎么办 尖头鞋老是折尖怎么办 打 氟氯西林疼怎么办 多余的十字绣线怎么办 硅胶类的东西沾到蓝药水怎么办? ph计斜率不到90怎么办 ph计斜率低于90怎么办 顾客说衣服起球怎么办 买的手机壳太滑怎么办 硅胶手机壳太滑怎么办 磨砂手机壳太滑怎么办 被热胶棒烫了怎么办 车钢垫子次了怎么办 【图】机组主轴密封漏水怎么办? 孕妇吃了好多杏怎么办 怀孕6个月吃了好多杏怎么办 白色纯棉衣服染色了怎么办 红色硅胶壳黑了怎么办 小米6gps信号弱怎么办 网线头卡子断了怎么办 入户网线太短了怎么办 孩子弹钢琴大拇指出琴键怎么办 手指肿胀疼痛变粗怎么办 iphone系统占用内存大怎么办 手机系统占用内存大怎么办 头盔固定配件掉了怎么办 移动4g网络不好怎么办 wifi登录密码忘记了怎么办 电脑登录密码忘记了怎么办 笔记本电脑登录密码忘记了怎么办 信用卡登录密码忘记了怎么办 华为p9后置摄像头模糊怎么办 手机图片文件夹删了怎么办 发票系统导出的xml怎么办