Documentation
Documentation generated on: 10/29/2008 10:31:48 PM
Database objects
System information
| name | value |
|---|
| operating system | WIN32_NT
|
| operating system version | 5.1
|
| operating system release | Service Pack 3
|
| host name | SUMMER
|
| total cpus | 1
|
| configured cpus | 2
|
| total memory | 2048 mb |
Instance information
| name | value |
|---|
| instance name | DB2
|
| is instance partitionable | 0
|
| partions | 1
|
| architecture | 32 bit |
| release number | 02010107
|
| service level | DB2 v9.1.0.356
|
| build level | s060629
|
| program temporary fix | NT32
|
| fixpack number | 0
|
Product information
| name | value |
|---|
| installed product | EXP
|
| licensed | 1
|
| release | 9.1
|
Configuration
| name | value in memory | value on disk |
|---|
| AGENT_STACK_SZ
| 16
| 16
|
| AGENTPRI
| -1
| -1
|
| ASLHEAPSZ
| 15
| 15
|
| AUDIT_BUF_SZ
| 0
| 0
|
| AUTHENTICATION
| 0
| 0
|
| BACKBUFSZ
| 1024
| 1024
|
| CATALOG_NOAUTH
| 0
| 0
|
| COMM_BANDWIDTH
| 0
| 0
|
| CONN_ELAPSE
| 0
| 0
|
| CPUSPEED
| 2.361721E-07
| 2.361721E-07
|
| DATALINKS
| 0
| 0
|
| DFT_ACCOUNT_STR
|
|
|
| DFT_CLIENT_ADPT
| 0
| 0
|
| DFT_CLIENT_COMM
|
|
|
| DFT_MONSWITCHES
| 64
| 64
|
| DFT_MON_BUFPOOL
| 0
| 0
|
| DFT_MON_LOCK
| 0
| 0
|
| DFT_MON_SORT
| 0
| 0
|
| DFT_MON_STMT
| 0
| 0
|
| DFT_MON_TABLE
| 0
| 0
|
| DFT_MON_UOW
| 0
| 0
|
| DFTDBPATH
| C:
| C:
|
| DIAGLEVEL
| 3
| 3
|
| DIAGPATH
|
|
|
| DIR_CACHE
| 1
| 1
|
| DIR_OBJ_NAME
|
|
|
| DIR_PATH_NAME
| /.:/subsys/database/
| /.:/subsys/database/
|
| DIR_TYPEC
| 0
| 0
|
| DISCOVERD
| 2
| 2
|
| DISCOVER_COMM
|
|
|
| DISCOVER_INST
| 1
| 1
|
| DOS_RQRIOBLK
| 4096
| 4096
|
| DRDA_HEAP_SZ
| 128
| 128
|
| FCM_NUM_ANCHORS
| 0
| 0
|
| FCM_NUM_BUFFERS
| 0
| 1024
|
| FCM_NUM_CONNECT
| 0
| 0
|
| FCM_NUM_RQB
| 0
| 0
|
| FEDERATED
| 0
| 0
|
| FILESERVER
|
|
|
| INDEXRECE
| 2
| 2
|
| INITDARI_JVM
| 0
| 0
|
| INTRA_PARALLEL
| 0
| 0
|
| IPX_SOCKET
| 879E
| 879E
|
| JAVA_HEAP_SZ
| 512
| 512
|
| JDK11_PATH
| C:\Program Files\IBM\SQLLIB\java\jdk
| C:\Program Files\IBM\SQLLIB\java\jdk
|
| KEEPDARI
| 1
| 1
|
| MAX_CONNRETRIES
| 0
| 0
|
| MAX_COORDAGENTS
| 200
| -1
|
| MAX_LOGICAGENTS
| -3801088
| 0
|
| MAX_QUERYDEGREE
| -1
| -1
|
| MAX_TIME_DIFF
| 0
| 0
|
| MAXAGENTS
| 200
| 200
|
| MAXCAGENTS
| 200
| -1
|
| MAXDARI
| -1
| -1
|
| MAXTOTFILOP
| 16000
| 16000
|
| MIN_PRIV_MEM
| 32
| 32
|
| MON_HEAP_SZ
| 66
| 66
|
| NNAME
|
|
|
| NOTIFYLEVEL
| 3
| 3
|
| NUM_INITAGENTS
| 0
| 0
|
| NUM_INITDARIS
| 0
| 0
|
| NUM_POOLAGENTS
| 100
| -1
|
| NUMDB
| 8
| 8
|
| OBJECTNAME
|
|
|
| PRIV_MEM_THRESH
| 20000
| 20000
|
| QUERY_HEAP_SZ
| 1000
| 1000
|
| RESTBUFSZ
| 1024
| 1024
|
| RESYNC_INTERVAL
| 180
| 180
|
| ROUTE_OBJ_NAME
|
|
|
| RQRIOBLK
| 32767
| 32767
|
| SHEAPTHRES
| 0
| 0
|
| SPM_LOG_FILE_SZ
| 256
| 256
|
| SPM_MAX_RESYNC
| 20
| 20
|
| SPM_NAME
| SUMMER
| SUMMER
|
| SPM_PATH_NAME
|
|
|
| SS_LOGON
| 1
| 1
|
| START_STOP_TIME
| 10
| 10
|
| SVCENAME
| db2c_DB2
| db2c_DB2
|
| SYSADM_GROUP
|
|
|
| SYSCTRL_GROUP
|
|
|
| SYSMAINT_GROUP
|
|
|
| TM_DATABASE
| 1ST_CONN
| 1ST_CONN
|
| TP_MON_NAME
|
|
|
| TPNAME
|
|
|
| TRUST_ALLCLNTSF
| 1
| 1
|
| TRUST_CLNTAUTH
| 0
| 0
|
| UDF_MEM_SZ
| 256
| 256
|
| NODETYPE
| 1
| 1
|
| RELEASE
| 2816
| 2816
|
| PLUGIN_MODE
| 1
| 1
|
| GROUP_PLUGIN
|
|
|
| CLNT_PW_PLUGIN
|
|
|
| CLNT_KRB_PLUGIN
| IBMkrb5
| IBMkrb5
|
| SRVCON_PW_PLUGIN
|
|
|
| SRVCON_GSSPLUGIN_LIST
|
|
|
| SRVCON_AUTH
| 255
| 255
|
| LOCAL_GSSPLUGIN
|
|
|