获取DB2数据库参数的方法

来源:互联网 发布:人工智能剧情介绍 编辑:程序博客网 时间:2024/06/16 01:00

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

原创粉丝点击